/**
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.hadoop.hive.ql.udf.generic;
import java.sql.Date;
import java.sql.Timestamp;
import org.apache.hadoop.hive.ql.metadata.HiveException;
import org.apache.hadoop.hive.ql.udf.generic.GenericUDF.DeferredJavaObject;
import org.apache.hadoop.hive.ql.udf.generic.GenericUDF.DeferredObject;
import org.apache.hadoop.hive.serde2.io.DateWritable;
import org.apache.hadoop.hive.serde2.io.TimestampWritable;
import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorFactory;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.Text;
import junit.framework.TestCase;
public class TestGenericUDFToUnixTimestamp extends TestCase {
public static void runAndVerify(GenericUDFToUnixTimeStamp udf,
Object arg, Object expected) throws HiveException {
DeferredObject[] args = { new DeferredJavaObject(arg) };
Object result = udf.evaluate(args);
if (expected == null) {
assertNull(result);
} else {
assertEquals(expected.toString(), result.toString());
}
}
public static void runAndVerify(GenericUDFToUnixTimeStamp udf,
Object arg1, Object arg2, Object expected) throws HiveException {
DeferredObject[] args = { new DeferredJavaObject(arg1), new DeferredJavaObject(arg2) };
Object result = udf.evaluate(args);
if (expected == null) {
assertNull(result);
} else {
assertEquals(expected.toString(), result.toString());
}
}
public void testTimestamp() throws HiveException {
GenericUDFToUnixTimeStamp udf = new GenericUDFToUnixTimeStamp();
ObjectInspector valueOI = PrimitiveObjectInspectorFactory.writableTimestampObjectInspector;
ObjectInspector[] arguments = {valueOI};
udf.initialize(arguments);
Timestamp ts = Timestamp.valueOf("1970-01-01 00:00:00");
runAndVerify(udf,
new TimestampWritable(ts),
new LongWritable(ts.getTime() / 1000));
ts = Timestamp.valueOf("2001-02-03 01:02:03");
runAndVerify(udf,
new TimestampWritable(ts),
new LongWritable(ts.getTime() / 1000));
// test null values
runAndVerify(udf, null, null);
}
public void testDate() throws HiveException {
GenericUDFToUnixTimeStamp udf = new GenericUDFToUnixTimeStamp();
ObjectInspector valueOI = PrimitiveObjectInspectorFactory.writableDateObjectInspector;
ObjectInspector[] arguments = {valueOI};
udf.initialize(arguments);
Date date = Date.valueOf("1970-01-01");
runAndVerify(udf,
new DateWritable(date),
new LongWritable(date.getTime() / 1000));
// test null values
runAndVerify(udf, null, null);
}
public void testString() throws HiveException {
GenericUDFToUnixTimeStamp udf1 = new GenericUDFToUnixTimeStamp();
ObjectInspector valueOI = PrimitiveObjectInspectorFactory.writableStringObjectInspector;
ObjectInspector[] arguments = {valueOI};
udf1.initialize(arguments);
String val = "2001-01-01 01:02:03";
runAndVerify(udf1,
new Text(val),
new LongWritable(Timestamp.valueOf(val).getTime() / 1000));
// test null values
runAndVerify(udf1, null, null);
// Try 2-arg version
GenericUDFToUnixTimeStamp udf2 = new GenericUDFToUnixTimeStamp();
ObjectInspector[] args2 = {valueOI, valueOI};
udf2.initialize(args2);
val = "2001-01-01";
String format = "yyyy-MM-dd";
runAndVerify(udf2,
new Text(val),
new Text(format),
new LongWritable(Date.valueOf(val).getTime() / 1000));
// test null values
runAndVerify(udf2, null, null, null);
runAndVerify(udf2, null, new Text(format), null);
runAndVerify(udf2, new Text(val), null, null);
}
}