@Test
  public void testUdfFloat() throws Throwable {
    String scriptText =
        "DROP TABLE IF EXISTS result;\n" +
            "CREATE TABLE result (col_f float);\n" +
            "INSERT INTO result VALUES(12345.6789);\n" +
            "INSERT INTO result VALUES(98765.4321);\n" +
            "CREATE FUNCTION dbl(f float)\n" +
            "   RETURNS float\n" +
            "BEGIN\n" +
            "   RETURN f * 2;\n" +
            "END;\n" +
            "SELECT dbl(col_f) FROM result;\n";
    testScriptFile(scriptText, args(), "24691.357421875.*197530.859375");
  }
Start up a local Hive Server 2 for these tests
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestHplSqlViaBeeLine.java