http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLead1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLead1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLead1.sql new file mode 100644 index 0000000..1c6cc20 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLead1.sql @@ -0,0 +1,18 @@ +SELECT + lead(l_shipmode, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipmode_lead, + lead(l_linenumber, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as linenumber_lead, + lead(l_suppkey_t, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as suppkey_lead, + lead(l_shipdate_t, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipdate_lead, + lead(l_commitdate_t, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as commitdate_lead, + lead(l_extendedprice, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as extendedprice_lead, + lead(l_discount_t, 1) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as discount_lead, + l_orderkey +FROM +( + SELECT + l_orderkey,l_partkey,l_suppkey::INT8 as l_suppkey_t,l_linenumber,l_quantity, + l_extendedprice,l_discount::FLOAT4 as l_discount_t,l_tax,l_returnflag,l_linestatus, + l_shipdate::DATE as l_shipdate_t,l_commitdate::TIMESTAMP as l_commitdate_t,l_receiptdate,l_shipinstruct,l_shipmode,l_comment + FROM + LINEITEM +) xx \ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithDefault.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithDefault.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithDefault.sql new file mode 100644 index 0000000..792d47f --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithDefault.sql @@ -0,0 +1,18 @@ +SELECT + lead(l_shipmode, 1, 'default') over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipmode_lead, + lead(l_linenumber, 1, 100) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as linenumber_lead, + lead(l_suppkey_t, 1, 1000::int8) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as suppkey_lead, + lead(l_shipdate_t, 1, '15-01-01'::date) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipdate_lead, + lead(l_commitdate_t, 1, '15-01-01 12:00:00'::timestamp) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as commitdate_lead, + lead(l_extendedprice, 1, 1.234::float8) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as extendedprice_lead, + lead(l_discount_t, 1, 0.11::float4) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as discount_lead, + l_orderkey +FROM +( + SELECT + l_orderkey,l_partkey,l_suppkey::INT8 as l_suppkey_t,l_linenumber,l_quantity, + l_extendedprice,l_discount::FLOAT4 as l_discount_t,l_tax,l_returnflag,l_linestatus, + l_shipdate::DATE as l_shipdate_t,l_commitdate::TIMESTAMP as l_commitdate_t,l_receiptdate,l_shipinstruct,l_shipmode,l_comment + FROM + LINEITEM +) xx \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithNoArgs.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithNoArgs.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithNoArgs.sql new file mode 100644 index 0000000..7f5f940 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testLeadWithNoArgs.sql @@ -0,0 +1,18 @@ +SELECT + lead(l_shipmode) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipmode_lead, + lead(l_linenumber) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as linenumber_lead, + lead(l_suppkey_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as suppkey_lead, + lead(l_shipdate_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as shipdate_lead, + lead(l_commitdate_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as commitdate_lead, + lead(l_extendedprice) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as extendedprice_lead, + lead(l_discount_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as discount_lead, + l_orderkey +FROM +( + SELECT + l_orderkey,l_partkey,l_suppkey::INT8 as l_suppkey_t,l_linenumber,l_quantity, + l_extendedprice,l_discount::FLOAT4 as l_discount_t,l_tax,l_returnflag,l_linestatus, + l_shipdate::DATE as l_shipdate_t,l_commitdate::TIMESTAMP as l_commitdate_t,l_receiptdate,l_shipinstruct,l_shipmode,l_comment + FROM + LINEITEM +) xx \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber1.sql new file mode 100644 index 0000000..14a5128 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber1.sql @@ -0,0 +1,5 @@ +SELECT + l_orderkey, + row_number() OVER () as row_num +FROM + LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber2.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber2.sql new file mode 100644 index 0000000..2e45120 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber2.sql @@ -0,0 +1,5 @@ +SELECT + l_orderkey, + row_number() OVER (PARTITION BY L_ORDERKEY) as row_num +FROM + LINEITEM \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber3.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber3.sql new file mode 100644 index 0000000..44594c7 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testRowNumber3.sql @@ -0,0 +1,7 @@ +SELECT + l_orderkey, + row_number() OVER (PARTITION BY L_ORDERKEY) as row_num, + l_discount, + avg(l_discount) OVER (PARTITION BY L_ORDERKEY) as average +FROM + LINEITEM \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevPop1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevPop1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevPop1.sql new file mode 100644 index 0000000..013c8af --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevPop1.sql @@ -0,0 +1,14 @@ +SELECT + STDDEV_POP(l_linenumber) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as linenumber_stddev_pop, + STDDEV_POP(l_suppkey_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as suppkey_stddev_pop, + STDDEV_POP(l_extendedprice) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as extendedprice_stddev_pop, + STDDEV_POP(l_discount_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as discount_stddev_pop +FROM +( + SELECT + l_orderkey,l_partkey,l_suppkey::INT8 as l_suppkey_t,l_linenumber,l_quantity, + l_extendedprice,l_discount::FLOAT4 as l_discount_t,l_tax,l_returnflag,l_linestatus, + l_shipdate::DATE as l_shipdate_t,l_commitdate::TIMESTAMP as l_commitdate_t,l_receiptdate,l_shipinstruct,l_shipmode,l_comment + FROM + LINEITEM +) xx \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevSamp1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevSamp1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevSamp1.sql new file mode 100644 index 0000000..4bb5d5c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testStdDevSamp1.sql @@ -0,0 +1,14 @@ +SELECT + STDDEV_SAMP(l_linenumber) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as linenumber_stddev_samp, + STDDEV_SAMP(l_suppkey_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as suppkey_stddev_samp, + STDDEV_SAMP(l_extendedprice) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as extendedprice_stddev_samp, + STDDEV_SAMP(l_discount_t) over (PARTITION BY L_ORDERKEY order by l_shipmode ) as discount_stddev_samp +FROM +( + SELECT + l_orderkey,l_partkey,l_suppkey::INT8 as l_suppkey_t,l_linenumber,l_quantity, + l_extendedprice,l_discount::FLOAT4 as l_discount_t,l_tax,l_returnflag,l_linestatus, + l_shipdate::DATE as l_shipdate_t,l_commitdate::TIMESTAMP as l_commitdate_t,l_receiptdate,l_shipinstruct,l_shipmode,l_comment + FROM + LINEITEM +) xx \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow1.sql new file mode 100644 index 0000000..8e6d083 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow1.sql @@ -0,0 +1 @@ +SELECT sum(l_quantity) OVER () FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow2.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow2.sql new file mode 100644 index 0000000..baa92f6 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow2.sql @@ -0,0 +1 @@ +SELECT l_orderkey, l_quantity, sum(l_quantity) OVER () FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow3.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow3.sql new file mode 100644 index 0000000..e4b92f0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow3.sql @@ -0,0 +1 @@ +SELECT l_orderkey, l_quantity, sum(l_quantity) OVER (PARTITION BY l_orderkey) FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow4.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow4.sql new file mode 100644 index 0000000..d32c63a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow4.sql @@ -0,0 +1 @@ +SELECT l_orderkey, l_discount, sum(l_discount) OVER (PARTITION BY l_orderkey), sum(l_quantity) OVER (PARTITION BY l_orderkey) FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow5.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow5.sql new file mode 100644 index 0000000..7f31991 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow5.sql @@ -0,0 +1 @@ +SELECT l_orderkey, sum(l_discount) OVER (PARTITION BY l_orderkey), l_discount, sum(l_quantity) OVER (PARTITION BY l_orderkey) FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow6.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow6.sql new file mode 100644 index 0000000..c1e4a84 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow6.sql @@ -0,0 +1 @@ +SELECT l_orderkey, l_discount, row_number() OVER (PARTITION BY l_orderkey) r1 , sum(l_discount) OVER (PARTITION BY l_orderkey) r2 FROM LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow7.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow7.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow7.sql new file mode 100644 index 0000000..2caf0db --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow7.sql @@ -0,0 +1 @@ +select l_orderkey, l_quantity, rank() over (partition by l_orderkey) as r from lineitem \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow8.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow8.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow8.sql new file mode 100644 index 0000000..4611bee --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindow8.sql @@ -0,0 +1,7 @@ +select + l_orderkey, + l_quantity, + rank() over (partition by l_orderkey) as r, + 5 as const_val +from + lineitem; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowBeforeLimit.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowBeforeLimit.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowBeforeLimit.sql new file mode 100644 index 0000000..c4d7fa6 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowBeforeLimit.sql @@ -0,0 +1,6 @@ +select + r_name, + rank() over (order by r_regionkey) as ran +from + region +limit 3; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation1.sql new file mode 100644 index 0000000..7afdae2 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation1.sql @@ -0,0 +1,4 @@ +select + row_number() over (order by count(*) desc) row_num +from + lineitem \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation2.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation2.sql new file mode 100644 index 0000000..1d77ca1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation2.sql @@ -0,0 +1,7 @@ +select + l_orderkey, + row_number() over (partition by l_orderkey order by count(*) desc) row_num +from + lineitem +group by + l_orderkey; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation3.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation3.sql new file mode 100644 index 0000000..f3d3703 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation3.sql @@ -0,0 +1,5 @@ +select + count(*) as cnt, + row_number() over (order by count(*) desc) row_num +from + lineitem \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation4.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation4.sql new file mode 100644 index 0000000..af695ba --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation4.sql @@ -0,0 +1,8 @@ +select + l_orderkey, + count(*) as cnt, + row_number() over (order by count(*) desc) row_num +from + lineitem +group by + l_orderkey \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation5.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation5.sql new file mode 100644 index 0000000..2764ae9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation5.sql @@ -0,0 +1,9 @@ +select + l_orderkey, + count(*) as cnt, + row_number() over (partition by l_orderkey order by count(*) desc) + row_num +from + lineitem +group by + l_orderkey \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation6.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation6.sql new file mode 100644 index 0000000..1a9d46b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation6.sql @@ -0,0 +1,10 @@ +select + l_orderkey, + count(*) as cnt, + row_number() over (order by count(*) desc) row_num +from + lineitem +group by + l_orderkey +order by + l_orderkey; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy1.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy1.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy1.sql new file mode 100644 index 0000000..d047bbd --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy1.sql @@ -0,0 +1,6 @@ +SELECT + l_orderkey, + l_discount, + rank() OVER (ORDER BY l_discount) r1 +FROM + LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy2.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy2.sql new file mode 100644 index 0000000..7e6b339 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy2.sql @@ -0,0 +1,6 @@ +SELECT + l_orderkey, + l_partkey, + rank() OVER (PARTITION BY L_ORDERKEY ORDER BY l_partkey) r1 +FROM + LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy3.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy3.sql new file mode 100644 index 0000000..5fc7317 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy3.sql @@ -0,0 +1,6 @@ +SELECT + l_orderkey, + l_partkey, + rank() OVER (PARTITION BY L_ORDERKEY ORDER BY l_partkey desc) r1 +FROM + LINEITEM \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy4.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy4.sql new file mode 100644 index 0000000..26cfaa7 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy4.sql @@ -0,0 +1,7 @@ +SELECT + l_orderkey, + l_partkey, + rank() OVER (ORDER BY l_orderkey) r1, + rank() OVER(ORDER BY l_partkey desc) r2 +FROM + LINEITEM; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy5.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy5.sql new file mode 100644 index 0000000..2dc87af --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithOrderBy5.sql @@ -0,0 +1,9 @@ +SELECT + l_orderkey, + l_partkey, + rank() OVER (ORDER BY l_orderkey) r1, + rank() OVER(ORDER BY l_partkey desc) r2 +FROM + LINEITEM +where + l_partkey > 0 and l_partkey < 100; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery.sql new file mode 100644 index 0000000..5fa6d00 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery.sql @@ -0,0 +1,14 @@ +select + r_name, + c, + rank() over (order by r_regionkey) as ran +from ( + select + r_name, + r_regionkey, + count(*) as c + from + region + group by + r_name, r_regionkey +) a; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery2.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery2.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery2.sql new file mode 100644 index 0000000..87520fb --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery2.sql @@ -0,0 +1,15 @@ +select + r_name, + c, + rank() over (partition by r_regionkey order by r_regionkey) as ran +from ( + select + r_name, + r_regionkey, + count(*) as c + from + region + group by + r_name, r_regionkey +) a +limit 3; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery3.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery3.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery3.sql new file mode 100644 index 0000000..10d8863 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery3.sql @@ -0,0 +1,14 @@ +select + a.r_name, + a.r_regionkey, + row_number() over (partition by a.r_name order by a.cnt desc) mk +from ( + select + r_name, + r_regionkey, + count(*) cnt + from + default.region + group by + r_name, r_regionkey +) a; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery4.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery4.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery4.sql new file mode 100644 index 0000000..fe32eb1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery4.sql @@ -0,0 +1,14 @@ +select + a.r_name, + a.r_regionkey, + row_number() over (partition by a.r_regionkey order by a.cnt desc) mk +from ( + select + r_name, + r_regionkey, + count(*) cnt + from + default.region + group by + r_name, r_regionkey +) a; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery5.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery5.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery5.sql new file mode 100644 index 0000000..2db397b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery5.sql @@ -0,0 +1,11 @@ +select + * +from ( + select + r_name, + rank() over (order by r_regionkey) as ran + from + region +) a +where + ran >= 3; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery6.sql ---------------------------------------------------------------------- diff --git a/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery6.sql b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery6.sql new file mode 100644 index 0000000..8678fe6 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/TestWindowQuery/testWindowWithSubQuery6.sql @@ -0,0 +1,9 @@ +select + * +from ( + select + r_name, + rank() over (order by r_regionkey) as ran from region +) a +where + r_name LIKE 'ASIA' \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..0f91b68 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..ee4df75 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..79d1426 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_3.sql @@ -0,0 +1,2 @@ +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/a4106883/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 new file mode 100644 index 0000000..bc22a14 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_4.sql @@ -0,0 +1 @@ +ALTER TABLE table1 ADD PARTITION (col1 = 'TAJO' ) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..127d999 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_add_partition_5.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..6e2ad7c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..5752710 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..8a1a6a5 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_3.sql @@ -0,0 +1 @@ +ALTER TABLE table1 DROP PARTITION (col1 = 'TAJO' ) PURGE \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..44c7977 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_drop_partition_4.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..ac7aa4d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_1.sql @@ -0,0 +1 @@ +ALTER TABLE table1 SET PROPERTY 'timezone' = 'GMT-7' http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..77df213 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_2.sql @@ -0,0 +1 @@ +ALTER TABLE table1 SET PROPERTY 'text.delimiter' = '&' http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..6230a34 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/alter_table_set_property_3.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..2bbe245 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/asterisk_1.sql @@ -0,0 +1 @@ +select * from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..d646044 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/asterisk_2.sql @@ -0,0 +1 @@ +select p.*, s.* from people cross join students \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..1566230 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/asterisk_3.sql @@ -0,0 +1 @@ +select * from people cross join students \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..22faf44 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/asterisk_4.sql @@ -0,0 +1 @@ +select age-10, *, length(name) from people \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..b2d7dce --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_partitioned_table_as_select.sql @@ -0,0 +1,17 @@ +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/a4106883/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 new file mode 100644 index 0000000..c4dcc74 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_1.hiveql @@ -0,0 +1 @@ +create table name (name string, age int) http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..8875b0e --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_1.sql @@ -0,0 +1 @@ +create table name (name text, age int) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..43314fa --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_10.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..014bcbe --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_11.hiveql @@ -0,0 +1,3 @@ +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/a4106883/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 new file mode 100644 index 0000000..d6ca3ae --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_11.sql @@ -0,0 +1,3 @@ +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/a4106883/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 new file mode 100644 index 0000000..e74d3e3 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_12.hiveql @@ -0,0 +1,4 @@ +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/a4106883/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 new file mode 100644 index 0000000..99e7b8d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_12.sql @@ -0,0 +1,3 @@ +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/a4106883/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 new file mode 100644 index 0000000..a5cf55d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_2.hiveql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..4580e82 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..5ab2af2 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_3.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..fe4d580 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_4.sql @@ -0,0 +1 @@ +create table name as select * from test \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..b22b841 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_5.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..27e06f2 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_6.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..5c9bf35 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_7.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..d6c2ae6 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_8.sql @@ -0,0 +1,48 @@ +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/a4106883/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 new file mode 100644 index 0000000..49e1e3c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_9.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..73f2f46 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_like_1.sql @@ -0,0 +1 @@ +create table new_table like orig_name; http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..397e7ac --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_column.sql @@ -0,0 +1,4 @@ +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/a4106883/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 new file mode 100644 index 0000000..f13225a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_1.sql @@ -0,0 +1,3 @@ +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/a4106883/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 new file mode 100644 index 0000000..c8fe3c5 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_hash_2.sql @@ -0,0 +1,7 @@ +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/a4106883/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 new file mode 100644 index 0000000..9461e01 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_list.sql @@ -0,0 +1,8 @@ +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/a4106883/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 new file mode 100644 index 0000000..65c4fdd --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/create_table_partition_by_range.sql @@ -0,0 +1,9 @@ +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/a4106883/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 new file mode 100644 index 0000000..0e52112 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/drop_table.sql @@ -0,0 +1 @@ +drop table abc \ No newline at end of file http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..0b10799 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/exists_predicate_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..f4f82f9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/exists_predicate_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..85dbe21 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/groupby_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..031cab2 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/groupby_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..469e8b2 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/groupby_3.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..749c6d9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/groupby_4.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..f654ef6 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/groupby_5.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..2a16a8d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/in_subquery_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..64c8034 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/in_subquery_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..d3291f5 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_1.sql @@ -0,0 +1 @@ +insert into table1 select col1, col2, sum(col3) from table2 group by col1, col2 http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..2928b11 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..b7718dc --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_into_select_3.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..84992bc --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..b99863e --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..1c4227b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_2.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..bfacc01 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/insert_overwrite_into_select_3.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..ad27795 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/join_1.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..c9056cc --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/join_10.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..25daeb0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..02a0b8e --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/join_12.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..9c56bc0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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 +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/a4106883/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 new file mode 100644 index 0000000..21c7099 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..28e9a02 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/join_15.hiveql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..8e41142 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/join_15.sql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..03056ac --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..22281fe --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..7e572de --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..79c69e3 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..10aafa9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..402b82f --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..f413478 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..6f0ae0d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..7196f0c --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..f03fdc0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_10.hiveql @@ -0,0 +1,5 @@ +select B.* +from ( + select A.member_id, A.member_name + from table1 A +) B http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..a3557a1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..3bb82e9 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_11.hiveql @@ -0,0 +1,4 @@ +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/a4106883/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 new file mode 100644 index 0000000..8984a4d --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..3ea5008 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_12.hiveql @@ -0,0 +1,3 @@ +SELECT name, salary +FROM employees +limit 10 http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/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 new file mode 100644 index 0000000..e9f7592 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_13.hiveql @@ -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/a4106883/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 new file mode 100644 index 0000000..19410ea --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..27c9a5a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..37c1c83 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_15.hiveql @@ -0,0 +1 @@ +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/a4106883/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 new file mode 100644 index 0000000..7c942b1 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..0727705 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..2e8f43a --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..6c19a45 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..d9234e0 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..965aa08 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..d54276b --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..13f6842 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..96e6042 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/select_9.hiveql @@ -0,0 +1,4 @@ +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/a4106883/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 new file mode 100644 index 0000000..8f99ca3 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..88600fc --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..0eb5670 --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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/a4106883/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 new file mode 100644 index 0000000..eebfbcb --- /dev/null +++ b/tajo-core-tests/src/test/resources/queries/default/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
