@Test
  public void testCASTHplSqlFunction3() throws Throwable {
    String SCRIPT_TEXT = "SELECT CAST(DATE '2023-05-29' AS CHAR(4));";
    testScriptFile(SCRIPT_TEXT, args(), "2023");
  }
Start up a local Hive Server 2 for these tests
itests/hive-unit/src/test/java/org/apache/hive/beeline/TestHplSqlViaBeeLine.java