-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestSubquery.java
More file actions
27 lines (20 loc) · 988 Bytes
/
Copy pathtestSubquery.java
File metadata and controls
27 lines (20 loc) · 988 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
package impala;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.TCreateTableSqlStatement;
import gudusoft.gsqlparser.stmt.TSelectSqlStatement;
import junit.framework.TestCase;
public class testSubquery extends TestCase {
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvimpala);
sqlparser.sqltext = "create table test.concat \n" +
"as select concat(heroes.name,' vs. ',villains.name) as battle \n" +
"from heroes \n" +
"join villains \n" +
"where heroes.era = villains.era and heroes.planet = villains.planet";
assertTrue(sqlparser.parse() == 0);
TCreateTableSqlStatement createTable = (TCreateTableSqlStatement)sqlparser.sqlstatements.get(0);
TSelectSqlStatement select = createTable.getSubQuery();
System.out.println(select.toString());
}
}