Examples with OdpsStatementParser com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser used on opensource projects

Example 21 with OdpsStatementParser

use of com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser in project druid by alibaba.

the class OdpsCreateViewTest method test_create_comments.

public void test_create_comments() throws Exception {
    String sql = "CREATE view if not exists sale_detail comment 'aaaa' as select * from dual;";
    OdpsStatementParser parser = new OdpsStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toOdpsString(stmt);
    Assert.assertEquals(//
    "CREATE VIEW IF NOT EXISTS sale_detail" + //
    "\nCOMMENT 'aaaa'" + //
    "\nAS" + //
    "\nSELECT *" + "\nFROM dual", output);
}

Example 22 with OdpsStatementParser

use of com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser in project druid by alibaba.

the class OdpsDescTest method test_0.

public void test_0() throws Exception {
    String sql = "desc coupon_dataset_4_feature";
    OdpsStatementParser parser = new OdpsStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toOdpsString(stmt);
    stmt.toString();
    System.out.println(output);
    Assert.assertEquals("DESC coupon_dataset_4_feature", output);
}

Example 23 with OdpsStatementParser

use of com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser in project druid by alibaba.

the class OdpsListTest method test_3.

public void test_3() throws Exception {
    String sql = "list resources";
    OdpsStatementParser parser = new OdpsStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toOdpsString(stmt);
    // System.out.println(output);
    Assert.assertEquals("LIST resources", output);
}

Example 24 with OdpsStatementParser

use of com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser in project druid by alibaba.

the class OdpsListTest method test_0.

public void test_0() throws Exception {
    String sql = "list roles";
    OdpsStatementParser parser = new OdpsStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toOdpsString(stmt);
    // System.out.println(output);
    Assert.assertEquals("LIST roles", output);
}

Example 25 with OdpsStatementParser

use of com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser in project druid by alibaba.

the class OdpsListTest method test_5.

public void test_5() throws Exception {
    String sql = "list jobs";
    OdpsStatementParser parser = new OdpsStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toOdpsString(stmt);
    // System.out.println(output);
    Assert.assertEquals("LIST jobs", output);
}