@Test
  public void testSUBSTRHplSQLFunction2() throws Throwable {
    String scriptText = "SELECT SUBSTR('Remark', 3, 3);";
    testScriptFile(scriptText, args(), "mar");
  }
Start up a local Hive Server 2 for these tests
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestHplSqlViaBeeLine.java