tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hyun...@apache.org
Subject [21/51] [partial] tajo git commit: TAJO-1761: Separate an integration unit test kit into an independent module.
Date Fri, 14 Aug 2015 14:30:00 GMT
http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/default/set_4.sql
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/queries/default/set_4.sql b/tajo-core-tests/src/test/resources/queries/default/set_4.sql
new file mode 100644
index 0000000..a8f0814
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql b/tajo-core-tests/src/test/resources/queries/default/table_subquery1.sql
new file mode 100644
index 0000000..3181e43
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql b/tajo-core-tests/src/test/resources/queries/default/table_subquery2.sql
new file mode 100644
index 0000000..206b76f
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql b/tajo-core-tests/src/test/resources/queries/default/union_1.hiveql
new file mode 100644
index 0000000..d5cda15
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestAlterTable/after_set_property_delimiter.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestAlterTable/after_set_property_delimiter.result b/tajo-core-tests/src/test/resources/results/TestAlterTable/after_set_property_delimiter.result
new file mode 100644
index 0000000..6729298
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestAlterTable/after_set_property_delimiter.result
@@ -0,0 +1,3 @@
+xx,yy,zz
+-------------------------------
+aaa+AAA,bbb+BBB,ccc

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestAlterTable/before_set_property_delimiter.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestAlterTable/before_set_property_delimiter.result b/tajo-core-tests/src/test/resources/results/TestAlterTable/before_set_property_delimiter.result
new file mode 100644
index 0000000..af74e40
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestAlterTable/before_set_property_delimiter.result
@@ -0,0 +1,3 @@
+xx,yy,zz
+-------------------------------
+aaa,AAA|bbb,BBB|ccc

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
new file mode 100644
index 0000000..bd2a69f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgDouble.result
@@ -0,0 +1,5 @@
+l_orderkey,revenue
+-------------------------------
+1,0.065
+2,0.0
+3,0.08
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgInt.result
new file mode 100644
index 0000000..aef1b53
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLong.result
new file mode 100644
index 0000000..9c12da0
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLongOverflow.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLongOverflow.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLongOverflow.result
new file mode 100644
index 0000000..5e1c937
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testAvgLongOverflow.result
@@ -0,0 +1,3 @@
+avg
+-------------------------------
+9.34786981E8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testCount.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testCount.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testCount.result
new file mode 100644
index 0000000..381cded
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxLong.result
new file mode 100644
index 0000000..6a87409
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxString.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxString.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxString.result
new file mode 100644
index 0000000..6a87409
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMaxString.result
@@ -0,0 +1,3 @@
+total_max
+-------------------------------
+3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinLong.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinLong.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinLong.result
new file mode 100644
index 0000000..216e683
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinString.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinString.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinString.result
new file mode 100644
index 0000000..216e683
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testMinString.result
@@ -0,0 +1,3 @@
+total_min
+-------------------------------
+1
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPart.result
new file mode 100644
index 0000000..d22cd68
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartByString.result
new file mode 100644
index 0000000..ac8119d
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
new file mode 100644
index 0000000..ec0f07b
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestBuiltinFunctions/testSplitPartNested.result
@@ -0,0 +1,7 @@
+?split_part
+-------------------------------
+null
+KE
+KE
+null
+KE
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithGroupby.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithGroupby.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithGroupby.result
new file mode 100644
index 0000000..048902f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithGroupby.result
@@ -0,0 +1,7 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
+3.0,2.0,45.0
+3.0,3.0,49.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithLimit.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithLimit.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithLimit.result
new file mode 100644
index 0000000..ea78854
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithLimit.result
@@ -0,0 +1,5 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOptions.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOptions.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOptions.result
new file mode 100644
index 0000000..ea78854
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOptions.result
@@ -0,0 +1,5 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOrderby.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOrderby.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOrderby.result
new file mode 100644
index 0000000..048902f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithOrderby.result
@@ -0,0 +1,7 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
+3.0,2.0,45.0
+3.0,3.0,49.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithStoreType.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithStoreType.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithStoreType.result
new file mode 100644
index 0000000..ea78854
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithStoreType.result
@@ -0,0 +1,5 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithTextFile.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithTextFile.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithTextFile.result
new file mode 100644
index 0000000..ea78854
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithTextFile.result
@@ -0,0 +1,5 @@
+col1,col2,key
+-------------------------------
+1.0,1.0,17.0
+1.0,1.0,36.0
+2.0,2.0,38.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithUnion.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithUnion.result b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithUnion.result
new file mode 100644
index 0000000..a6f9853
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCTASQuery/testCtasWithUnion.result
@@ -0,0 +1,8 @@
+col1,col2,key
+-------------------------------
+1,0,17.0
+1,0,17.0
+1,0,36.0
+1,0,36.0
+2,0,38.0
+2,0,38.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO1224Case1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO1224Case1.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO1224Case1.result
new file mode 100644
index 0000000..19336a7
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO1224Case1.result
@@ -0,0 +1,3 @@
+?count
+-------------------------------
+5
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO415Case.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
new file mode 100644
index 0000000..6c527af
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO415Case.result
@@ -0,0 +1,7 @@
+c_custkey,o_orderkey,cnt
+-------------------------------
+1,1,1
+2,2,1
+3,3,1
+4,null,1
+5,null,1
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO418Case.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
new file mode 100644
index 0000000..d78067e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO418Case.result
@@ -0,0 +1,4 @@
+l_returnflag,l_linestatus
+-------------------------------
+N,O
+R,F
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO619Case.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO619Case.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO619Case.result
new file mode 100644
index 0000000..86249b0
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO619Case.result
@@ -0,0 +1,3 @@
+?count
+-------------------------------
+13

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO718Case.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO718Case.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO718Case.result
new file mode 100644
index 0000000..86c4d57
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO718Case.result
@@ -0,0 +1,5 @@
+l_orderkey,l_orderkey1,t57801e5322bc50
+-------------------------------
+1,1,2
+2,2,1
+3,3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO739Case.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO739Case.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO739Case.result
new file mode 100644
index 0000000..83ae904
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO739Case.result
@@ -0,0 +1,7 @@
+n_nationkey,n_name
+-------------------------------
+1,ARGENTINA
+3,CANADA
+4,EGYPT
+13,JORDAN
+15,MOROCCO
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case1.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case1.result
new file mode 100644
index 0000000..01e467c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case1.result
@@ -0,0 +1,5 @@
+l_orderkey,col1
+-------------------------------
+1,##
+2,##
+3,##
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case2.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case2.result
new file mode 100644
index 0000000..01e467c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case2.result
@@ -0,0 +1,5 @@
+l_orderkey,col1
+-------------------------------
+1,##
+2,##
+3,##
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case3.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case3.result
new file mode 100644
index 0000000..01e467c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case3.result
@@ -0,0 +1,5 @@
+l_orderkey,col1
+-------------------------------
+1,##
+2,##
+3,##
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case4.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case4.result
new file mode 100644
index 0000000..d3b79d1
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO914Case4.result
@@ -0,0 +1,5 @@
+l_orderkey,col1,s1
+-------------------------------
+1,##,2
+2,##,2
+3,##,6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO917Case1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO917Case1.result b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO917Case1.result
new file mode 100644
index 0000000..5dbe646
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCaseByCases/testTAJO917Case1.result
@@ -0,0 +1,7 @@
+r_regionkey
+-------------------------------
+0
+1
+2
+3
+4
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_1.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_1.result
new file mode 100644
index 0000000..e31bc89
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_1.result
@@ -0,0 +1,5 @@
+aGe,teXt,Number
+-------------------------------
+1,abc,2
+2,def,5
+3,ghi,8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_2.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_2.result
new file mode 100644
index 0000000..d0c2732
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_2.result
@@ -0,0 +1,5 @@
+AgE,TEXT,NUMBER
+-------------------------------
+1,abc,2
+2,def,5
+3,ghi,8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_3.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_3.result
new file mode 100644
index 0000000..b04e5c1
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_mixed_chars_3.result
@@ -0,0 +1,8 @@
+aGe,teXt,Number
+-------------------------------
+1,abc,2
+2,def,5
+3,ghi,8
+4,jkl,7
+5,opq,8
+6,stu,9
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_1.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_1.result
new file mode 100644
index 0000000..4656661
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_1.result
@@ -0,0 +1,5 @@
+아이디,텍스트,숫자
+-------------------------------
+1,abc,2
+2,def,5
+3,ghi,8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_2.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_2.result
new file mode 100644
index 0000000..7917cb4
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_2.result
@@ -0,0 +1,5 @@
+진짜아이디,text,숫자
+-------------------------------
+1,abc,2
+2,def,5
+3,ghi,8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_3.result b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_3.result
new file mode 100644
index 0000000..3b51f2c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestCreateTable/quoted_identifier_non_ascii_3.result
@@ -0,0 +1,5 @@
+진짜아이디,길이,?multiply
+-------------------------------
+1,3,4
+2,3,10
+3,3,16
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestFunctionLoader/testFindScalarFunctions.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestFunctionLoader/testFindScalarFunctions.result b/tajo-core-tests/src/test/resources/results/TestFunctionLoader/testFindScalarFunctions.result
new file mode 100644
index 0000000..ac2408d
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestFunctionLoader/testFindScalarFunctions.result
@@ -0,0 +1,2 @@
+float8 pi()
+float8 pow(float8,float8)
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter.result
new file mode 100644
index 0000000..628924b
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
new file mode 100644
index 0000000..6ee9cb5
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
new file mode 100644
index 0000000..59e09fe
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexTargetWithPythonUdaf.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexTargetWithPythonUdaf.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexTargetWithPythonUdaf.result
new file mode 100644
index 0000000..6ee9cb5
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexTargetWithPythonUdaf.result
@@ -0,0 +1,3 @@
+merged
+-------------------------------
+8
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
new file mode 100644
index 0000000..f2ad32a
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
new file mode 100644
index 0000000..9164120
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
new file mode 100644
index 0000000..5600470
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
@@ -0,0 +1,3 @@
+?count,?count_1,?sum_2
+-------------------------------
+5,3,6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
new file mode 100644
index 0000000..72b4e8e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
@@ -0,0 +1,4 @@
+l_linenumber,?count,?count_1,?sum_2
+-------------------------------
+1,3,3,6
+2,2,2,4
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
new file mode 100644
index 0000000..229a279
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
@@ -0,0 +1,4 @@
+?sum,l_linenumber,?count_1,?count_2
+-------------------------------
+6,1,3,3
+4,2,2,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
new file mode 100644
index 0000000..cd59b8f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
@@ -0,0 +1,5 @@
+v0,v1,v2,v4
+-------------------------------
+1,2,3,2
+1,2,1,1
+1,6,3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
new file mode 100644
index 0000000..4173b04
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
@@ -0,0 +1,3 @@
+?count,?count_1,?count_2
+-------------------------------
+5,5,4
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
new file mode 100644
index 0000000..519390d
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
@@ -0,0 +1,7 @@
+?sum,l_linenumber,l_returnflag,l_linestatus,l_shipdate,?count_1,?sum_2
+-------------------------------
+1,1,N,O,1996-03-13,1,1
+2,1,N,O,1997-01-28,1,2
+3,1,R,F,1994-02-02,1,3
+1,2,N,O,1996-04-12,1,1
+3,2,R,F,1993-11-09,1,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase3.result
new file mode 100644
index 0000000..320ab29
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase3.result
@@ -0,0 +1,3 @@
+col1,cnt1,cnt2
+-------------------------------
+a,3,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase4.result
new file mode 100644
index 0000000..a65e71f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationCaseByCase4.result
@@ -0,0 +1,3 @@
+col1,cnt
+-------------------------------
+a,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithHaving1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithHaving1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithHaving1.result
new file mode 100644
index 0000000..5560a23
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithHaving1.result
@@ -0,0 +1,3 @@
+l_linenumber,?count,?count_1,?sum_2
+-------------------------------
+1,3,3,6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
new file mode 100644
index 0000000..16c5524
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
@@ -0,0 +1,4 @@
+?sum,l_linenumber,?count_1,total
+-------------------------------
+6,1,3,6
+4,2,2,4
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
new file mode 100644
index 0000000..9296346
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
@@ -0,0 +1,4 @@
+quantity,suppkey,l_returnflag
+-------------------------------
+91.0,3,N
+94.0,2,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case10.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case10.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case10.result
new file mode 100644
index 0000000..2035d9f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case10.result
@@ -0,0 +1,3 @@
+?sum,?sum_1
+-------------------------------
+3,414440.9
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
new file mode 100644
index 0000000..7af127f
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
@@ -0,0 +1,4 @@
+quantity,partkey,suppkey,l_returnflag
+-------------------------------
+91.0,2,3,N
+94.0,2,2,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
new file mode 100644
index 0000000..31905fa
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
@@ -0,0 +1,4 @@
+quantity,partkey,?count,?max_1,l_returnflag
+-------------------------------
+91.0,2,3,38.0,N
+94.0,2,2,49.0,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
new file mode 100644
index 0000000..8afda65
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
@@ -0,0 +1,5 @@
+l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
+-------------------------------
+1,53.0,1,2,36.0,N
+2,38.0,1,1,38.0,N
+3,94.0,2,2,49.0,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
new file mode 100644
index 0000000..8afda65
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
@@ -0,0 +1,5 @@
+l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
+-------------------------------
+1,53.0,1,2,36.0,N
+2,38.0,1,1,38.0,N
+3,94.0,2,2,49.0,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
new file mode 100644
index 0000000..8afda65
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
@@ -0,0 +1,5 @@
+l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
+-------------------------------
+1,53.0,1,2,36.0,N
+2,38.0,1,1,38.0,N
+3,94.0,2,2,49.0,R
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
new file mode 100644
index 0000000..03cdf1e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
@@ -0,0 +1,5 @@
+?count,quantity,partkey,?count_1,?max_2
+-------------------------------
+1,53.0,1,2,36.0
+1,38.0,1,1,38.0
+1,94.0,2,2,49.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
new file mode 100644
index 0000000..e234896
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
@@ -0,0 +1,6 @@
+l_orderkey,l_partkey,cnt1,cnt2,sum1
+-------------------------------
+1,1,1,2,53.0
+2,2,1,1,38.0
+3,2,1,1,45.0
+3,3,1,1,49.0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
new file mode 100644
index 0000000..506eea0
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
@@ -0,0 +1,6 @@
+l_orderkey,cnt1,value2,l_partkey,avg1,cnt2
+-------------------------------
+1,1,28.0,1,26.5,2
+2,1,39.0,2,38.0,1
+3,1,46.0,2,45.0,1
+3,1,51.0,3,49.0,1
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctPythonUdafWithUnion1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctPythonUdafWithUnion1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctPythonUdafWithUnion1.result
new file mode 100644
index 0000000..16c5524
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctPythonUdafWithUnion1.result
@@ -0,0 +1,4 @@
+?sum,l_linenumber,?count_1,total
+-------------------------------
+6,1,3,6
+4,2,2,4
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
new file mode 100644
index 0000000..385d0de
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
new file mode 100644
index 0000000..6afdd23
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
@@ -0,0 +1,4 @@
+unique_key
+-------------------------------
+2
+3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
new file mode 100644
index 0000000..c956d65
--- /dev/null
+++ b/tajo-core-tests/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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
new file mode 100644
index 0000000..22c6664
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
@@ -0,0 +1,5 @@
+gkey,unique_key
+-------------------------------
+1,2
+2,1
+3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
new file mode 100644
index 0000000..abf0e45
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
@@ -0,0 +1,5 @@
+gkey,const_val
+-------------------------------
+1,00
+2,00
+3,00
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
new file mode 100644
index 0000000..788a084
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
@@ -0,0 +1,6 @@
+unique_key
+-------------------------------
+2
+4
+5
+6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
new file mode 100644
index 0000000..8656add
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
@@ -0,0 +1,6 @@
+total
+-------------------------------
+4
+4
+5
+6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
new file mode 100644
index 0000000..2c04315
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
@@ -0,0 +1,3 @@
+key,total
+-------------------------------
+123,5
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
new file mode 100644
index 0000000..776db3c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
@@ -0,0 +1,5 @@
+a,b,c,d
+-------------------------------
+1,2014-07-07 04:28:31.561,##,2
+2,2014-07-07 04:28:31.561,##,2
+3,2014-07-07 04:28:31.561,##,1
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
new file mode 100644
index 0000000..3285621
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
@@ -0,0 +1,3 @@
+b,c,d
+-------------------------------
+2014-07-07 04:28:31.561,##,5
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
new file mode 100644
index 0000000..69560d5
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
@@ -0,0 +1,5 @@
+?text,l_orderkey,sum
+-------------------------------
+day,1,2
+day,2,1
+day,3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
new file mode 100644
index 0000000..30ba1de
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
@@ -0,0 +1,5 @@
+?text,key,l_orderkey,sum
+-------------------------------
+day,day,1,2
+day,day,2,1
+day,day,3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
new file mode 100644
index 0000000..d1f1282
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
@@ -0,0 +1,5 @@
+key,total
+-------------------------------
+1,2
+2,1
+3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
new file mode 100644
index 0000000..d1f1282
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
@@ -0,0 +1,5 @@
+key,total
+-------------------------------
+1,2
+2,1
+3,2
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData1.result
new file mode 100644
index 0000000..13335cb
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData1.result
@@ -0,0 +1,3 @@
+unique_key
+-------------------------------
+0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData10.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData10.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData10.result
new file mode 100644
index 0000000..c865378
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData10.result
@@ -0,0 +1,3 @@
+unique_key,flag
+-------------------------------
+0,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData11.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData11.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData11.result
new file mode 100644
index 0000000..bd69ff2
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData11.result
@@ -0,0 +1,2 @@
+l_orderkey,unique_key,flag
+-------------------------------
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData12.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData12.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData12.result
new file mode 100644
index 0000000..2b8b687
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData12.result
@@ -0,0 +1,2 @@
+s_acctbal,s_name,t_name,p_partkey,p_mfgr,s_address,s_phone,s_comment
+-------------------------------
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData2.result
new file mode 100644
index 0000000..8746e36
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData2.result
@@ -0,0 +1,3 @@
+unique_key,max_key
+-------------------------------
+0,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData3.result
new file mode 100644
index 0000000..c2cc22e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData3.result
@@ -0,0 +1,3 @@
+maximum,unique_key
+-------------------------------
+null,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData4.result
new file mode 100644
index 0000000..c2cc22e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData4.result
@@ -0,0 +1,3 @@
+maximum,unique_key
+-------------------------------
+null,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData5.result
new file mode 100644
index 0000000..13335cb
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData5.result
@@ -0,0 +1,3 @@
+unique_key
+-------------------------------
+0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData6.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData6.result
new file mode 100644
index 0000000..4014f6d
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData6.result
@@ -0,0 +1,3 @@
+unique_key,maximum
+-------------------------------
+0,null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData7.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData7.result
new file mode 100644
index 0000000..c2cc22e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData7.result
@@ -0,0 +1,3 @@
+maximum,unique_key
+-------------------------------
+null,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData8.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData8.result
new file mode 100644
index 0000000..c2cc22e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData8.result
@@ -0,0 +1,3 @@
+maximum,unique_key
+-------------------------------
+null,0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData9.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData9.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData9.result
new file mode 100644
index 0000000..1f6d988
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithNullData9.result
@@ -0,0 +1,2 @@
+l_orderkey,unique_key
+-------------------------------
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
new file mode 100644
index 0000000..a8fbe00
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
@@ -0,0 +1,5 @@
+a,b,c,d
+-------------------------------
+1,##,##,2
+2,##,##,2
+3,##,##,1
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
new file mode 100644
index 0000000..c7db60e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
@@ -0,0 +1,6 @@
+total
+-------------------------------
+4
+4
+6
+6
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
new file mode 100644
index 0000000..c2b2851
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
@@ -0,0 +1,6 @@
+total1,total2
+-------------------------------
+2,2
+2,2
+3,3
+3,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithJson.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithJson.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithJson.result
new file mode 100644
index 0000000..81f1bfd
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithJson.result
@@ -0,0 +1,5 @@
+l_orderkey,total,num
+-------------------------------
+1,1.0,3
+2,2.0,1
+3,2.5,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit1.result
new file mode 100644
index 0000000..23bbaea
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit1.result
@@ -0,0 +1,3 @@
+?sum
+-------------------------------
+7
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit2.result
new file mode 100644
index 0000000..23bbaea
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit2.result
@@ -0,0 +1,3 @@
+?sum
+-------------------------------
+7
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit3.result
new file mode 100644
index 0000000..e882158
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithLimit3.result
@@ -0,0 +1,3 @@
+l_orderkey,?sum
+-------------------------------
+1,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc.result
new file mode 100644
index 0000000..1e8821c
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc.result
@@ -0,0 +1,7 @@
+?count
+-------------------------------
+4
+4
+5
+5
+5

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
new file mode 100644
index 0000000..1413e41
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
@@ -0,0 +1,7 @@
+n_regionkey,cnt
+-------------------------------
+0,5
+1,5
+2,5
+3,5
+4,5

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
new file mode 100644
index 0000000..fcd604e
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithAggFunction.result
@@ -0,0 +1,4 @@
+l_orderkey,total,num
+-------------------------------
+2,2.0,1
+3,2.5,3

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
new file mode 100644
index 0000000..81f1bfd
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testHavingWithNamedTarget.result
@@ -0,0 +1,5 @@
+l_orderkey,total,num
+-------------------------------
+1,1.0,3
+2,2.0,1
+3,2.5,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
new file mode 100644
index 0000000..e1ba22d
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
@@ -0,0 +1,3 @@
+?avgpy,?avg_1,?countpy_2
+-------------------------------
+12.0,12.0,25
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
new file mode 100644
index 0000000..2852167
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
@@ -0,0 +1,4 @@
+?countpy,?count_1
+-------------------------------
+2,2
+3,3
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
new file mode 100644
index 0000000..7338988
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
@@ -0,0 +1,5 @@
+?avgpy,?countpy_1,?avg_2,?count_3
+-------------------------------
+173665.47,1,173665.47,1
+193846.25,1,193846.25,1
+46929.18,1,46929.18,1

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithHaving.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithHaving.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithHaving.result
new file mode 100644
index 0000000..b8369d2
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithHaving.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/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithNullData.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithNullData.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithNullData.result
new file mode 100644
index 0000000..1f6d988
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdafWithNullData.result
@@ -0,0 +1,2 @@
+l_orderkey,unique_key
+-------------------------------
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestHBaseTable/testBinaryMappedQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestHBaseTable/testBinaryMappedQuery.result b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testBinaryMappedQuery.result
new file mode 100644
index 0000000..8d50bf1
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testBinaryMappedQuery.result
@@ -0,0 +1,81 @@
+rk,col1,col2,col3
+-------------------------------
+21,a-21,{"k1":"k1-21", "k2":"k2-21"},21
+22,a-22,{"k1":"k1-22", "k2":"k2-22"},22
+23,a-23,{"k1":"k1-23", "k2":"k2-23"},23
+24,a-24,{"k1":"k1-24", "k2":"k2-24"},24
+25,a-25,{"k1":"k1-25", "k2":"k2-25"},25
+26,a-26,{"k1":"k1-26", "k2":"k2-26"},26
+27,a-27,{"k1":"k1-27", "k2":"k2-27"},27
+28,a-28,{"k1":"k1-28", "k2":"k2-28"},28
+29,a-29,{"k1":"k1-29", "k2":"k2-29"},29
+30,a-30,{"k1":"k1-30", "k2":"k2-30"},30
+31,a-31,{"k1":"k1-31", "k2":"k2-31"},31
+32,a-32,{"k1":"k1-32", "k2":"k2-32"},32
+33,a-33,{"k1":"k1-33", "k2":"k2-33"},33
+34,a-34,{"k1":"k1-34", "k2":"k2-34"},34
+35,a-35,{"k1":"k1-35", "k2":"k2-35"},35
+36,a-36,{"k1":"k1-36", "k2":"k2-36"},36
+37,a-37,{"k1":"k1-37", "k2":"k2-37"},37
+38,a-38,{"k1":"k1-38", "k2":"k2-38"},38
+39,a-39,{"k1":"k1-39", "k2":"k2-39"},39
+40,a-40,{"k1":"k1-40", "k2":"k2-40"},40
+41,a-41,{"k1":"k1-41", "k2":"k2-41"},41
+42,a-42,{"k1":"k1-42", "k2":"k2-42"},42
+43,a-43,{"k1":"k1-43", "k2":"k2-43"},43
+44,a-44,{"k1":"k1-44", "k2":"k2-44"},44
+45,a-45,{"k1":"k1-45", "k2":"k2-45"},45
+46,a-46,{"k1":"k1-46", "k2":"k2-46"},46
+47,a-47,{"k1":"k1-47", "k2":"k2-47"},47
+48,a-48,{"k1":"k1-48", "k2":"k2-48"},48
+49,a-49,{"k1":"k1-49", "k2":"k2-49"},49
+50,a-50,{"k1":"k1-50", "k2":"k2-50"},50
+51,a-51,{"k1":"k1-51", "k2":"k2-51"},51
+52,a-52,{"k1":"k1-52", "k2":"k2-52"},52
+53,a-53,{"k1":"k1-53", "k2":"k2-53"},53
+54,a-54,{"k1":"k1-54", "k2":"k2-54"},54
+55,a-55,{"k1":"k1-55", "k2":"k2-55"},55
+56,a-56,{"k1":"k1-56", "k2":"k2-56"},56
+57,a-57,{"k1":"k1-57", "k2":"k2-57"},57
+58,a-58,{"k1":"k1-58", "k2":"k2-58"},58
+59,a-59,{"k1":"k1-59", "k2":"k2-59"},59
+60,a-60,{"k1":"k1-60", "k2":"k2-60"},60
+61,a-61,{"k1":"k1-61", "k2":"k2-61"},61
+62,a-62,{"k1":"k1-62", "k2":"k2-62"},62
+63,a-63,{"k1":"k1-63", "k2":"k2-63"},63
+64,a-64,{"k1":"k1-64", "k2":"k2-64"},64
+65,a-65,{"k1":"k1-65", "k2":"k2-65"},65
+66,a-66,{"k1":"k1-66", "k2":"k2-66"},66
+67,a-67,{"k1":"k1-67", "k2":"k2-67"},67
+68,a-68,{"k1":"k1-68", "k2":"k2-68"},68
+69,a-69,{"k1":"k1-69", "k2":"k2-69"},69
+70,a-70,{"k1":"k1-70", "k2":"k2-70"},70
+71,a-71,{"k1":"k1-71", "k2":"k2-71"},71
+72,a-72,{"k1":"k1-72", "k2":"k2-72"},72
+73,a-73,{"k1":"k1-73", "k2":"k2-73"},73
+74,a-74,{"k1":"k1-74", "k2":"k2-74"},74
+75,a-75,{"k1":"k1-75", "k2":"k2-75"},75
+76,a-76,{"k1":"k1-76", "k2":"k2-76"},76
+77,a-77,{"k1":"k1-77", "k2":"k2-77"},77
+78,a-78,{"k1":"k1-78", "k2":"k2-78"},78
+79,a-79,{"k1":"k1-79", "k2":"k2-79"},79
+80,a-80,{"k1":"k1-80", "k2":"k2-80"},80
+81,a-81,{"k1":"k1-81", "k2":"k2-81"},81
+82,a-82,{"k1":"k1-82", "k2":"k2-82"},82
+83,a-83,{"k1":"k1-83", "k2":"k2-83"},83
+84,a-84,{"k1":"k1-84", "k2":"k2-84"},84
+85,a-85,{"k1":"k1-85", "k2":"k2-85"},85
+86,a-86,{"k1":"k1-86", "k2":"k2-86"},86
+87,a-87,{"k1":"k1-87", "k2":"k2-87"},87
+88,a-88,{"k1":"k1-88", "k2":"k2-88"},88
+89,a-89,{"k1":"k1-89", "k2":"k2-89"},89
+90,a-90,{"k1":"k1-90", "k2":"k2-90"},90
+91,a-91,{"k1":"k1-91", "k2":"k2-91"},91
+92,a-92,{"k1":"k1-92", "k2":"k2-92"},92
+93,a-93,{"k1":"k1-93", "k2":"k2-93"},93
+94,a-94,{"k1":"k1-94", "k2":"k2-94"},94
+95,a-95,{"k1":"k1-95", "k2":"k2-95"},95
+96,a-96,{"k1":"k1-96", "k2":"k2-96"},96
+97,a-97,{"k1":"k1-97", "k2":"k2-97"},97
+98,a-98,{"k1":"k1-98", "k2":"k2-98"},98
+99,a-99,{"k1":"k1-99", "k2":"k2-99"},99
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestHBaseTable/testCTAS.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestHBaseTable/testCTAS.result b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testCTAS.result
new file mode 100644
index 0000000..72013f2
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testCTAS.result
@@ -0,0 +1,100 @@
+000, value0
+001, value1
+002, value2
+003, value3
+004, value4
+005, value5
+006, value6
+007, value7
+008, value8
+009, value9
+010, value10
+011, value11
+012, value12
+013, value13
+014, value14
+015, value15
+016, value16
+017, value17
+018, value18
+019, value19
+020, value20
+021, value21
+022, value22
+023, value23
+024, value24
+025, value25
+026, value26
+027, value27
+028, value28
+029, value29
+030, value30
+031, value31
+032, value32
+033, value33
+034, value34
+035, value35
+036, value36
+037, value37
+038, value38
+039, value39
+040, value40
+041, value41
+042, value42
+043, value43
+044, value44
+045, value45
+046, value46
+047, value47
+048, value48
+049, value49
+050, value50
+051, value51
+052, value52
+053, value53
+054, value54
+055, value55
+056, value56
+057, value57
+058, value58
+059, value59
+060, value60
+061, value61
+062, value62
+063, value63
+064, value64
+065, value65
+066, value66
+067, value67
+068, value68
+069, value69
+070, value70
+071, value71
+072, value72
+073, value73
+074, value74
+075, value75
+076, value76
+077, value77
+078, value78
+079, value79
+080, value80
+081, value81
+082, value82
+083, value83
+084, value84
+085, value85
+086, value86
+087, value87
+088, value88
+089, value89
+090, value90
+091, value91
+092, value92
+093, value93
+094, value94
+095, value95
+096, value96
+097, value97
+098, value98
+099, value99

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestHBaseTable/testColumnKeyValueSelectQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestHBaseTable/testColumnKeyValueSelectQuery.result b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testColumnKeyValueSelectQuery.result
new file mode 100644
index 0000000..82d4fd2
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testColumnKeyValueSelectQuery.result
@@ -0,0 +1,12 @@
+rk1,col2_key,col2_value,col3
+-------------------------------
+rk-0,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-0
+rk-1,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-1
+rk-2,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-2
+rk-3,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-3
+rk-4,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-4
+rk-5,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-5
+rk-6,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-6
+rk-7,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-7
+rk-8,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-8
+rk-9,["key-0", "key-1", "key-2", "key-3", "key-4"],["value-0", "value-1", "value-2", "value-3", "value-4"],col3-value-9
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestHBaseTable/testIndexPredication.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestHBaseTable/testIndexPredication.result b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testIndexPredication.result
new file mode 100644
index 0000000..f38d238
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testIndexPredication.result
@@ -0,0 +1,38 @@
+rk,col1,col2,col3
+-------------------------------
+020,a-20,{"k1":"k1-20", "k2":"k2-20"},b-20
+021,a-21,{"k1":"k1-21", "k2":"k2-21"},b-21
+022,a-22,{"k1":"k1-22", "k2":"k2-22"},b-22
+023,a-23,{"k1":"k1-23", "k2":"k2-23"},b-23
+024,a-24,{"k1":"k1-24", "k2":"k2-24"},b-24
+025,a-25,{"k1":"k1-25", "k2":"k2-25"},b-25
+026,a-26,{"k1":"k1-26", "k2":"k2-26"},b-26
+027,a-27,{"k1":"k1-27", "k2":"k2-27"},b-27
+028,a-28,{"k1":"k1-28", "k2":"k2-28"},b-28
+029,a-29,{"k1":"k1-29", "k2":"k2-29"},b-29
+030,a-30,{"k1":"k1-30", "k2":"k2-30"},b-30
+031,a-31,{"k1":"k1-31", "k2":"k2-31"},b-31
+032,a-32,{"k1":"k1-32", "k2":"k2-32"},b-32
+033,a-33,{"k1":"k1-33", "k2":"k2-33"},b-33
+034,a-34,{"k1":"k1-34", "k2":"k2-34"},b-34
+035,a-35,{"k1":"k1-35", "k2":"k2-35"},b-35
+036,a-36,{"k1":"k1-36", "k2":"k2-36"},b-36
+037,a-37,{"k1":"k1-37", "k2":"k2-37"},b-37
+038,a-38,{"k1":"k1-38", "k2":"k2-38"},b-38
+039,a-39,{"k1":"k1-39", "k2":"k2-39"},b-39
+040,a-40,{"k1":"k1-40", "k2":"k2-40"},b-40
+041,a-41,{"k1":"k1-41", "k2":"k2-41"},b-41
+042,a-42,{"k1":"k1-42", "k2":"k2-42"},b-42
+043,a-43,{"k1":"k1-43", "k2":"k2-43"},b-43
+044,a-44,{"k1":"k1-44", "k2":"k2-44"},b-44
+045,a-45,{"k1":"k1-45", "k2":"k2-45"},b-45
+046,a-46,{"k1":"k1-46", "k2":"k2-46"},b-46
+047,a-47,{"k1":"k1-47", "k2":"k2-47"},b-47
+048,a-48,{"k1":"k1-48", "k2":"k2-48"},b-48
+049,a-49,{"k1":"k1-49", "k2":"k2-49"},b-49
+050,a-50,{"k1":"k1-50", "k2":"k2-50"},b-50
+051,a-51,{"k1":"k1-51", "k2":"k2-51"},b-51
+052,a-52,{"k1":"k1-52", "k2":"k2-52"},b-52
+053,a-53,{"k1":"k1-53", "k2":"k2-53"},b-53
+054,a-54,{"k1":"k1-54", "k2":"k2-54"},b-54
+055,a-55,{"k1":"k1-55", "k2":"k2-55"},b-55
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/tajo/blob/a4106883/tajo-core-tests/src/test/resources/results/TestHBaseTable/testInsertInto.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestHBaseTable/testInsertInto.result b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testInsertInto.result
new file mode 100644
index 0000000..e0c97ef
--- /dev/null
+++ b/tajo-core-tests/src/test/resources/results/TestHBaseTable/testInsertInto.result
@@ -0,0 +1,3 @@
+1, 1996-03-13, {"": "N"}, 7706
+2, 1997-01-28, {"": "N"}, 1191
+3, 1994-02-02, {"": "R"}, 1798


Mime
View raw message