@Test
  public void testHplSqlProcedureWithAllDefaultParamsCallingWithNamedParameterBinding() throws Throwable {
    String scriptText =
        "DROP TABLE IF EXISTS result;\n" +
            "CREATE TABLE result (s string);\n" +
            "CREATE PROCEDURE p1(s1 STRING default 'Default S1', s2 string default 'Default S2')\n" +
            "BEGIN\n" +
            "INSERT INTO result VALUES(s1 || '=' || s2);\n" +
            "END;\n" +
            "p1(s2 => 'PassedValue S2');\n" +
            "SELECT * FROM result;" ;
    testScriptFile(scriptText, args(), "Default S1=PassedValue S2");
  }
Start up a local Hive Server 2 for these tests
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestHplSqlViaBeeLine.java