http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_11.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_11.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_11.sql new file mode 100644 index 0000000..25daeb0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_11.sql @@ -0,0 +1 @@ +select * from x, y, (select * from a, b, c WHERE something) as ss where somethingelse \ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_12.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_12.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_12.sql new file mode 100644 index 0000000..26808a5 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_12.sql @@ -0,0 +1 @@ +select name, addr from people join student on x = y join professor on l = m \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_13.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_13.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_13.sql new file mode 100644 index 0000000..adf72c8 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_13.sql @@ -0,0 +1,13 @@ +select * +from table1 +cross join table2 +join table3 on table1.id = table3.id +inner join table4 on table1.id = table4.id +left outer join table5 on table1.id = table5.id +right outer join table6 on table1.id = table6.id +full outer join table7 on table1.id = table7.id +join table8 on table1.id = table8.id +inner join table9 on table1.id = table9.id +left outer join table10 on table1.id = table10.id +right outer join table11 on table1.id = table11.id +full outer join table12 on table1.id = table12.id \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_14.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_14.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_14.sql new file mode 100644 index 0000000..21c7099 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_14.sql @@ -0,0 +1 @@ +select * from a cross join b cross join c cross join d cross join e \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_15.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_15.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_15.sql new file mode 100644 index 0000000..800ec8b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_15.sql @@ -0,0 +1 @@ +select * from x join y on x.id = y.id join (select * from a join b on a.age = b.age join c on a.sex = c.sex) as ss on x.id = ss.id \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_2.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_2.sql new file mode 100644 index 0000000..03056ac --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_2.sql @@ -0,0 +1 @@ +select name, addr from people inner join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_3.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_3.sql new file mode 100644 index 0000000..22281fe --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_3.sql @@ -0,0 +1 @@ +select name, addr from people inner join student using (id, name) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_4.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_4.sql new file mode 100644 index 0000000..7e572de --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_4.sql @@ -0,0 +1 @@ +select name, addr from people join student using (id, name) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_5.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_5.sql new file mode 100644 index 0000000..79c69e3 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_5.sql @@ -0,0 +1 @@ +select name, addr from people cross join student \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_6.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_6.sql new file mode 100644 index 0000000..10aafa9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_6.sql @@ -0,0 +1 @@ +select name, addr from people left outer join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_7.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_7.sql new file mode 100644 index 0000000..402b82f --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_7.sql @@ -0,0 +1 @@ +select name, addr from people right outer join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_8.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_8.sql new file mode 100644 index 0000000..f413478 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_8.sql @@ -0,0 +1,13 @@ +select * + from table1 + cross join table2 + join table3 on table1.id = table3.id + inner join table4 on table1.id = table4.id + left outer join table5 on table1.id = table5.id + right outer join table6 on table1.id = table6.id + full outer join table7 on table1.id = table7.id + natural join table8 + natural inner join table9 + natural left outer join table10 + natural right outer join table11 + natural full outer join table12 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_9.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_9.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_9.sql new file mode 100644 index 0000000..6f0ae0d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/join_9.sql @@ -0,0 +1,5 @@ +select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment, ps_supplycost + from region join nation on n_regionkey = r_regionkey and r_name = 'EUROPE' + join supplier on s_nationekey = n_nationkey + join partsupp on s_suppkey = ps_ps_suppkey + join part on p_partkey = ps_partkey and p_type like '%BRASS' and p_size = 15 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_1.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_1.sql new file mode 100644 index 0000000..7196f0c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_1.sql @@ -0,0 +1 @@ +select id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_10.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_10.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_10.sql new file mode 100644 index 0000000..a3557a1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_10.sql @@ -0,0 +1,5 @@ +select B.* +from ( + select A.member_id, A.member_name + from table1 AS A +) B http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_11.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_11.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_11.sql new file mode 100644 index 0000000..8984a4d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_11.sql @@ -0,0 +1,6 @@ +select A.member_id, A.member_name +from table1 AS A +where A.member_id >= '10000' +and A.member_id <= '20000' +and A.age >= 30 +and A.age <= 50 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_13.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_13.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_13.sql new file mode 100644 index 0000000..19410ea --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_13.sql @@ -0,0 +1,2 @@ +select A.* +from table1 A \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_14.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_14.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_14.sql new file mode 100644 index 0000000..27c9a5a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_14.sql @@ -0,0 +1,2 @@ +select * +from table1 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_15.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_15.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_15.sql new file mode 100644 index 0000000..7c942b1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_15.sql @@ -0,0 +1 @@ +select id, point::text as point, score::INT4 as score from table1 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_2.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_2.sql new file mode 100644 index 0000000..0727705 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_2.sql @@ -0,0 +1 @@ +select id, name, age, gender from people as p, students as s \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_3.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_3.sql new file mode 100644 index 0000000..2e8f43a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_3.sql @@ -0,0 +1 @@ +select name, addr, sum(score) from students group by name, addr \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_4.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_4.sql new file mode 100644 index 0000000..6c19a45 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_4.sql @@ -0,0 +1 @@ +select name, addr, age from people where age > 30 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_5.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_5.sql new file mode 100644 index 0000000..cf3841c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_5.sql @@ -0,0 +1 @@ +select name as n, func(score, 3+4, 3>4) as total, 3+4 as id from people where age = 30; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_6.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_6.sql new file mode 100644 index 0000000..8addb58 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_6.sql @@ -0,0 +1 @@ +select ipv4_src_ip from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_7.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_7.sql new file mode 100644 index 0000000..d54276b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_7.sql @@ -0,0 +1 @@ +select distinct id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_8.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_8.sql new file mode 100644 index 0000000..13f6842 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_8.sql @@ -0,0 +1 @@ +select all id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_9.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_9.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_9.sql new file mode 100644 index 0000000..8f99ca3 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/select_9.sql @@ -0,0 +1,4 @@ +SELECT A.* +FROM table1 AS A +WHERE A.member_name is not null +and A.post_code is null \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_1.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_1.sql new file mode 100644 index 0000000..88600fc --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_1.sql @@ -0,0 +1 @@ +select c1,c2,c3 from table1 union select c4,c5,c6 from table2 union all select c7, c8 from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_2.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_2.sql new file mode 100644 index 0000000..0eb5670 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_2.sql @@ -0,0 +1 @@ +select a,b,c from table1 union distinct select a,b,c from table2 except all select a,b,c from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_3.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_3.sql new file mode 100644 index 0000000..eebfbcb --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_3.sql @@ -0,0 +1 @@ +select a,b,c from table1 intersect select a,b,c from table2 intersect all select a,b,c from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_4.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_4.sql new file mode 100644 index 0000000..a8f0814 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/set_4.sql @@ -0,0 +1,36 @@ +SELECT * +FROM +( + SELECT + a.reg_date, + a.user_id + FROM + (SELECT buy_date AS bdate + FROM buy_history + WHERE host='a0') as a JOIN (SELECT * FROM category_info WHERE category_id ='A1') as b ON a.id=b.id + UNION ALL + SELECT + a.reg_date, + a.user_id + FROM + (SELECT buy_date AS bdate + FROM buy_history + WHERE host='b0') as a JOIN (SELECT * FROM category_info WHERE category_id ='B1') as b ON a.id=b.id + UNION ALL + SELECT + a.reg_date, + a.user_id + FROM + (SELECT buy_date AS bdate + FROM buy_history + WHERE host='c0') as a JOIN (SELECT * FROM category_info WHERE category_id ='C1') as b ON a.id=b.id + UNION ALL + SELECT + a.reg_date, + a.user_id + FROM + (SELECT buy_date AS bdate + FROM buy_history + WHERE host='d0') as a JOIN (SELECT * FROM category_info WHERE category_id ='D1') as b ON a.id=b.id + +) as T \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery1.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery1.sql new file mode 100644 index 0000000..3181e43 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery1.sql @@ -0,0 +1,19 @@ +SELECT unioninput.* +FROM ( + select + table1.key, + table1.value + FROM + table1 + WHERE + table1.key < 100 + + UNION ALL + + SELECT + table2.* + FROM + table2 + WHERE + table2.key > 100 +) unioninput \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery2.sql b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery2.sql new file mode 100644 index 0000000..206b76f --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/table_subquery2.sql @@ -0,0 +1,21 @@ +SELECT + t1.fk, + t2.name +FROM + ( + SELECT + table1.fk + FROM + table1 + ) t1 + + inner join + + ( + SELECT + table2.name + FROM + table2 + ) t2 + + ON t1.fk = t2.fk; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_1.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_1.sql deleted file mode 100644 index 0f91b68..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_1.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 ADD PARTITION (col1 = 1 , col2 = 2) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_2.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_2.sql deleted file mode 100644 index ee4df75..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_2.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 ADD PARTITION (col1 = 1 , col2 = 2) LOCATION 'hdfs://xxx.com/warehouse/table1/col1=1/col2=2' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_3.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_3.sql deleted file mode 100644 index 79d1426..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_3.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE table1 ADD PARTITION (col1 = '2015' , col2 = '01', col3 = '11' ) -LOCATION 'hdfs://xxx.com/warehouse/table1/col1=2015/col2=01/col3=11' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_4.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_4.sql deleted file mode 100644 index bc22a14..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_4.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 ADD PARTITION (col1 = 'TAJO' ) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_5.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_5.sql deleted file mode 100644 index 127d999..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_5.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 ADD IF NOT EXISTS PARTITION (col1 = 'TAJO' ) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_1.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_1.sql deleted file mode 100644 index 6e2ad7c..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_1.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 DROP PARTITION (col1 = 1 , col2 = 2) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_2.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_2.sql deleted file mode 100644 index 5752710..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_2.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 DROP PARTITION (col1 = '2015' , col2 = '01', col3 = '11' ) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_3.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_3.sql deleted file mode 100644 index 8a1a6a5..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_3.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 DROP PARTITION (col1 = 'TAJO' ) PURGE \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_4.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_4.sql deleted file mode 100644 index 44c7977..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_4.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 DROP IF EXISTS PARTITION (col1 = 'TAJO' ) PURGE \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_1.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_1.sql deleted file mode 100644 index ac7aa4d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_1.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 SET PROPERTY 'timezone' = 'GMT-7' http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_2.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_2.sql deleted file mode 100644 index 77df213..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_2.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 SET PROPERTY 'text.delimiter' = '&' http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_3.sql b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_3.sql deleted file mode 100644 index 6230a34..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_3.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE table1 SET PROPERTY 'compression.type'='RECORD','compression.codec'='org.apache.hadoop.io.compress.SnappyCodec' http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/asterisk_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/asterisk_1.sql b/tajo-core-tests/src/test/resources/queries/default/asterisk_1.sql deleted file mode 100644 index 2bbe245..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/asterisk_1.sql +++ /dev/null @@ -1 +0,0 @@ -select * from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/asterisk_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/asterisk_2.sql b/tajo-core-tests/src/test/resources/queries/default/asterisk_2.sql deleted file mode 100644 index d646044..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/asterisk_2.sql +++ /dev/null @@ -1 +0,0 @@ -select p.*, s.* from people cross join students \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/asterisk_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/asterisk_3.sql b/tajo-core-tests/src/test/resources/queries/default/asterisk_3.sql deleted file mode 100644 index 1566230..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/asterisk_3.sql +++ /dev/null @@ -1 +0,0 @@ -select * from people cross join students \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/asterisk_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/asterisk_4.sql b/tajo-core-tests/src/test/resources/queries/default/asterisk_4.sql deleted file mode 100644 index 22faf44..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/asterisk_4.sql +++ /dev/null @@ -1 +0,0 @@ -select age-10, *, length(name) from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_partitioned_table_as_select.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_partitioned_table_as_select.sql b/tajo-core-tests/src/test/resources/queries/default/create_partitioned_table_as_select.sql deleted file mode 100644 index b2d7dce..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_partitioned_table_as_select.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE sales ( - col1 int, - col2 int) -PARTITION BY COLUMN (col3 int, col4 float, col5 text) AS - -SELECT - col1, - col2, - col3, - col4, - col5 -FROM - sales_src -WHERE - col1 > 16 - - http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_1.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_1.hiveql b/tajo-core-tests/src/test/resources/queries/default/create_table_1.hiveql deleted file mode 100644 index c4dcc74..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_1.hiveql +++ /dev/null @@ -1 +0,0 @@ -create table name (name string, age int) http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_1.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_1.sql deleted file mode 100644 index 8875b0e..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_1.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_10.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_10.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_10.sql deleted file mode 100644 index 43314fa..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_10.sql +++ /dev/null @@ -1 +0,0 @@ -create external table table1 (name text, age int, earn bigint, score float) using csv location '/tmp/data' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_11.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_11.hiveql b/tajo-core-tests/src/test/resources/queries/default/create_table_11.hiveql deleted file mode 100644 index 014bcbe..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_11.hiveql +++ /dev/null @@ -1,3 +0,0 @@ -create external table table1 (name string, age int) -STORED as rcfile -location '/user/hive/table1' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_11.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_11.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_11.sql deleted file mode 100644 index d6ca3ae..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_11.sql +++ /dev/null @@ -1,3 +0,0 @@ -create external table table1 (name text, age int) -using rcfile -location '/user/hive/table1' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_12.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_12.hiveql b/tajo-core-tests/src/test/resources/queries/default/create_table_12.hiveql deleted file mode 100644 index e74d3e3..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_12.hiveql +++ /dev/null @@ -1,4 +0,0 @@ -create external table table1 (name string, age int) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' -STORED as textfile -location '/user/hive/table1' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_12.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_12.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_12.sql deleted file mode 100644 index 99e7b8d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_12.sql +++ /dev/null @@ -1,3 +0,0 @@ -create external table table1 (name text, age int) -USING text WITH ('text.delimiter'='|') -location '/user/hive/table1' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_2.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_2.hiveql b/tajo-core-tests/src/test/resources/queries/default/create_table_2.hiveql deleted file mode 100644 index a5cf55d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_2.hiveql +++ /dev/null @@ -1 +0,0 @@ -create table name (name string, age int) STORED as rcfile \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_2.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_2.sql deleted file mode 100644 index 4580e82..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_2.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) using rcfile \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_3.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_3.sql deleted file mode 100644 index 5ab2af2..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_3.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) using rcfile with ('rcfile.buffer'=4096) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_4.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_4.sql deleted file mode 100644 index fe4d580..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_4.sql +++ /dev/null @@ -1 +0,0 @@ -create table name as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_5.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_5.sql deleted file mode 100644 index b22b841..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_5.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_6.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_6.sql deleted file mode 100644 index 27e06f2..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_6.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) using rcfile as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_7.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_7.sql deleted file mode 100644 index 5c9bf35..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_7.sql +++ /dev/null @@ -1 +0,0 @@ -create table name (name text, age int) using rcfile with ('rcfile.buffer'= 4096) as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_8.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_8.sql deleted file mode 100644 index d6c2ae6..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_8.sql +++ /dev/null @@ -1,48 +0,0 @@ -create table widetable ( - col0 bit, - col1 BIT(10), - col2 bit varying, - col3 bit VARYING(10), - col4 tinyint, - col5 smallInt, - col6 integer, - col7 biginT, - col8 real, - col9 float, - col10 float(53), - col11 double, - col12 doublE precision, - col13 numeric, - col14 numeric(10), - col15 numeric(10,2), - col16 decimal, - col17 decimal(10), - col18 decimal(10,2), - col19 char, - col20 character, - col21 chaR(10), - col22 character(10), - col23 varchar, - col24 character varying, - col25 varchar(255), - col26 character varying (255), - col27 nchar, - col28 nchar(255), - col29 national character, - col30 national character(255), - col31 nvarchar, - col32 nvarchar(255), - col33 natIonal character varying, - col34 national character varying (255), - col35 date, - col36 time, - col37 timetz, - col38 time With time zone, - col39 timesTamptz, - col40 timestamp with time zone, - col41 binary, - col42 binary(10), - col43 varbinary(10), - col44 binary Varying(10), - col45 blOb -) as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_9.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_9.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_9.sql deleted file mode 100644 index 49e1e3c..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_9.sql +++ /dev/null @@ -1 +0,0 @@ -create table widetable (col1 float(10), col2 float) as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_like_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_like_1.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_like_1.sql deleted file mode 100644 index 73f2f46..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_like_1.sql +++ /dev/null @@ -1 +0,0 @@ -create table new_table like orig_name; http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_column.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_column.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_column.sql deleted file mode 100644 index 397e7ac..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_column.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE TABLE sales ( col1 int, col2 int) -PARTITION BY COLUMN (col3 int, col4 float, col5 text); - - http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_1.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_1.sql deleted file mode 100644 index f13225a..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_1.sql +++ /dev/null @@ -1,3 +0,0 @@ -CREATE TABLE sales ( col1 int, col2 int) -PARTITION BY HASH (col1) -PARTITIONS 2; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_2.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_2.sql deleted file mode 100644 index c8fe3c5..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_2.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE sales ( col1 int, col2 int) -PARTITION BY HASH (col1) -( - PARTITION part1, - PARTITION part2, - PARTITION part3 -); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_list.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_list.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_list.sql deleted file mode 100644 index 9461e01..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_list.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE sales ( col1 int, col2 int) -PARTITION BY LIST (col1) - ( - PARTITION col1 VALUES ('Seoul', 'ìì¸'), - PARTITION col2 VALUES ('Busan', 'ë¶ì°') - ); - - http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_range.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_range.sql b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_range.sql deleted file mode 100644 index 65c4fdd..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_range.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE sales ( col1 int, col2 int) -PARTITION BY RANGE (col1) - ( - PARTITION col1 VALUES LESS THAN (2), - PARTITION col1 VALUES LESS THAN (5), - PARTITION col1 VALUES LESS THAN (MAXVALUE) - ); - - http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/drop_table.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/drop_table.sql b/tajo-core-tests/src/test/resources/queries/default/drop_table.sql deleted file mode 100644 index 0e52112..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/drop_table.sql +++ /dev/null @@ -1 +0,0 @@ -drop table abc \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/exists_predicate_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/exists_predicate_1.sql b/tajo-core-tests/src/test/resources/queries/default/exists_predicate_1.sql deleted file mode 100644 index 0b10799..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/exists_predicate_1.sql +++ /dev/null @@ -1 +0,0 @@ -select c1,c2,c3 from table1 where exists (select c4 from table2 where c4 = table1.c1); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/exists_predicate_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/exists_predicate_2.sql b/tajo-core-tests/src/test/resources/queries/default/exists_predicate_2.sql deleted file mode 100644 index f4f82f9..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/exists_predicate_2.sql +++ /dev/null @@ -1 +0,0 @@ -select c1,c2,c3 from table1 where not exists (select c4 from table2 where c4 = table1.c1); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/groupby_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/groupby_1.sql b/tajo-core-tests/src/test/resources/queries/default/groupby_1.sql deleted file mode 100644 index 85dbe21..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/groupby_1.sql +++ /dev/null @@ -1 +0,0 @@ -select col0, col1, col2, col3, sum(col4) as total, avg(col5) from base group by col0, cube (col1, col2), rollup(col3) having total > 100 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/groupby_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/groupby_2.sql b/tajo-core-tests/src/test/resources/queries/default/groupby_2.sql deleted file mode 100644 index 031cab2..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/groupby_2.sql +++ /dev/null @@ -1 +0,0 @@ -select col0, col1, col2, col3, sum(col4) as total, avg(col5) from base group by col0, cube (col1, col2), col3 having total > 100 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/groupby_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/groupby_3.sql b/tajo-core-tests/src/test/resources/queries/default/groupby_3.sql deleted file mode 100644 index 469e8b2..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/groupby_3.sql +++ /dev/null @@ -1 +0,0 @@ -select col0, col1, col2, col3, sum(col4) as total, avg(col5) from base group by col0, col3, cube (col1, col2) having total > 100 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/groupby_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/groupby_4.sql b/tajo-core-tests/src/test/resources/queries/default/groupby_4.sql deleted file mode 100644 index 749c6d9..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/groupby_4.sql +++ /dev/null @@ -1 +0,0 @@ -select trim(name), count(1) from table1 group by trim(name) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/groupby_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/groupby_5.sql b/tajo-core-tests/src/test/resources/queries/default/groupby_5.sql deleted file mode 100644 index f654ef6..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/groupby_5.sql +++ /dev/null @@ -1 +0,0 @@ -select id, name, count(*), sum(id), avg(age) from people group by id, name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/in_subquery_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/in_subquery_1.sql b/tajo-core-tests/src/test/resources/queries/default/in_subquery_1.sql deleted file mode 100644 index 2a16a8d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/in_subquery_1.sql +++ /dev/null @@ -1 +0,0 @@ -select c1,c2,c3 from table1 where c1 in (select c4 from table2); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/in_subquery_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/in_subquery_2.sql b/tajo-core-tests/src/test/resources/queries/default/in_subquery_2.sql deleted file mode 100644 index 64c8034..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/in_subquery_2.sql +++ /dev/null @@ -1 +0,0 @@ -select c1,c2,c3 from table1 where c1 not in (select c4 from table2); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_into_select_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_1.sql b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_1.sql deleted file mode 100644 index d3291f5..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_1.sql +++ /dev/null @@ -1 +0,0 @@ -insert into table1 select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_into_select_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_2.sql b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_2.sql deleted file mode 100644 index 2928b11..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_2.sql +++ /dev/null @@ -1 +0,0 @@ -insert into location 'file:/tmp/data' select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_into_select_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_3.sql b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_3.sql deleted file mode 100644 index b7718dc..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_into_select_3.sql +++ /dev/null @@ -1 +0,0 @@ -insert into table1 (col1, col2, col3) select col1, col2, sum(col3) as total from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_1.sql b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_1.sql deleted file mode 100644 index 84992bc..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_1.sql +++ /dev/null @@ -1 +0,0 @@ -insert overwrite into table1 select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql deleted file mode 100644 index b99863e..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql +++ /dev/null @@ -1 +0,0 @@ -INSERT OVERWRITE DIRECTORY 'file:/tmp/data' select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.sql b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.sql deleted file mode 100644 index 1c4227b..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.sql +++ /dev/null @@ -1 +0,0 @@ -insert overwrite into location 'file:/tmp/data' select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_3.sql b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_3.sql deleted file mode 100644 index bfacc01..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_3.sql +++ /dev/null @@ -1 +0,0 @@ -insert overwrite into table1 (col1, col2, col3) select col1, col2, sum(col3) as total from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_1.sql b/tajo-core-tests/src/test/resources/queries/default/join_1.sql deleted file mode 100644 index ad27795..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_1.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people natural join student natural join professor \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_10.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_10.sql b/tajo-core-tests/src/test/resources/queries/default/join_10.sql deleted file mode 100644 index c9056cc..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_10.sql +++ /dev/null @@ -1 +0,0 @@ -select * from a cross join b, c, d, e \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_11.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_11.sql b/tajo-core-tests/src/test/resources/queries/default/join_11.sql deleted file mode 100644 index 25daeb0..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_11.sql +++ /dev/null @@ -1 +0,0 @@ -select * from x, y, (select * from a, b, c WHERE something) as ss where somethingelse \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_12.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_12.sql b/tajo-core-tests/src/test/resources/queries/default/join_12.sql deleted file mode 100644 index 02a0b8e..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_12.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people join student join professor \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_13.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_13.sql b/tajo-core-tests/src/test/resources/queries/default/join_13.sql deleted file mode 100644 index 9c56bc0..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_13.sql +++ /dev/null @@ -1,13 +0,0 @@ -select * -from table1 -cross join table2 -join table3 on table1.id = table3.id -inner join table4 on table1.id = table4.id -left outer join table5 on table1.id = table5.id -right outer join table6 on table1.id = table6.id -full outer join table7 on table1.id = table7.id -join table8 -inner join table9 -left outer join table10 -right outer join table11 -full outer join table12 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_14.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_14.sql b/tajo-core-tests/src/test/resources/queries/default/join_14.sql deleted file mode 100644 index 21c7099..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_14.sql +++ /dev/null @@ -1 +0,0 @@ -select * from a cross join b cross join c cross join d cross join e \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_15.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_15.hiveql b/tajo-core-tests/src/test/resources/queries/default/join_15.hiveql deleted file mode 100644 index 28e9a02..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_15.hiveql +++ /dev/null @@ -1 +0,0 @@ -select * from x join y join (select * from a join b on a.age = b.age join c on a.sex = c.sex) ss \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_15.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_15.sql b/tajo-core-tests/src/test/resources/queries/default/join_15.sql deleted file mode 100644 index 8e41142..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_15.sql +++ /dev/null @@ -1 +0,0 @@ -select * from x join y join (select * from a join b on a.age = b.age join c on a.sex = c.sex) as ss \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_2.sql b/tajo-core-tests/src/test/resources/queries/default/join_2.sql deleted file mode 100644 index 03056ac..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_2.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people inner join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_3.sql b/tajo-core-tests/src/test/resources/queries/default/join_3.sql deleted file mode 100644 index 22281fe..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_3.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people inner join student using (id, name) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_4.sql b/tajo-core-tests/src/test/resources/queries/default/join_4.sql deleted file mode 100644 index 7e572de..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_4.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people join student using (id, name) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_5.sql b/tajo-core-tests/src/test/resources/queries/default/join_5.sql deleted file mode 100644 index 79c69e3..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_5.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people cross join student \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_6.sql b/tajo-core-tests/src/test/resources/queries/default/join_6.sql deleted file mode 100644 index 10aafa9..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_6.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people left outer join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_7.sql b/tajo-core-tests/src/test/resources/queries/default/join_7.sql deleted file mode 100644 index 402b82f..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_7.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr from people right outer join student on people.name = student.name \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_8.sql b/tajo-core-tests/src/test/resources/queries/default/join_8.sql deleted file mode 100644 index f413478..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_8.sql +++ /dev/null @@ -1,13 +0,0 @@ -select * - from table1 - cross join table2 - join table3 on table1.id = table3.id - inner join table4 on table1.id = table4.id - left outer join table5 on table1.id = table5.id - right outer join table6 on table1.id = table6.id - full outer join table7 on table1.id = table7.id - natural join table8 - natural inner join table9 - natural left outer join table10 - natural right outer join table11 - natural full outer join table12 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/join_9.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/join_9.sql b/tajo-core-tests/src/test/resources/queries/default/join_9.sql deleted file mode 100644 index 6f0ae0d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/join_9.sql +++ /dev/null @@ -1,5 +0,0 @@ -select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment, ps_supplycost - from region join nation on n_regionkey = r_regionkey and r_name = 'EUROPE' - join supplier on s_nationekey = n_nationkey - join partsupp on s_suppkey = ps_ps_suppkey - join part on p_partkey = ps_partkey and p_type like '%BRASS' and p_size = 15 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_1.sql b/tajo-core-tests/src/test/resources/queries/default/select_1.sql deleted file mode 100644 index 7196f0c..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_1.sql +++ /dev/null @@ -1 +0,0 @@ -select id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_10.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_10.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_10.hiveql deleted file mode 100644 index f03fdc0..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_10.hiveql +++ /dev/null @@ -1,5 +0,0 @@ -select B.* -from ( - select A.member_id, A.member_name - from table1 A -) B http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_10.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_10.sql b/tajo-core-tests/src/test/resources/queries/default/select_10.sql deleted file mode 100644 index a3557a1..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_10.sql +++ /dev/null @@ -1,5 +0,0 @@ -select B.* -from ( - select A.member_id, A.member_name - from table1 AS A -) B http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_11.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_11.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_11.hiveql deleted file mode 100644 index 3bb82e9..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_11.hiveql +++ /dev/null @@ -1,4 +0,0 @@ -select A.member_id, A.member_name -from table1 A -where A.member_id between '10000' and '20000' -and A.age between 30 and 50 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_11.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_11.sql b/tajo-core-tests/src/test/resources/queries/default/select_11.sql deleted file mode 100644 index 8984a4d..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_11.sql +++ /dev/null @@ -1,6 +0,0 @@ -select A.member_id, A.member_name -from table1 AS A -where A.member_id >= '10000' -and A.member_id <= '20000' -and A.age >= 30 -and A.age <= 50 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_12.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_12.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_12.hiveql deleted file mode 100644 index 3ea5008..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_12.hiveql +++ /dev/null @@ -1,3 +0,0 @@ -SELECT name, salary -FROM employees -limit 10 http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_13.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_13.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_13.hiveql deleted file mode 100644 index e9f7592..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_13.hiveql +++ /dev/null @@ -1,2 +0,0 @@ -select A.* -from table1 A \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_13.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_13.sql b/tajo-core-tests/src/test/resources/queries/default/select_13.sql deleted file mode 100644 index 19410ea..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_13.sql +++ /dev/null @@ -1,2 +0,0 @@ -select A.* -from table1 A \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_14.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_14.sql b/tajo-core-tests/src/test/resources/queries/default/select_14.sql deleted file mode 100644 index 27c9a5a..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_14.sql +++ /dev/null @@ -1,2 +0,0 @@ -select * -from table1 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_15.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_15.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_15.hiveql deleted file mode 100644 index 37c1c83..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_15.hiveql +++ /dev/null @@ -1 +0,0 @@ -select id, cast(point as string) as point, cast(score as int) as score from table1 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_15.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_15.sql b/tajo-core-tests/src/test/resources/queries/default/select_15.sql deleted file mode 100644 index 7c942b1..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_15.sql +++ /dev/null @@ -1 +0,0 @@ -select id, point::text as point, score::INT4 as score from table1 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_2.sql b/tajo-core-tests/src/test/resources/queries/default/select_2.sql deleted file mode 100644 index 0727705..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_2.sql +++ /dev/null @@ -1 +0,0 @@ -select id, name, age, gender from people as p, students as s \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_3.sql b/tajo-core-tests/src/test/resources/queries/default/select_3.sql deleted file mode 100644 index 2e8f43a..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_3.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr, sum(score) from students group by name, addr \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_4.sql b/tajo-core-tests/src/test/resources/queries/default/select_4.sql deleted file mode 100644 index 6c19a45..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_4.sql +++ /dev/null @@ -1 +0,0 @@ -select name, addr, age from people where age > 30 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_5.sql b/tajo-core-tests/src/test/resources/queries/default/select_5.sql deleted file mode 100644 index d9234e0..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_5.sql +++ /dev/null @@ -1 +0,0 @@ -select name as n, func(score, 3+4, 3>4) as total, 3+4 as id from people where age = 30 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_6.sql b/tajo-core-tests/src/test/resources/queries/default/select_6.sql deleted file mode 100644 index 965aa08..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_6.sql +++ /dev/null @@ -1 +0,0 @@ -select ipv4:src_ip from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_7.sql b/tajo-core-tests/src/test/resources/queries/default/select_7.sql deleted file mode 100644 index d54276b..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_7.sql +++ /dev/null @@ -1 +0,0 @@ -select distinct id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_8.sql b/tajo-core-tests/src/test/resources/queries/default/select_8.sql deleted file mode 100644 index 13f6842..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_8.sql +++ /dev/null @@ -1 +0,0 @@ -select all id, name, age, gender from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_9.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_9.hiveql b/tajo-core-tests/src/test/resources/queries/default/select_9.hiveql deleted file mode 100644 index 96e6042..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_9.hiveql +++ /dev/null @@ -1,4 +0,0 @@ -SELECT A.* -FROM table1 A -WHERE A.member_name is not null -and A.post_code is null \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/select_9.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/select_9.sql b/tajo-core-tests/src/test/resources/queries/default/select_9.sql deleted file mode 100644 index 8f99ca3..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/select_9.sql +++ /dev/null @@ -1,4 +0,0 @@ -SELECT A.* -FROM table1 AS A -WHERE A.member_name is not null -and A.post_code is null \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/set_1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/set_1.sql b/tajo-core-tests/src/test/resources/queries/default/set_1.sql deleted file mode 100644 index 88600fc..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/set_1.sql +++ /dev/null @@ -1 +0,0 @@ -select c1,c2,c3 from table1 union select c4,c5,c6 from table2 union all select c7, c8 from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/set_2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/set_2.sql b/tajo-core-tests/src/test/resources/queries/default/set_2.sql deleted file mode 100644 index 0eb5670..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/set_2.sql +++ /dev/null @@ -1 +0,0 @@ -select a,b,c from table1 union distinct select a,b,c from table2 except all select a,b,c from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/set_3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/set_3.sql b/tajo-core-tests/src/test/resources/queries/default/set_3.sql deleted file mode 100644 index eebfbcb..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/set_3.sql +++ /dev/null @@ -1 +0,0 @@ -select a,b,c from table1 intersect select a,b,c from table2 intersect all select a,b,c from table3 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/set_4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/set_4.sql b/tajo-core-tests/src/test/resources/queries/default/set_4.sql deleted file mode 100644 index a8f0814..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/set_4.sql +++ /dev/null @@ -1,36 +0,0 @@ -SELECT * -FROM -( - SELECT - a.reg_date, - a.user_id - FROM - (SELECT buy_date AS bdate - FROM buy_history - WHERE host='a0') as a JOIN (SELECT * FROM category_info WHERE category_id ='A1') as b ON a.id=b.id - UNION ALL - SELECT - a.reg_date, - a.user_id - FROM - (SELECT buy_date AS bdate - FROM buy_history - WHERE host='b0') as a JOIN (SELECT * FROM category_info WHERE category_id ='B1') as b ON a.id=b.id - UNION ALL - SELECT - a.reg_date, - a.user_id - FROM - (SELECT buy_date AS bdate - FROM buy_history - WHERE host='c0') as a JOIN (SELECT * FROM category_info WHERE category_id ='C1') as b ON a.id=b.id - UNION ALL - SELECT - a.reg_date, - a.user_id - FROM - (SELECT buy_date AS bdate - FROM buy_history - WHERE host='d0') as a JOIN (SELECT * FROM category_info WHERE category_id ='D1') as b ON a.id=b.id - -) as T \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql b/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql deleted file mode 100644 index 3181e43..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql +++ /dev/null @@ -1,19 +0,0 @@ -SELECT unioninput.* -FROM ( - select - table1.key, - table1.value - FROM - table1 - WHERE - table1.key < 100 - - UNION ALL - - SELECT - table2.* - FROM - table2 - WHERE - table2.key > 100 -) unioninput \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql b/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql deleted file mode 100644 index 206b76f..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql +++ /dev/null @@ -1,21 +0,0 @@ -SELECT - t1.fk, - t2.name -FROM - ( - SELECT - table1.fk - FROM - table1 - ) t1 - - inner join - - ( - SELECT - table2.name - FROM - table2 - ) t2 - - ON t1.fk = t2.fk; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql b/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql deleted file mode 100644 index d5cda15..0000000 --- a/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql +++ /dev/null @@ -1,14 +0,0 @@ -SELECT unioninput.* -FROM ( - select table1.key, table1.value - FROM table1 - WHERE table1.key < 100 - UNION ALL - SELECT table2.* - FROM table2 - WHERE table2.key > 100 - UNION ALL - select table3.key, table3.value - FROM table3 - WHERE table3.key < 100 -) unioninput \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/6c9ddeaa/tajo-core-tests/src/test/resources/results/TestSQLAnalyzer/alter_table_add_partition_1.result ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/results/TestSQLAnalyzer/alter_table_add_partition_1.result b/tajo-core-tests/src/test/resources/results/TestSQLAnalyzer/alter_table_add_partition_1.result new file mode 100644 index 0000000..00ac1cf --- /dev/null +++ b/tajo-core-tests/src/test/resources/results/TestSQLAnalyzer/alter_table_add_partition_1.result @@ -0,0 +1,30 @@ +{ + "OldTableName": "table1", + "AlterTableType": "ADD_PARTITION", + "Columns": [ + { + "ColumnName": "col1", + "OpType": "Column" + }, + { + "ColumnName": "col2", + "OpType": "Column" + } + ], + "Values": [ + { + "Value": "1", + "ValueType": "Unsigned_Integer", + "OpType": "Literal" + }, + { + "Value": "2", + "ValueType": "Unsigned_Integer", + "OpType": "Literal" + } + ], + "IsPurge": false, + "IfNotExists": false, + "IfExists": false, + "OpType": "AlterTable" +} \ No newline at end of file
