You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by hy...@apache.org on 2014/01/07 03:23:19 UTC
[2/5] TAJO-476: Add a test development kit for unit tests based on
executions of queries.
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/complex_union_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/complex_union_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/complex_union_2.sql
new file mode 100644
index 0000000..d54ed27
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/complex_union_2.sql
@@ -0,0 +1,35 @@
+SELECT *
+FROM
+(
+ SELECT
+ l_orderkey,
+ l_partkey,
+ url
+ FROM
+ (
+ SELECT
+ l_orderkey,
+ l_partkey,
+ CASE
+ WHEN
+ l_partkey IS NOT NULL THEN ''
+ WHEN l_orderkey = 1 THEN '1'
+ ELSE
+ '2'
+ END AS url
+ FROM
+ lineitem
+ ) res1
+ JOIN
+ (
+ SELECT
+ *
+ FROM
+ part
+ ) res2
+ ON l_partkey = p_partkey
+) result
+
+
+
+
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_partitioned_table_as_select.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_partitioned_table_as_select.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_partitioned_table_as_select.sql
new file mode 100644
index 0000000..09b14eb
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_partitioned_table_as_select.sql
@@ -0,0 +1,6 @@
+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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.hiveql
new file mode 100644
index 0000000..c4dcc74
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_1.sql
new file mode 100644
index 0000000..8875b0e
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_10.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_10.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_10.sql
new file mode 100644
index 0000000..43314fa
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.hiveql
new file mode 100644
index 0000000..014bcbe
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_11.sql
new file mode 100644
index 0000000..d6ca3ae
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.hiveql
new file mode 100644
index 0000000..e74d3e3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.sql
new file mode 100644
index 0000000..0816084
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_12.sql
@@ -0,0 +1,3 @@
+create external table table1 (name text, age int)
+USING csv WITH ('csvfile.delimiter'='|')
+location '/user/hive/table1'
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.hiveql
new file mode 100644
index 0000000..a5cf55d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_2.sql
new file mode 100644
index 0000000..4580e82
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_3.sql
new file mode 100644
index 0000000..5ab2af2
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_4.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_4.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_4.sql
new file mode 100644
index 0000000..fe4d580
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_5.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_5.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_5.sql
new file mode 100644
index 0000000..b22b841
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_6.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_6.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_6.sql
new file mode 100644
index 0000000..27e06f2
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_7.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_7.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_7.sql
new file mode 100644
index 0000000..5c9bf35
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_8.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_8.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_8.sql
new file mode 100644
index 0000000..d6c2ae6
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_9.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_9.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_9.sql
new file mode 100644
index 0000000..49e1e3c
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_column.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_column.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_column.sql
new file mode 100644
index 0000000..397e7ac
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_1.sql
new file mode 100644
index 0000000..f13225a
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_hash_2.sql
new file mode 100644
index 0000000..c8fe3c5
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_list.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_list.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_list.sql
new file mode 100644
index 0000000..9461e01
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_range.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_range.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/create_table_partition_by_range.sql
new file mode 100644
index 0000000..65c4fdd
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/drop_table.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/drop_table.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/drop_table.sql
new file mode 100644
index 0000000..0e52112
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_1.sql
new file mode 100644
index 0000000..0b10799
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/exists_predicate_2.sql
new file mode 100644
index 0000000..f4f82f9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/groupby_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/groupby_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/groupby_1.sql
new file mode 100644
index 0000000..85dbe21
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_1.sql
new file mode 100644
index 0000000..2a16a8d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/in_subquery_2.sql
new file mode 100644
index 0000000..64c8034
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_1.sql
new file mode 100644
index 0000000..d3291f5
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_2.sql
new file mode 100644
index 0000000..2928b11
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_into_select_3.sql
new file mode 100644
index 0000000..b7718dc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_1.sql
new file mode 100644
index 0000000..84992bc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.hiveql
new file mode 100644
index 0000000..b99863e
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_2.sql
new file mode 100644
index 0000000..1c4227b
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/insert_overwrite_into_select_3.sql
new file mode 100644
index 0000000..bfacc01
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_1.sql
new file mode 100644
index 0000000..ad27795
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_10.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_10.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_10.sql
new file mode 100644
index 0000000..c9056cc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_11.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_11.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_11.sql
new file mode 100644
index 0000000..25daeb0
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_12.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_12.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_12.sql
new file mode 100644
index 0000000..02a0b8e
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_13.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_13.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_13.sql
new file mode 100644
index 0000000..9c56bc0
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_14.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_14.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_14.sql
new file mode 100644
index 0000000..21c7099
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.hiveql
new file mode 100644
index 0000000..28e9a02
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_15.sql
new file mode 100644
index 0000000..8e41142
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_2.sql
new file mode 100644
index 0000000..03056ac
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_3.sql
new file mode 100644
index 0000000..22281fe
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_4.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_4.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_4.sql
new file mode 100644
index 0000000..7e572de
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_5.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_5.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_5.sql
new file mode 100644
index 0000000..79c69e3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_6.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_6.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_6.sql
new file mode 100644
index 0000000..10aafa9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_7.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_7.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_7.sql
new file mode 100644
index 0000000..402b82f
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_8.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_8.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_8.sql
new file mode 100644
index 0000000..f413478
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_9.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_9.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/join_9.sql
new file mode 100644
index 0000000..6f0ae0d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_1.sql
new file mode 100644
index 0000000..7196f0c
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.hiveql
new file mode 100644
index 0000000..f03fdc0
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_10.sql
new file mode 100644
index 0000000..a3557a1
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.hiveql
new file mode 100644
index 0000000..3bb82e9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_11.sql
new file mode 100644
index 0000000..8984a4d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_12.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_12.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_12.hiveql
new file mode 100644
index 0000000..3ea5008
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.hiveql
new file mode 100644
index 0000000..e9f7592
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_13.sql
new file mode 100644
index 0000000..19410ea
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_14.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_14.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_14.sql
new file mode 100644
index 0000000..27c9a5a
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_2.sql
new file mode 100644
index 0000000..0727705
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_3.sql
new file mode 100644
index 0000000..2e8f43a
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_4.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_4.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_4.sql
new file mode 100644
index 0000000..6c19a45
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_5.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_5.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_5.sql
new file mode 100644
index 0000000..d9234e0
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_6.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_6.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_6.sql
new file mode 100644
index 0000000..965aa08
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_7.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_7.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_7.sql
new file mode 100644
index 0000000..d54276b
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_8.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_8.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_8.sql
new file mode 100644
index 0000000..13f6842
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.hiveql
new file mode 100644
index 0000000..96e6042
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/select_9.sql
new file mode 100644
index 0000000..8f99ca3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_1.sql
new file mode 100644
index 0000000..88600fc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_2.sql
new file mode 100644
index 0000000..0eb5670
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_3.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_3.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_3.sql
new file mode 100644
index 0000000..eebfbcb
--- /dev/null
+++ b/tajo-core/tajo-core-backend/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
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_4.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_4.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/set_4.sql
new file mode 100644
index 0000000..a8f0814
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery1.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery1.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery1.sql
new file mode 100644
index 0000000..3181e43
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery2.sql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery2.sql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/table_subquery2.sql
new file mode 100644
index 0000000..206b76f
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/queries/default/union_1.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/queries/default/union_1.hiveql b/tajo-core/tajo-core-backend/src/test/resources/queries/default/union_1.hiveql
new file mode 100644
index 0000000..d5cda15
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/queries/default/union_1.hiveql
@@ -0,0 +1,14 @@
+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/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
new file mode 100644
index 0000000..33b954e
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
@@ -0,0 +1,5 @@
+l_orderkey,revenue
+-------------------------------
+1,0.065
+3,0.08
+2,0.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result
new file mode 100644
index 0000000..aef1b53
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result
@@ -0,0 +1,3 @@
+total_avg
+-------------------------------
+1.8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result
new file mode 100644
index 0000000..9c12da0
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result
@@ -0,0 +1,3 @@
+total_avg
+-------------------------------
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testCount.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testCount.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testCount.result
new file mode 100644
index 0000000..381cded
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testCount.result
@@ -0,0 +1,3 @@
+rownum
+-------------------------------
+5
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result
new file mode 100644
index 0000000..6a87409
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result
@@ -0,0 +1,3 @@
+total_max
+-------------------------------
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMinLong.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMinLong.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMinLong.result
new file mode 100644
index 0000000..216e683
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testMinLong.result
@@ -0,0 +1,3 @@
+total_min
+-------------------------------
+1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testRandom.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testRandom.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testRandom.result
new file mode 100644
index 0000000..9f2a456
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testRandom.result
@@ -0,0 +1 @@
+select l_orderkey, random(3) as rndnum from lineitem group by l_orderkey, rndnum;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result
new file mode 100644
index 0000000..d22cd68
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result
@@ -0,0 +1,7 @@
+?split_part
+-------------------------------
+DELIVER
+TAKE
+TAKE
+NONE
+TAKE
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result
new file mode 100644
index 0000000..ac8119d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result
@@ -0,0 +1,7 @@
+?split_part
+-------------------------------
+DELIVER IN PERSON
+TA
+TA
+NONE
+TA
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
new file mode 100644
index 0000000..5dd4193
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
@@ -0,0 +1,7 @@
+?split_part
+-------------------------------
+
+KE
+KE
+
+KE
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO415Case.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
new file mode 100644
index 0000000..4b02873
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
@@ -0,0 +1,7 @@
+c_custkey,o_orderkey,cnt
+-------------------------------
+1,1,1
+3,3,1
+2,2,1
+4,0,1
+5,0,1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO418Case.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
new file mode 100644
index 0000000..ba35aa1
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
@@ -0,0 +1,3 @@
+l_returnflag,l_linestatus
+-------------------------------
+R,F
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter.result
new file mode 100644
index 0000000..628924b
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter.result
@@ -0,0 +1,3 @@
+revenue
+-------------------------------
+12908.3436
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
new file mode 100644
index 0000000..6ee9cb5
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
@@ -0,0 +1,3 @@
+merged
+-------------------------------
+8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
new file mode 100644
index 0000000..59e09fe
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
@@ -0,0 +1,3 @@
+total
+-------------------------------
+10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct.result
new file mode 100644
index 0000000..f2ad32a
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct.result
@@ -0,0 +1,5 @@
+l_orderkey,maximum,unique_key
+-------------------------------
+1,1,2
+2,2,1
+3,3,2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct2.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct2.result
new file mode 100644
index 0000000..9164120
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testCountDistinct2.result
@@ -0,0 +1,5 @@
+l_orderkey,cnt,unique_key
+-------------------------------
+1,2,2
+2,1,1
+3,2,2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy.result
new file mode 100644
index 0000000..385d0de
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy.result
@@ -0,0 +1,3 @@
+unique_key
+-------------------------------
+5
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy2.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
new file mode 100644
index 0000000..23efdb7
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
@@ -0,0 +1,4 @@
+unique_key
+-------------------------------
+3
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy3.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
new file mode 100644
index 0000000..c956d65
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
@@ -0,0 +1,5 @@
+gkey
+-------------------------------
+1
+2
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy4.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
new file mode 100644
index 0000000..714e73d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
@@ -0,0 +1,5 @@
+gkey,unique_key
+-------------------------------
+1,2
+3,2
+2,1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
new file mode 100644
index 0000000..b8369d2
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
@@ -0,0 +1,4 @@
+l_orderkey,total,num
+-------------------------------
+3,2.5,3
+2,2.0,1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
new file mode 100644
index 0000000..8e6eabd
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
@@ -0,0 +1,5 @@
+l_orderkey,total,num
+-------------------------------
+1,1.0,3
+3,2.5,3
+2,2.0,1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoin.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoin.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoin.result
new file mode 100644
index 0000000..7a1a4c2
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoin.result
@@ -0,0 +1,127 @@
+n_name,r_name,n_regionkey,r_regionkey
+-------------------------------
+ALGERIA,AFRICA,0,0
+ARGENTINA,AFRICA,1,0
+BRAZIL,AFRICA,1,0
+CANADA,AFRICA,1,0
+EGYPT,AFRICA,4,0
+ETHIOPIA,AFRICA,0,0
+FRANCE,AFRICA,3,0
+GERMANY,AFRICA,3,0
+INDIA,AFRICA,2,0
+INDONESIA,AFRICA,2,0
+IRAN,AFRICA,4,0
+IRAQ,AFRICA,4,0
+JAPAN,AFRICA,2,0
+JORDAN,AFRICA,4,0
+KENYA,AFRICA,0,0
+MOROCCO,AFRICA,0,0
+MOZAMBIQUE,AFRICA,0,0
+PERU,AFRICA,1,0
+CHINA,AFRICA,2,0
+ROMANIA,AFRICA,3,0
+SAUDI ARABIA,AFRICA,4,0
+VIETNAM,AFRICA,2,0
+RUSSIA,AFRICA,3,0
+UNITED KINGDOM,AFRICA,3,0
+UNITED STATES,AFRICA,1,0
+ALGERIA,AMERICA,0,1
+ARGENTINA,AMERICA,1,1
+BRAZIL,AMERICA,1,1
+CANADA,AMERICA,1,1
+EGYPT,AMERICA,4,1
+ETHIOPIA,AMERICA,0,1
+FRANCE,AMERICA,3,1
+GERMANY,AMERICA,3,1
+INDIA,AMERICA,2,1
+INDONESIA,AMERICA,2,1
+IRAN,AMERICA,4,1
+IRAQ,AMERICA,4,1
+JAPAN,AMERICA,2,1
+JORDAN,AMERICA,4,1
+KENYA,AMERICA,0,1
+MOROCCO,AMERICA,0,1
+MOZAMBIQUE,AMERICA,0,1
+PERU,AMERICA,1,1
+CHINA,AMERICA,2,1
+ROMANIA,AMERICA,3,1
+SAUDI ARABIA,AMERICA,4,1
+VIETNAM,AMERICA,2,1
+RUSSIA,AMERICA,3,1
+UNITED KINGDOM,AMERICA,3,1
+UNITED STATES,AMERICA,1,1
+ALGERIA,ASIA,0,2
+ARGENTINA,ASIA,1,2
+BRAZIL,ASIA,1,2
+CANADA,ASIA,1,2
+EGYPT,ASIA,4,2
+ETHIOPIA,ASIA,0,2
+FRANCE,ASIA,3,2
+GERMANY,ASIA,3,2
+INDIA,ASIA,2,2
+INDONESIA,ASIA,2,2
+IRAN,ASIA,4,2
+IRAQ,ASIA,4,2
+JAPAN,ASIA,2,2
+JORDAN,ASIA,4,2
+KENYA,ASIA,0,2
+MOROCCO,ASIA,0,2
+MOZAMBIQUE,ASIA,0,2
+PERU,ASIA,1,2
+CHINA,ASIA,2,2
+ROMANIA,ASIA,3,2
+SAUDI ARABIA,ASIA,4,2
+VIETNAM,ASIA,2,2
+RUSSIA,ASIA,3,2
+UNITED KINGDOM,ASIA,3,2
+UNITED STATES,ASIA,1,2
+ALGERIA,EUROPE,0,3
+ARGENTINA,EUROPE,1,3
+BRAZIL,EUROPE,1,3
+CANADA,EUROPE,1,3
+EGYPT,EUROPE,4,3
+ETHIOPIA,EUROPE,0,3
+FRANCE,EUROPE,3,3
+GERMANY,EUROPE,3,3
+INDIA,EUROPE,2,3
+INDONESIA,EUROPE,2,3
+IRAN,EUROPE,4,3
+IRAQ,EUROPE,4,3
+JAPAN,EUROPE,2,3
+JORDAN,EUROPE,4,3
+KENYA,EUROPE,0,3
+MOROCCO,EUROPE,0,3
+MOZAMBIQUE,EUROPE,0,3
+PERU,EUROPE,1,3
+CHINA,EUROPE,2,3
+ROMANIA,EUROPE,3,3
+SAUDI ARABIA,EUROPE,4,3
+VIETNAM,EUROPE,2,3
+RUSSIA,EUROPE,3,3
+UNITED KINGDOM,EUROPE,3,3
+UNITED STATES,EUROPE,1,3
+ALGERIA,MIDDLE EAST,0,4
+ARGENTINA,MIDDLE EAST,1,4
+BRAZIL,MIDDLE EAST,1,4
+CANADA,MIDDLE EAST,1,4
+EGYPT,MIDDLE EAST,4,4
+ETHIOPIA,MIDDLE EAST,0,4
+FRANCE,MIDDLE EAST,3,4
+GERMANY,MIDDLE EAST,3,4
+INDIA,MIDDLE EAST,2,4
+INDONESIA,MIDDLE EAST,2,4
+IRAN,MIDDLE EAST,4,4
+IRAQ,MIDDLE EAST,4,4
+JAPAN,MIDDLE EAST,2,4
+JORDAN,MIDDLE EAST,4,4
+KENYA,MIDDLE EAST,0,4
+MOROCCO,MIDDLE EAST,0,4
+MOZAMBIQUE,MIDDLE EAST,0,4
+PERU,MIDDLE EAST,1,4
+CHINA,MIDDLE EAST,2,4
+ROMANIA,MIDDLE EAST,3,4
+SAUDI ARABIA,MIDDLE EAST,4,4
+VIETNAM,MIDDLE EAST,2,4
+RUSSIA,MIDDLE EAST,3,4
+UNITED KINGDOM,MIDDLE EAST,3,4
+UNITED STATES,MIDDLE EAST,1,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoinWithExplicitJoinQual.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoinWithExplicitJoinQual.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoinWithExplicitJoinQual.result
new file mode 100644
index 0000000..5c54325
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testCrossJoinWithExplicitJoinQual.result
@@ -0,0 +1,27 @@
+n_name,r_name,n_regionkey,r_regionkey
+-------------------------------
+ALGERIA,AFRICA,0,0
+ARGENTINA,AMERICA,1,1
+BRAZIL,AMERICA,1,1
+CANADA,AMERICA,1,1
+EGYPT,MIDDLE EAST,4,4
+ETHIOPIA,AFRICA,0,0
+FRANCE,EUROPE,3,3
+GERMANY,EUROPE,3,3
+INDIA,ASIA,2,2
+INDONESIA,ASIA,2,2
+IRAN,MIDDLE EAST,4,4
+IRAQ,MIDDLE EAST,4,4
+JAPAN,ASIA,2,2
+JORDAN,MIDDLE EAST,4,4
+KENYA,AFRICA,0,0
+MOROCCO,AFRICA,0,0
+MOZAMBIQUE,AFRICA,0,0
+PERU,AMERICA,1,1
+CHINA,ASIA,2,2
+ROMANIA,EUROPE,3,3
+SAUDI ARABIA,MIDDLE EAST,4,4
+VIETNAM,ASIA,2,2
+RUSSIA,EUROPE,3,3
+UNITED KINGDOM,EUROPE,3,3
+UNITED STATES,AMERICA,1,1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
new file mode 100644
index 0000000..81dc055
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testFullOuterJoin1.result
@@ -0,0 +1,7 @@
+c_custkey,o_orderkey
+-------------------------------
+1,1
+2,2
+3,3
+4,0
+5,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinAndCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinAndCaseWhen.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinAndCaseWhen.result
new file mode 100644
index 0000000..f5215ea
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinAndCaseWhen.result
@@ -0,0 +1,27 @@
+r_regionkey,n_regionkey,cond
+-------------------------------
+0,0,zero
+1,1,one
+1,1,one
+1,1,one
+4,4,four
+0,0,zero
+3,3,three
+3,3,three
+2,2,two
+2,2,two
+4,4,four
+4,4,four
+2,2,two
+4,4,four
+0,0,zero
+0,0,zero
+0,0,zero
+1,1,one
+2,2,two
+3,3,three
+4,4,four
+2,2,two
+3,3,three
+3,3,three
+1,1,one
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinRefEval.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinRefEval.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinRefEval.result
new file mode 100644
index 0000000..1b960dc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testJoinRefEval.result
@@ -0,0 +1,27 @@
+r_regionkey,n_regionkey,plus
+-------------------------------
+0,0,0
+1,1,2
+1,1,2
+1,1,2
+4,4,8
+0,0,0
+3,3,6
+3,3,6
+2,2,4
+2,2,4
+4,4,8
+4,4,8
+2,2,4
+4,4,8
+0,0,0
+0,0,0
+0,0,0
+1,1,2
+2,2,4
+3,3,6
+4,4,8
+2,2,4
+3,3,6
+3,3,6
+1,1,2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
new file mode 100644
index 0000000..81dc055
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testLeftOuterJoin1.result
@@ -0,0 +1,7 @@
+c_custkey,o_orderkey
+-------------------------------
+1,1
+2,2
+3,3
+4,0
+5,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
new file mode 100644
index 0000000..81dc055
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testRightOuterJoin1.result
@@ -0,0 +1,7 @@
+c_custkey,o_orderkey
+-------------------------------
+1,1
+2,2
+3,3
+4,0
+5,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
new file mode 100644
index 0000000..dcd7787
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testTPCHQ2Join.result
@@ -0,0 +1,5 @@
+s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
+-------------------------------
+4192.4,Supplier#000000003,ARGENTINA,2,Manufacturer#1,q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3,11-383-516-1199,blithely silent requests after the express dependencies are sl
+4032.68,Supplier#000000002,ETHIOPIA,1,Manufacturer#1,89eJ5ksX3ImxJQBvxObC,,15-679-861-2259, slyly bold instructions. idle dependen
+4641.08,Supplier#000000004,MOROCCO,3,Manufacturer#4,Bk7ah4CK8SYQTepEmvMkkgMwg,25-843-787-7479,riously even requests above the exp
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhen.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhen.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhen.result
new file mode 100644
index 0000000..68a5572
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhen.result
@@ -0,0 +1,7 @@
+r_regionkey,cond
+-------------------------------
+0,zero
+1,one
+2,two
+3,three
+4,four
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
new file mode 100644
index 0000000..843b4e8
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testCaseWhenWithoutElse.result
@@ -0,0 +1,7 @@
+r_regionkey,cond
+-------------------------------
+0,0
+1,11
+2,12
+3,13
+4,14
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInClause.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInClause.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInClause.result
new file mode 100644
index 0000000..0fcabae
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInClause.result
@@ -0,0 +1,5 @@
+l_orderkey
+-------------------------------
+2
+3
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInStrClause.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInStrClause.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInStrClause.result
new file mode 100644
index 0000000..4cefae9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testInStrClause.result
@@ -0,0 +1,4 @@
+l_orderkey
+-------------------------------
+3
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLikeClause.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLikeClause.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLikeClause.result
new file mode 100644
index 0000000..4ba420d
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLikeClause.result
@@ -0,0 +1,9 @@
+n_name
+-------------------------------
+ALGERIA
+ETHIOPIA
+INDIA
+INDONESIA
+ROMANIA
+SAUDI ARABIA
+RUSSIA
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLimit.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLimit.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLimit.result
new file mode 100644
index 0000000..c6ada38
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testLimit.result
@@ -0,0 +1,5 @@
+l_orderkey,l_suppkey
+-------------------------------
+1,7706
+1,7311
+2,1191
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotEqual.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotEqual.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotEqual.result
new file mode 100644
index 0000000..0fcabae
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotEqual.result
@@ -0,0 +1,5 @@
+l_orderkey
+-------------------------------
+2
+3
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInClause.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInClause.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInClause.result
new file mode 100644
index 0000000..dcadee9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInClause.result
@@ -0,0 +1,4 @@
+l_orderkey
+-------------------------------
+1
+1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInStrClause.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInStrClause.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInStrClause.result
new file mode 100644
index 0000000..4cefae9
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testNotInStrClause.result
@@ -0,0 +1,4 @@
+l_orderkey
+-------------------------------
+3
+3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testRealValueCompare.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testRealValueCompare.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testRealValueCompare.result
new file mode 100644
index 0000000..02d3f4e
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testRealValueCompare.result
@@ -0,0 +1,3 @@
+ps_supplycost
+-------------------------------
+771.64
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect.result
new file mode 100644
index 0000000..1378536
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect.result
@@ -0,0 +1,7 @@
+l_orderkey,l_partkey
+-------------------------------
+1,1
+1,1
+2,2
+3,2
+3,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect2.result b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect2.result
new file mode 100644
index 0000000..934c2c8
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect2.result
@@ -0,0 +1,7 @@
+l_orderkey,l_partkey,plus
+-------------------------------
+1,1,2
+1,1,2
+2,2,4
+3,2,5
+3,3,6
\ No newline at end of file