@Test
  public void testUdfTimestamp() throws Throwable {
    String scriptText =
        "DROP TABLE IF EXISTS result;\n" +
            "CREATE TABLE result (col_t timestamp);\n" +
            "INSERT INTO result VALUES('2022-11-24 10:20:30');\n" +
            "INSERT INTO result VALUES('2022-12-25 06:30:30');\n" +
            "CREATE FUNCTION time_today(t timestamp)\n" +
            "   RETURNS timestamp\n" +
            "BEGIN\n" +
            "   RETURN t;\n" +
            "END;\n" +
            "SELECT time_today(col_t) FROM result;\n";
    testScriptFile(scriptText, args(), "2022-11-24 10:20:30.*2022-12-25 06:30:30");
  }
Start up a local Hive Server 2 for these tests
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestHplSqlViaBeeLine.java