/** * 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); } }