TestGenericUDFLastDay.java example

Explorer
hive-master
/**
 * 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.Timestamp;

import junit.framework.TestCase;

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.TimestampWritable;
import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorFactory;
import org.apache.hadoop.io.Text;

public class TestGenericUDFLastDay extends TestCase {

  public void testLastDay() throws HiveException {
    GenericUDFLastDay udf = new GenericUDFLastDay();
    ObjectInspector valueOI0 = PrimitiveObjectInspectorFactory.writableStringObjectInspector;
    ObjectInspector[] arguments = { valueOI0 };

    udf.initialize(arguments);

    // date str
    runAndVerify("2014-01-01", "2014-01-31", udf);
    runAndVerify("2014-01-14", "2014-01-31", udf);
    runAndVerify("2014-01-31", "2014-01-31", udf);
    runAndVerify("2014-02-02", "2014-02-28", udf);
    runAndVerify("2014-02-28", "2014-02-28", udf);
    runAndVerify("2016-02-03", "2016-02-29", udf);
    runAndVerify("2016-02-28", "2016-02-29", udf);
    runAndVerify("2016-02-29", "2016-02-29", udf);
    //wrong date str
    runAndVerify("2016-02-30", "2016-03-31", udf);
    runAndVerify("2014-01-32", "2014-02-28", udf);
    runAndVerify("01/14/2014", null, udf);
    runAndVerify(null, null, udf);

    // ts str
    runAndVerify("2014-01-01 10:30:45", "2014-01-31", udf);
    runAndVerify("2014-01-14 10:30:45", "2014-01-31", udf);
    runAndVerify("2014-01-31 10:30:45.1", "2014-01-31", udf);
    runAndVerify("2014-02-02 10:30:45.100", "2014-02-28", udf);
    runAndVerify("2014-02-28 10:30:45.001", "2014-02-28", udf);
    runAndVerify("2016-02-03 10:30:45.000000001", "2016-02-29", udf);
    runAndVerify("2016-02-28 10:30:45", "2016-02-29", udf);
    runAndVerify("2016-02-29 10:30:45", "2016-02-29", udf);
    // wrong ts str
    runAndVerify("2016-02-30 10:30:45", "2016-03-31", udf);
    runAndVerify("2014-01-32 10:30:45", "2014-02-28", udf);
    runAndVerify("01/14/2014 10:30:45", null, udf);
    runAndVerify("2016-02-28T10:30:45", "2016-02-29", udf);
    // negative Unix time
    runAndVerifyTs("1966-01-31 00:00:01", "1966-01-31", udf);
    runAndVerifyTs("1966-01-31 10:00:01", "1966-01-31", udf);
    runAndVerifyTs("1966-01-31 23:59:59", "1966-01-31", udf);
  }

  public void testLastDayTs() throws HiveException {
    GenericUDFLastDay udf = new GenericUDFLastDay();
    ObjectInspector valueOI0 = PrimitiveObjectInspectorFactory.writableTimestampObjectInspector;
    ObjectInspector[] arguments = { valueOI0 };

    udf.initialize(arguments);
    // positive Unix time
    runAndVerifyTs("2014-01-01 10:30:45", "2014-01-31", udf);
    runAndVerifyTs("2014-01-14 10:30:45", "2014-01-31", udf);
    runAndVerifyTs("2014-01-31 10:30:45.1", "2014-01-31", udf);
    runAndVerifyTs("2014-02-02 10:30:45.100", "2014-02-28", udf);
    runAndVerifyTs("2014-02-28 10:30:45.001", "2014-02-28", udf);
    runAndVerifyTs("2016-02-03 10:30:45.000000001", "2016-02-29", udf);
    runAndVerifyTs("2016-02-28 10:30:45", "2016-02-29", udf);
    runAndVerifyTs("2016-02-29 10:30:45", "2016-02-29", udf);
    // negative Unix time
    runAndVerifyTs("1966-01-31 00:00:01", "1966-01-31", udf);
    runAndVerifyTs("1966-01-31 10:00:01", "1966-01-31", udf);
    runAndVerifyTs("1966-01-31 23:59:59", "1966-01-31", udf);
  }

  private void runAndVerify(String str, String expResult, GenericUDF udf)
      throws HiveException {
    DeferredObject valueObj0 = new DeferredJavaObject(str != null ? new Text(str) : null);
    DeferredObject[] args = { valueObj0 };
    Text output = (Text) udf.evaluate(args);
    assertEquals("last_day() test ", expResult, output != null ? output.toString() : null);
  }

  private void runAndVerifyTs(String str, String expResult, GenericUDF udf) throws HiveException {
    DeferredObject valueObj0 = new DeferredJavaObject(str != null ? new TimestampWritable(
        Timestamp.valueOf(str)) : null);
    DeferredObject[] args = { valueObj0 };
    Text output = (Text) udf.evaluate(args);
    assertEquals("last_day() test ", expResult, output != null ? output.toString() : null);
  }
}