tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hyun...@apache.org
Subject [1/5] TAJO-476: Add a test development kit for unit tests based on executions of queries.
Date Tue, 07 Jan 2014 02:23:18 GMT
Updated Branches:
  refs/heads/master f825dcebc -> eaf0a5854


http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/eaf0a585/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect3.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect3.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect3.result
new file mode 100644
index 0000000..1530637
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelect3.result
@@ -0,0 +1,7 @@
+plus
+-------------------------------
+2
+2
+4
+5
+6
\ 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/testSelectAsterik.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterik.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterik.result
new file mode 100644
index 0000000..ec6b911
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterik.result
@@ -0,0 +1,7 @@
+l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discount,l_tax,l_returnflag,l_linestatus,l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment
+-------------------------------
+1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular
courts above the
+1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly
final dependencies: slyly bold 
+2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven
requests. deposits breach a
+3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of
the furiously brave acco
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL,
unusual accounts. eve
\ 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/testSelectDistinct.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
new file mode 100644
index 0000000..75e7d72
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectDistinct.result
@@ -0,0 +1,7 @@
+l_orderkey,l_linenumber
+-------------------------------
+1,1
+1,2
+2,1
+3,1
+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/TestSelectQuery/testStringCompare.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testStringCompare.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testStringCompare.result
new file mode 100644
index 0000000..040ac19
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testStringCompare.result
@@ -0,0 +1,5 @@
+l_orderkey
+-------------------------------
+1
+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/testUnion1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion1.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion1.result
new file mode 100644
index 0000000..3b4dcf4
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion1.result
@@ -0,0 +1,10 @@
+num
+-------------------------------
+1
+2
+3
+4
+5
+36901
+78002
+123314
\ 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/testUnion2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion2.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion2.result
new file mode 100644
index 0000000..d269baa
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testUnion2.result
@@ -0,0 +1,12 @@
+l_orderkey
+-------------------------------
+1
+1
+1
+1
+2
+2
+3
+3
+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/testWhereCond1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCond1.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCond1.result
new file mode 100644
index 0000000..ecbb913
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCond1.result
@@ -0,0 +1,3 @@
+plus
+-------------------------------
+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/TestSelectQuery/testWhereCondWithAlias1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias1.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias1.result
new file mode 100644
index 0000000..058546f
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias1.result
@@ -0,0 +1,4 @@
+orderkey,l_partkey
+-------------------------------
+1,1
+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/testWhereCondWithAlias2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias2.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias2.result
new file mode 100644
index 0000000..74ccd20
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testWhereCondWithAlias2.result
@@ -0,0 +1,4 @@
+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/TestSortQuery/testSort.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSort.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSort.result
new file mode 100644
index 0000000..a5e9af3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSort.result
@@ -0,0 +1,7 @@
+l_linenumber,l_orderkey
+-------------------------------
+1,1
+2,1
+1,2
+1,3
+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/TestSortQuery/testSortAfterGroupby.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
new file mode 100644
index 0000000..bf94765
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupby.result
@@ -0,0 +1,5 @@
+?max,l_orderkey
+-------------------------------
+36.0,1
+38.0,2
+49.0,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/TestSortQuery/testSortAfterGroupbyWithAlias.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
new file mode 100644
index 0000000..bc0bf1b
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortAfterGroupbyWithAlias.result
@@ -0,0 +1,5 @@
+max_quantity,l_orderkey
+-------------------------------
+36.0,1
+38.0,2
+49.0,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/TestSortQuery/testSortDesc.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortDesc.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortDesc.result
new file mode 100644
index 0000000..6450adf
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortDesc.result
@@ -0,0 +1,7 @@
+l_linenumber,l_orderkey
+-------------------------------
+1,3
+2,3
+1,2
+1,1
+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/TestSortQuery/testSortWithAliasButOriginalName.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
new file mode 100644
index 0000000..81bb293
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasButOriginalName.result
@@ -0,0 +1,7 @@
+l_linenumber,sortkey
+-------------------------------
+1,1
+2,1
+1,2
+1,3
+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/TestSortQuery/testSortWithAliasKey.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasKey.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasKey.result
new file mode 100644
index 0000000..81bb293
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testSortWithAliasKey.result
@@ -0,0 +1,7 @@
+l_linenumber,sortkey
+-------------------------------
+1,1
+2,1
+1,2
+1,3
+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/TestSortQuery/testTopK.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testTopK.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testTopK.result
new file mode 100644
index 0000000..df40678
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestSortQuery/testTopK.result
@@ -0,0 +1,5 @@
+l_orderkey,l_linenumber
+-------------------------------
+3,1
+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/TestTPCH/testQ1OrderBy.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ1OrderBy.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ1OrderBy.result
new file mode 100644
index 0000000..94b5e84
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ1OrderBy.result
@@ -0,0 +1,4 @@
+l_returnflag,l_linestatus,count_order
+-------------------------------
+N,O,3
+R,F,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/TestTPCH/testQ2FourJoins.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ2FourJoins.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ2FourJoins.result
new file mode 100644
index 0000000..7c81978
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testQ2FourJoins.result
@@ -0,0 +1,3 @@
+s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment,ps_supplycost,r_name,p_type,p_size
+-------------------------------
+4192.4,Supplier#000000003,ARGENTINA,2,Manufacturer#1,q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3,11-383-516-1199,blithely
silent requests after the express dependencies are sl,1.01,AMERICA,LARGE BRUSHED BRASS,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/results/TestTPCH/testTPCH14Expr.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testTPCH14Expr.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testTPCH14Expr.result
new file mode 100644
index 0000000..6bc69cc
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTPCH/testTPCH14Expr.result
@@ -0,0 +1,3 @@
+promo_revenue
+-------------------------------
+33.610645634855025
\ 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/TestTableSubQuery/testGroupBySubQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testGroupBySubQuery.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testGroupBySubQuery.result
new file mode 100644
index 0000000..628924b
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testGroupBySubQuery.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/TestTableSubQuery/testJoinSubQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery.result
new file mode 100644
index 0000000..0c0acd3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery.result
@@ -0,0 +1,4 @@
+n_regionkey,r_regionkey,n_name,r_name
+-------------------------------
+0,0,ALGERIA,AFRICA
+1,1,ARGENTINA,AMERICA
\ 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/TestTableSubQuery/testJoinSubQuery2.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery2.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery2.result
new file mode 100644
index 0000000..0c0acd3
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testJoinSubQuery2.result
@@ -0,0 +1,4 @@
+n_regionkey,r_regionkey,n_name,r_name
+-------------------------------
+0,0,ALGERIA,AFRICA
+1,1,ARGENTINA,AMERICA
\ 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/TestTableSubQuery/testTableSubquery1.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
new file mode 100644
index 0000000..337de32
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/TestTableSubQuery/testTableSubquery1.result
@@ -0,0 +1,7 @@
+l_orderkey
+-------------------------------
+1
+1
+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/testBuildDDL.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/resources/results/testBuildDDL.result b/tajo-core/tajo-core-backend/src/test/resources/results/testBuildDDL.result
new file mode 100644
index 0000000..4fd87c2
--- /dev/null
+++ b/tajo-core/tajo-core-backend/src/test/resources/results/testBuildDDL.result
@@ -0,0 +1,5 @@
+--
+-- Name: table1; Type: TABLE; Storage: CSV
+-- Path: /table1
+--
+CREATE EXTERNAL TABLE table1 (name BLOB, addr TEXT) USING CSV WITH ('csv.delimiter'='|',
'compression.codec'='org.apache.hadoop.io.compress.GzipCodec') LOCATION '/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/results/testBuildDDL.result
----------------------------------------------------------------------
diff --git a/tajo-core/tajo-core-backend/src/test/results/testBuildDDL.result b/tajo-core/tajo-core-backend/src/test/results/testBuildDDL.result
deleted file mode 100644
index 4fd87c2..0000000
--- a/tajo-core/tajo-core-backend/src/test/results/testBuildDDL.result
+++ /dev/null
@@ -1,5 +0,0 @@
---
--- Name: table1; Type: TABLE; Storage: CSV
--- Path: /table1
---
-CREATE EXTERNAL TABLE table1 (name BLOB, addr TEXT) USING CSV WITH ('csv.delimiter'='|',
'compression.codec'='org.apache.hadoop.io.compress.GzipCodec') LOCATION '/table1';
\ No newline at end of file


Mime
View raw message