You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2015/09/22 01:12:20 UTC
[05/14] incubator-trafodion git commit: Update regression expected
files, mostly for HIVE and for EXECUTOR/TEST002
Update regression expected files, mostly for HIVE and for EXECUTOR/TEST002
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/566ce152
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/566ce152
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/566ce152
Branch: refs/heads/master
Commit: 566ce15272c238621dc1d121f77137b8837e67e8
Parents: d3e4151
Author: Qifan Chen <qf...@dev02.trafodion.org>
Authored: Sat Sep 19 02:54:02 2015 +0000
Committer: Qifan Chen <qf...@dev02.trafodion.org>
Committed: Sat Sep 19 02:54:02 2015 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED002.SB | 29 +++++++++++++++++----------
core/sql/regress/hive/EXPECTED001 | 8 ++++++++
core/sql/regress/hive/EXPECTED003 | 24 ++++++++++------------
core/sql/regress/hive/EXPECTED004 | 4 ++--
core/sql/regress/hive/EXPECTED020 | 18 ++++++++---------
5 files changed, 48 insertions(+), 35 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/566ce152/core/sql/regress/executor/EXPECTED002.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED002.SB b/core/sql/regress/executor/EXPECTED002.SB
index 5d482d9..b0511c2 100644
--- a/core/sql/regress/executor/EXPECTED002.SB
+++ b/core/sql/regress/executor/EXPECTED002.SB
@@ -61,7 +61,7 @@ W X
>> -- should work
>>update t002v set w=0;
-*** ERROR[4028] Table or view SEABASE.SCH.T002V is not updatable.
+*** ERROR[4028] Table or view TRAFODION.SCH.T002V is not updatable.
*** ERROR[8822] The statement was not prepared.
@@ -957,7 +957,7 @@ A (EXPR)
+> (select a,sum(a) from t002t1 group by a) y) z(a,b,c,d)
+> group by a;
-*** ERROR[4001] Column B is not found. Tables in scope: X, Y. Default schema: SEABASE.SCH.
+*** ERROR[4001] Column B is not found. Tables in scope: X, Y. Default schema: TRAFODION.SCH.
*** ERROR[8822] The statement was not prepared.
@@ -1032,28 +1032,28 @@ A (EXPR)
>>
>>select *, sum(a) from t002t1;
-*** ERROR[4012] Column reference SEABASE.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
+*** ERROR[4012] Column reference TRAFODION.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
*** ERROR[8822] The statement was not prepared.
>> -- err 4012
>>select sum(a), * from t002t1;
-*** ERROR[4012] Column reference SEABASE.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
+*** ERROR[4012] Column reference TRAFODION.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
*** ERROR[8822] The statement was not prepared.
>> -- err 4012
>>select *, sum(a) from t002t1 having 1=1;
-*** ERROR[4012] Column reference SEABASE.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
+*** ERROR[4012] Column reference TRAFODION.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
*** ERROR[8822] The statement was not prepared.
>> -- err 4012
>>select *, sum(a) from t002t1 group by b;
-*** ERROR[4012] Column reference SEABASE.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
+*** ERROR[4012] Column reference TRAFODION.SCH.T002T1.A must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.
*** ERROR[8822] The statement was not prepared.
@@ -1102,7 +1102,7 @@ A B C D (EXPR)
>>-- The select list contains a non-grouping non-aggregated column.
>>SELECT A,MAX(A) FROM T002T1;
-*** ERROR[4021] The select list contains a nongrouping non-aggregated column, SEABASE.SCH.T002T1.A.
+*** ERROR[4021] The select list contains a nongrouping non-aggregated column, TRAFODION.SCH.T002T1.A.
*** ERROR[8822] The statement was not prepared.
@@ -1129,7 +1129,7 @@ A (EXPR)
>>-- The select list contains a non-grouping non-aggregated column.
>>SELECT A,COUNT(*) FROM T002T1;
-*** ERROR[4021] The select list contains a nongrouping non-aggregated column, SEABASE.SCH.T002T1.A.
+*** ERROR[4021] The select list contains a nongrouping non-aggregated column, TRAFODION.SCH.T002T1.A.
*** ERROR[8822] The statement was not prepared.
@@ -1156,7 +1156,7 @@ A (EXPR)
>>-- The select list contains a non-grouping non-aggregated column.
>>SELECT (SELECT A FROM T002T2 WHERE OUTT.A > A AND MAX(OUTT.B)>'C') FROM T002T1 OUTT;
-*** ERROR[4021] The select list contains a nongrouping non-aggregated column, SEABASE.SCH.T002T1.A.
+*** ERROR[4021] The select list contains a nongrouping non-aggregated column, TRAFODION.SCH.T002T1.A.
*** ERROR[8822] The statement was not prepared.
@@ -1571,9 +1571,13 @@ C (EXPR) (EXPR)
20 27648 30
--- 6 row(s) selected.
+>>
>>control query shape merge_join(cut,cut);
--- SQL operation complete.
+>>cqd PCODE_OPT_LEVEL '0';
+
+--- SQL operation complete.
>>select t002t6.c, character_length(T.b), T.a+10
+>from t002t6
+>left outer join (
@@ -1598,6 +1602,9 @@ C (EXPR) (EXPR)
20 27648 30
--- 6 row(s) selected.
+>>cqd PCODE_OPT_LEVEL reset;
+
+--- SQL operation complete.
>>control query shape cut;
--- SQL operation complete.
@@ -6709,7 +6716,7 @@ FOO
+> WHERE
+> (SELECT 27 FROM TbadCorr) = 27;
-*** ERROR[4082] Object SEABASE.SCH.TBADCORR does not exist or is inaccessible.
+*** ERROR[4082] Object TRAFODION.SCH.TBADCORR does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
@@ -6862,7 +6869,7 @@ FOO
+> WHERE
+> (SELECT 27 FROM TbadCorr) = 27;
-*** ERROR[4082] Object SEABASE.SCH.TBADCORR does not exist or is inaccessible.
+*** ERROR[4082] Object TRAFODION.SCH.TBADCORR does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/566ce152/core/sql/regress/hive/EXPECTED001
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED001 b/core/sql/regress/hive/EXPECTED001
index 7a6e9bd..b015023 100644
--- a/core/sql/regress/hive/EXPECTED001
+++ b/core/sql/regress/hive/EXPECTED001
@@ -85,6 +85,8 @@
>>
>>select c_customer_sk from customer where c_customer_sk < 100;
+*** WARNING[6008] Statistics for column (C_CUSTOMER_SK) from table HIVE.HIVE.CUSTOMER were not available. As a result, the access path chosen might not be the best possible.
+
C_CUSTOMER_SK
-------------
@@ -193,6 +195,8 @@ C_CUSTOMER_SK
>>select ca_gmt_offset from customer_address where ca_gmt_offset < -8
+>order by ca_gmt_offset;
+*** WARNING[6008] Statistics for column (CA_GMT_OFFSET) from table HIVE.HIVE.CUSTOMER_ADDRESS were not available. As a result, the access path chosen might not be the best possible.
+
CA_GMT_OFFSET
---------------
@@ -1045,6 +1049,8 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
>>
>>select t_time from time_dim where t_time > 100 and t_time < 200 ;
+*** WARNING[6008] Statistics for column (T_TIME) from table HIVE.HIVE.TIME_DIM were not available. As a result, the access path chosen might not be the best possible.
+
T_TIME
-----------
@@ -1172,6 +1178,8 @@ S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE
>>
>>select d_date from date_dim where d_date > cast('2099-01-01' as timestamp);
+*** WARNING[6008] Statistics for column (D_DATE) from table HIVE.HIVE.DATE_DIM were not available. As a result, the access path chosen might not be the best possible.
+
D_DATE
--------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/566ce152/core/sql/regress/hive/EXPECTED003
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED003 b/core/sql/regress/hive/EXPECTED003
index cd31d30..8c8006a 100644
--- a/core/sql/regress/hive/EXPECTED003
+++ b/core/sql/regress/hive/EXPECTED003
@@ -523,12 +523,11 @@ T_TIME_SK T_TIME_ID T_TIME T_HOUR T_MINUTE T
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-7 . 8 root 4.00E+000
-6 . 7 esp_exchange 1:2(hash2) 4.00E+000
-4 . 6 hive_insert INS_STORE_SALES_SUMM 4.00E+000
-3 . 4 hash_partial_groupby 4.00E+000
-2 . 3 esp_exchange 2(hash2):2(hash2) 4.00E+000
-1 . 2 hash_partial_groupby 4.00E+000
+6 . 7 root 2.92E+006
+5 . 6 esp_exchange 1:2(hash2) 2.92E+006
+3 . 5 hive_insert INS_STORE_SALES_SUMM 2.92E+006
+2 . 3 hash_groupby 2.92E+006
+1 . 2 esp_exchange 2(hash2):2(hash2) 2.92E+006
. . 1 hive_scan STORE_SALES 2.92E+006
--- SQL operation complete.
@@ -596,13 +595,12 @@ test lp bug # 1355477
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-9 . 10 root 5.00E+000
-1 8 9 blocked_union 5.00E+000
-7 . 8 esp_exchange 1:2(hash2) 4.00E+000
-5 . 7 hive_insert INS_STORE_SALES_SUMM 4.00E+000
-4 . 5 hash_partial_groupby 4.00E+000
-3 . 4 esp_exchange 2(hash2):2(hash2) 4.00E+000
-2 . 3 hash_partial_groupby 4.00E+000
+8 . 9 root 2.92E+006
+1 7 8 blocked_union 2.92E+006
+6 . 7 esp_exchange 1:2(hash2) 2.92E+006
+4 . 6 hive_insert INS_STORE_SALES_SUMM 2.92E+006
+3 . 4 hash_groupby 2.92E+006
+2 . 3 esp_exchange 2(hash2):2(hash2) 2.92E+006
. . 2 hive_scan STORE_SALES 2.92E+006
. . 1 hive_truncate 1.00E+000
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/566ce152/core/sql/regress/hive/EXPECTED004
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED004 b/core/sql/regress/hive/EXPECTED004
index 303aa6d..08ecaff 100644
--- a/core/sql/regress/hive/EXPECTED004
+++ b/core/sql/regress/hive/EXPECTED004
@@ -55,7 +55,7 @@ C_CUSTOMER_SK C_CUSTOMER_ID C_CURRENT_CDEMO_SK C_CURRENT_HDEMO_SK
25 AAAAAAAAJBAAAAAA 476176 3278 25933 2449246 2449216 Miss Nancy Mccormick N 6 10 1973 BAHAMAS ? Nancy.Mccormick@DA26I9ZAr 2452425
26 AAAAAAAAKBAAAAAA 230278 1242 28206 2449816 2449786 Ms. Monique Baker N 14 6 1991 MOROCCO ? Monique.Baker@9uEucNczY.o 2452356
27 AAAAAAAALBAAAAAA 111621 835 16096 2450611 2450581 Dr. Shawn Prather N 7 3 1972 PUERTO RICO ? Shawn.Prather@8BusRYegn6. 2452353
- 28 AAAAAAAAMBAAAAAA 889961 897 33480 2452615 2452585 Miss Edith Hernandez Y 17 8 1959 C?TE D'IVOIRE ? Edith.Hernandez@BNHL0k.co 2452631
+ 28 AAAAAAAAMBAAAAAA 889961 897 33480 2452615 2452585 Miss Edith Hernandez Y 17 8 1959 C�TE D'IVOIRE ? Edith.Hernandez@BNHL0k.co 2452631
29 AAAAAAAANBAAAAAA 1634269 1204 44139 2452216 2452186 Ms. Margaret Collins Y 25 8 1973 NETHERLANDS ANTILLES ? Margaret.Collins@9obPr3UV 2452496
30 AAAAAAAAOBAAAAAA 84232 5869 45459 2449916 2449886 Dr. Pamela Luna Y 4 7 1956 GUAM ? Pamela.Luna@QBGuhL36lnA.e 2452410
31 AAAAAAAAPBAAAAAA 1275120 5724 7128 2452054 2452024 Dr. William Craig N 13 6 1964 SPAIN ? William.Craig@prVDE1E8AHc 2452336
@@ -107,7 +107,7 @@ C_CUSTOMER_SK C_CUSTOMER_ID C_CURRENT_CDEMO_SK C_CURRENT_HDEMO_SK
77 AAAAAAAANEAAAAAA 915180 2167 37154 2451632 2451602 Dr. Darrin Smith N 30 5 1931 UNITED STATES ? Darrin.Smith@Mti.edu 2452355
78 AAAAAAAAOEAAAAAA 1092537 3677 7264 2449388 2449358 Ms. Wanda Davis N 11 5 1940 NETHERLANDS ANTILLES ? Wanda.Davis@I6s7DD86i6.ed 2452339
79 AAAAAAAAPEAAAAAA 389494 3493 9539 2450863 2450833 Miss Sandi Tran Y 10 6 1937 FRENCH GUIANA ? Sandi.Tran@myikqStif1Q.ed 2452644
- 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C?TE D'IVOIRE ? Eleanor.Evans@zxvr5rl.org 2452413
+ 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C�TE D'IVOIRE ? Eleanor.Evans@zxvr5rl.org 2452413
81 AAAAAAAABFAAAAAA 728917 388 48306 2452562 2452532 Ms. Jessica Levesque Y 17 7 1940 ALBANIA ? Jessica.Levesque@06mGqI9m 2452414
82 AAAAAAAACFAAAAAA 75627 5081 30088 2450357 2450327 Sir Max Mueller N 26 2 1947 IRAQ ? Max.Mueller@xqCZRBSrTGD6C 2452303
83 AAAAAAAADFAAAAAA 976724 5574 40824 2451032 2451002 Miss Daisy Flynn N 24 1 1943 NEW ZEALAND ? Daisy.Flynn@288e6Z0csxJ.c 2452338
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/566ce152/core/sql/regress/hive/EXPECTED020
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED020 b/core/sql/regress/hive/EXPECTED020
index c04bda7..bd1cdfe 100644
--- a/core/sql/regress/hive/EXPECTED020
+++ b/core/sql/regress/hive/EXPECTED020
@@ -20,7 +20,7 @@
>>invoke hive.hive.store_orc;
-- Definition of hive table STORE_ORC
--- Definition current Sun Nov 9 22:00:42 2014
+-- Definition current Fri Sep 18 21:54:29 2015
(
S_STORE_SK INT
@@ -139,10 +139,10 @@ S_STORE_SK (EXPR)
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-3 . 4 root 4.09E+001
-2 1 3 hybrid_hash_join 4.09E+001
-. . 2 hive_scan STORE_ORC 9.00E+000
-. . 1 hive_scan STORE_ORC 9.00E+000
+3 . 4 root 8.17E+004
+2 1 3 hybrid_hash_join 8.17E+004
+. . 2 hive_scan STORE_ORC 4.08E+003
+. . 1 hive_scan STORE_ORC 4.08E+003
--- SQL operation complete.
>>
@@ -177,10 +177,10 @@ Suite 100 College
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-3 . 4 root 5.00E+001
-2 1 3 hybrid_hash_join 5.00E+001
-. . 2 hive_scan STORE 1.10E+001
-. . 1 hive_scan STORE_ORC 9.00E+000
+3 . 4 root 4.08E+003
+1 2 3 nested_join 4.08E+003
+. . 2 hive_scan STORE_ORC 4.08E+001
+. . 1 hive_scan STORE 1.00E+002
--- SQL operation complete.
>>