Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out Fri Aug 22 21:36:47 2014 @@ -58,10 +58,10 @@ STAGE PLANS: condition expressions: 0 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col4, _col5 + outputColumnNames: _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: string), _col5 (type: string) + expressions: _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table test (key int, value string) partitioned by (p int) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test POSTHOOK: query: create table test (key int, value string) partitioned by (p int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out Fri Aug 22 21:36:47 2014 @@ -350,11 +350,11 @@ STAGE PLANS: keys: 0 key (type: string) 1 _col0 (type: string) - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 input vertices: 0 Map 1 Select Operator - expressions: _col0 (type: string), _col4 (type: string) + expressions: _col0 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false @@ -380,11 +380,11 @@ STAGE PLANS: keys: 0 key (type: string) 1 _col0 (type: string) - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 input vertices: 0 Map 1 Select Operator - expressions: _col0 (type: string), _col4 (type: string) + expressions: _col0 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1 File Output Operator compressed: false @@ -549,12 +549,12 @@ STAGE PLANS: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) - outputColumnNames: _col0, _col4, _col5 + outputColumnNames: _col0, _col5, _col6 input vertices: 0 Map 1 2 Map 8 Select Operator - expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) @@ -619,12 +619,12 @@ STAGE PLANS: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) - outputColumnNames: _col0, _col4, _col5 + outputColumnNames: _col0, _col5, _col6 input vertices: 0 Map 1 2 Map 8 Select Operator - expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) @@ -686,12 +686,12 @@ STAGE PLANS: 0 key (type: string) 1 _col0 (type: string) 2 key (type: string) - outputColumnNames: _col0, _col4, _col5 + outputColumnNames: _col0, _col5, _col6 input vertices: 0 Map 1 2 Map 8 Select Operator - expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 Reduce Output Operator key expressions: _col2 (type: string) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/transform1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/transform1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/transform1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/transform1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table transform1_t1(a string, b string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@transform1_t1 POSTHOOK: query: create table transform1_t1(a string, b string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -61,6 +62,7 @@ POSTHOOK: Input: default@transform1_t1 PREHOOK: query: create table transform1_t2(col array<int>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@transform1_t2 POSTHOOK: query: create table transform1_t2(col array<int>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union2.q.out Fri Aug 22 21:36:47 2014 @@ -1,10 +1,12 @@ -PREHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink +PREHOOK: query: -- SORT_BEFORE_DIFF +-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2) unionsrc PREHOOK: type: QUERY -POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink +POSTHOOK: query: -- SORT_BEFORE_DIFF +-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union3.q.out Fri Aug 22 21:36:47 2014 @@ -1,4 +1,6 @@ -PREHOOK: query: explain +PREHOOK: query: -- SORT_BEFORE_DIFF + +explain SELECT * FROM ( SELECT 1 AS id @@ -16,7 +18,9 @@ FROM ( FROM (SELECT * FROM src LIMIT 1) s2 ) a PREHOOK: type: QUERY -POSTHOOK: query: explain +POSTHOOK: query: -- SORT_BEFORE_DIFF + +explain SELECT * FROM ( SELECT 1 AS id @@ -208,6 +212,7 @@ STAGE PLANS: PREHOOK: query: CREATE TABLE union_out (id int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@union_out POSTHOOK: query: CREATE TABLE union_out (id int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union4.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: -- union case: both subq create table tmptable(key string, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tmptable POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by filesink Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union5.q.out Fri Aug 22 21:36:47 2014 @@ -1,11 +1,13 @@ -PREHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink +PREHOOK: query: -- SORT_BEFORE_DIFF +-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1 UNION ALL select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key PREHOOK: type: QUERY -POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink +POSTHOOK: query: -- SORT_BEFORE_DIFF +-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union6.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: -- union case: 1 subquer create table tmptable(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tmptable POSTHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by filesink Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union7.q.out Fri Aug 22 21:36:47 2014 @@ -1,11 +1,13 @@ -PREHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink +PREHOOK: query: -- SORT_BEFORE_DIFF +-- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink explain select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION ALL select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key PREHOOK: type: QUERY -POSTHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink +POSTHOOK: query: -- SORT_BEFORE_DIFF +-- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink explain select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union8.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union8.q.out Fri Aug 22 21:36:47 2014 @@ -1,11 +1,13 @@ -PREHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink +PREHOOK: query: -- SORT_BEFORE_DIFF +-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink explain select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc PREHOOK: type: QUERY -POSTHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink +POSTHOOK: query: -- SORT_BEFORE_DIFF +-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink explain select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/union9.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/union9.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/union9.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/union9.q.out Fri Aug 22 21:36:47 2014 @@ -1,11 +1,13 @@ -PREHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink +PREHOOK: query: -- SORT_BEFORE_DIFF +-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL select s2.key as key, s2.value as value from src s2 UNION ALL select s3.key as key, s3.value as value from src s3) unionsrc PREHOOK: type: QUERY -POSTHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink +POSTHOOK: query: -- SORT_BEFORE_DIFF +-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink explain select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_cast_constant.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_cast_constant.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_cast_constant.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_cast_constant.q.out Fri Aug 22 21:36:47 2014 @@ -22,6 +22,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k POSTHOOK: query: -- data setup CREATE TABLE over1k(t tinyint, si smallint, @@ -61,6 +62,7 @@ PREHOOK: query: CREATE TABLE over1korc(t STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1korc POSTHOOK: query: CREATE TABLE over1korc(t tinyint, si smallint, i int, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_data_types.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_data_types.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_data_types.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_data_types.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out Fri Aug 22 21:36:47 2014 @@ -107,11 +107,11 @@ POSTHOOK: query: SELECT cint, POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_vgby #### A masked pattern was here #### -NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.715384615385 -5147.907692307693 6010604.3076923073536 1956.576923076922966667 6821.495748565159 6822.606289190924 --3728 6 5831542.269248378 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.211097692 -4033.445769230769 6967702.8672438458471 1161283.811207307641183333 2604201.2704476737 2852759.5602156054 --563 2 -515.621072973 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 -2325.50327307692295 1707.9424961538462 2415.395441814127 -762 2 5831542.269248378 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.211097692 1833.9456923076925 6986288.1567899996925 3493144.07839499984625 3491310.1327026924 4937458.140118758 -6981 3 5831542.269248378 -515.621072973 5830511.027102432 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 -253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.969230769231 -11712.99230769231 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274 -528534767 1024 5831542.269248378 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.211097692 -11710.130769230771 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984 -626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.746153846154 -11712.276923076923 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603 +NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.71538461538500 -5147.90769230769300 6010604.30769230735360 1956.576923076922966667 6821.495748565159 6822.606289190924 +-3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710 1161283.811207307641183333 2604201.2704476737 2852759.5602156054 +-563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590 -2325.50327307692295 1707.9424961538462 2415.395441814127 +762 2 5831542.2692483780 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.21109769200000 1833.9456923076925 6986288.15678999969250 3493144.07839499984625 3491310.1327026924 4937458.140118758 +6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.56077692307690 6983219.08954384584620 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 +253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274 +528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984 +626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.74615384615400 -11712.27692307692300 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_string_concat.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_string_concat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_string_concat.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vector_string_concat.q.out Fri Aug 22 21:36:47 2014 @@ -22,6 +22,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k POSTHOOK: query: -- data setup CREATE TABLE over1k(t tinyint, si smallint, @@ -61,6 +62,7 @@ PREHOOK: query: CREATE TABLE over1korc(t STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1korc POSTHOOK: query: CREATE TABLE over1korc(t tinyint, si smallint, i int, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_part POSTHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out Fri Aug 22 21:36:47 2014 @@ -49,14 +49,14 @@ STAGE PLANS: keys: 0 cint (type: int) 1 cint (type: int) - outputColumnNames: _col2, _col16 + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col2 (type: int), _col16 (type: int) - outputColumnNames: _col2, _col16 + expressions: _col2 (type: int), _col17 (type: int) + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(_col2), max(_col16), min(_col2), avg((_col2 + _col16)) + aggregations: count(_col2), max(_col17), min(_col2), avg((_col2 + _col17)) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out Fri Aug 22 21:36:47 2014 @@ -80,10 +80,10 @@ STAGE PLANS: keys: 0 ctinyint (type: tinyint) 1 ctinyint (type: tinyint) - outputColumnNames: _col0, _col1, _col5, _col14 + outputColumnNames: _col0, _col1, _col5, _col15 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (_col0 = _col14) (type: boolean) + predicate: (_col0 = _col15) (type: boolean) Statistics: Num rows: 25935 Data size: 103741 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: smallint), _col5 (type: double) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out Fri Aug 22 21:36:47 2014 @@ -54,14 +54,14 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} - outputColumnNames: _col2, _col16 + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col2 (type: int), _col16 (type: int) - outputColumnNames: _col2, _col16 + expressions: _col2 (type: int), _col17 (type: int) + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(_col2), max(_col16), min(_col2), avg((_col2 + _col16)) + aggregations: count(_col2), max(_col17), min(_col2), avg((_col2 + _col17)) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- Test timestamp functi CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_string POSTHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end. CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC @@ -32,6 +33,7 @@ POSTHOOK: Lineage: alltypesorc_string.st PREHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_1.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_1 (t timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_1 POSTHOOK: query: create table timestamp_1 (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_2.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_2 (t timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_2 POSTHOOK: query: create table timestamp_2 (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_3.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_3 (t timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_3 POSTHOOK: query: create table timestamp_3 (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_lazy.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_lazy.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_lazy.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_lazy.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_lazy (t timestamp, key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_lazy POSTHOOK: query: create table timestamp_lazy (t timestamp, key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_null.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_null.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_null.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_null.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE timestamp_null (t1 TIMESTAMP) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_null POSTHOOK: query: CREATE TABLE timestamp_null (t1 TIMESTAMP) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_udf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_udf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_udf.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/timestamp_udf.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table timestamp_udf (t timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_udf POSTHOOK: query: create table timestamp_udf (t timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@timestamp_udf PREHOOK: query: create table timestamp_udf_string (t string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_udf_string POSTHOOK: query: create table timestamp_udf_string (t string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/touch.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/touch.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/touch.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/touch.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table tstsrc like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstsrc POSTHOOK: query: create table tstsrc like src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -26,6 +27,7 @@ POSTHOOK: Lineage: tstsrc.value SIMPLE [ PREHOOK: query: create table tstsrcpart like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstsrcpart POSTHOOK: query: create table tstsrcpart like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/transform1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/transform1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/transform1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/transform1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table transform1_t1(a string, b string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@transform1_t1 POSTHOOK: query: create table transform1_t1(a string, b string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -58,6 +59,7 @@ POSTHOOK: Input: default@transform1_t1 PREHOOK: query: create table transform1_t2(col array<int>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@transform1_t2 POSTHOOK: query: create table transform1_t2(col array<int>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ CREATE TABLE test_tab (key STRING, value ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_tab POSTHOOK: query: -- Tests truncating column(s) from a table, also tests that stats are updated CREATE TABLE test_tab (key STRING, value STRING) @@ -496,6 +497,7 @@ PREHOOK: query: -- Test truncating a par CREATE TABLE test_tab_part (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_tab_part POSTHOOK: query: -- Test truncating a partition CREATE TABLE test_tab_part (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_buckets.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_buckets.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_buckets.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_buckets.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- Tests truncating colu CREATE TABLE test_tab (key STRING, value STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_tab POSTHOOK: query: -- Tests truncating columns from a bucketed table, table should remain bucketed CREATE TABLE test_tab (key STRING, value STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS RCFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_merge.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_merge.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_merge.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/truncate_column_merge.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- Tests truncating a co CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_tab POSTHOOK: query: -- Tests truncating a column from a table with multiple files, then merging those files CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/truncate_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/truncate_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/truncate_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/truncate_table.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table src_truncate (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_truncate POSTHOOK: query: create table src_truncate (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@src_truncate PREHOOK: query: create table srcpart_truncate (key string, value string) partitioned by (ds string, hr string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@srcpart_truncate POSTHOOK: query: create table srcpart_truncate (key string, value string) partitioned by (ds string, hr string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_context_ngrams.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE kafka (contents STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@kafka POSTHOOK: query: CREATE TABLE kafka (contents STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_corr.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_corr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_corr.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_corr.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@covar_tab POSTHOOK: query: CREATE TABLE covar_tab (a INT, b INT, c INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_pop.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_pop.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_pop.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_pop.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@covar_tab POSTHOOK: query: CREATE TABLE covar_tab (a INT, b INT, c INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_samp.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_samp.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_samp.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_covar_samp.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@covar_tab POSTHOOK: query: CREATE TABLE covar_tab (a INT, b INT, c INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_ngrams.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_ngrams.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_ngrams.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_ngrams.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE kafka (contents STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@kafka POSTHOOK: query: CREATE TABLE kafka (contents STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: -- INCLUDE_HADOOP_MAJOR_ CREATE TABLE bucket (key double, value string) CLUSTERED BY (key) SORTED BY (key DESC) INTO 4 BUCKETS STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bucket POSTHOOK: query: -- INCLUDE_HADOOP_MAJOR_VERSIONS(0.23) -- 0.23 changed input order of data in reducer task, which affects result of percentile_approx @@ -46,6 +47,7 @@ POSTHOOK: Output: default@bucket PREHOOK: query: create table t1 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t1 POSTHOOK: query: create table t1 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -53,6 +55,7 @@ POSTHOOK: Output: default@t1 PREHOOK: query: create table t2 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t2 POSTHOOK: query: create table t2 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -60,6 +63,7 @@ POSTHOOK: Output: default@t2 PREHOOK: query: create table t3 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t3 POSTHOOK: query: create table t3 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -67,6 +71,7 @@ POSTHOOK: Output: default@t3 PREHOOK: query: create table t4 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t4 POSTHOOK: query: create table t4 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -74,6 +79,7 @@ POSTHOOK: Output: default@t4 PREHOOK: query: create table t5 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t5 POSTHOOK: query: create table t5 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -81,6 +87,7 @@ POSTHOOK: Output: default@t5 PREHOOK: query: create table t6 (result double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t6 POSTHOOK: query: create table t6 (result double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -88,6 +95,7 @@ POSTHOOK: Output: default@t6 PREHOOK: query: create table t7 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t7 POSTHOOK: query: create table t7 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -95,6 +103,7 @@ POSTHOOK: Output: default@t7 PREHOOK: query: create table t8 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t8 POSTHOOK: query: create table t8 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -102,6 +111,7 @@ POSTHOOK: Output: default@t8 PREHOOK: query: create table t9 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t9 POSTHOOK: query: create table t9 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -109,6 +119,7 @@ POSTHOOK: Output: default@t9 PREHOOK: query: create table t10 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t10 POSTHOOK: query: create table t10 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -116,6 +127,7 @@ POSTHOOK: Output: default@t10 PREHOOK: query: create table t11 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t11 POSTHOOK: query: create table t11 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -123,6 +135,7 @@ POSTHOOK: Output: default@t11 PREHOOK: query: create table t12 (result array<double>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t12 POSTHOOK: query: create table t12 (result array<double>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf1.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 ST c18 STRING, c19 STRING, c20 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING, c8 STRING, c9 STRING, c10 STRING, c11 STRING, c12 STRING, c13 STRING, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf4.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf5.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf6.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf7.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf8.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf8.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_10_trims.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_10_trims.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_10_trims.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_10_trims.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_and.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_and.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_and.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_and.q.out Fri Aug 22 21:36:47 2014 @@ -23,6 +23,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bitmap_test POSTHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_or.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_or.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_or.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_bitmap_or.q.out Fri Aug 22 21:36:47 2014 @@ -23,6 +23,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bitmap_test POSTHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_case.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_case.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_case.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_case.q.out Fri Aug 22 21:36:47 2014 @@ -2,12 +2,24 @@ PREHOOK: query: DESCRIBE FUNCTION case PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION case POSTHOOK: type: DESCFUNCTION -There is no documentation for function 'case' +CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END - When a = b, returns c; when a = d, return e; else return f PREHOOK: query: DESCRIBE FUNCTION EXTENDED case PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED case POSTHOOK: type: DESCFUNCTION -There is no documentation for function 'case' +CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END - When a = b, returns c; when a = d, return e; else return f +Example: + SELECT + CASE deptno + WHEN 1 THEN Engineering + WHEN 2 THEN Finance + ELSE admin + END, + CASE zone + WHEN 7 THEN Americas + ELSE Asia-Pac + END + FROM emp_details PREHOOK: query: EXPLAIN SELECT CASE 1 WHEN 1 THEN 2 @@ -196,4 +208,4 @@ FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -123 123.0 abcd +123.0 123.0 abcd Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_insert2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_ws.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_ws.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_ws.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_concat_ws.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ Example: PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_current_database.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_current_database.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_current_database.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_current_database.q.out Fri Aug 22 21:36:47 2014 @@ -50,12 +50,16 @@ POSTHOOK: Input: _dummy_database@_dummy_ default PREHOOK: query: create database xxx PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:xxx POSTHOOK: query: create database xxx POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:xxx PREHOOK: query: use xxx PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:xxx POSTHOOK: query: use xxx POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:xxx PREHOOK: query: explain select current_database() PREHOOK: type: QUERY @@ -103,8 +107,10 @@ POSTHOOK: Input: _dummy_database@_dummy_ xxx PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: explain select current_database() PREHOOK: type: QUERY @@ -140,8 +146,10 @@ POSTHOOK: Input: _dummy_database@_dummy_ default PREHOOK: query: use xxx PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:xxx POSTHOOK: query: use xxx POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:xxx PREHOOK: query: explain select current_database() PREHOOK: type: QUERY Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/udf_explode.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_field.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_field.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_field.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_field.q.out Fri Aug 22 21:36:47 2014 @@ -71,6 +71,7 @@ POSTHOOK: Input: default@src PREHOOK: query: CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_table POSTHOOK: query: CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -118,6 +119,7 @@ POSTHOOK: Input: default@test_table PREHOOK: query: CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_table1 POSTHOOK: query: CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_format_number.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_format_number.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_format_number.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_format_number.q.out Fri Aug 22 21:36:47 2014 @@ -1,7 +1,9 @@ PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: -- Test format_number() UDF DESCRIBE FUNCTION format_number Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_get_json_object.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_get_json_object.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_get_json_object.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_get_json_object.q.out Fri Aug 22 21:36:47 2014 @@ -26,6 +26,7 @@ Syntax not supported that's worth notici PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -154,6 +155,7 @@ PREHOOK: query: -- Verify that get_json_ CREATE TABLE dest2(c1 STRING) STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest2 POSTHOOK: query: -- Verify that get_json_object can handle new lines in JSON values CREATE TABLE dest2(c1 STRING) STORED AS RCFILE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_in_file.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_in_file.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_in_file.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_in_file.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ PREHOOK: query: CREATE TABLE value_src ( ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@value_src POSTHOOK: query: CREATE TABLE value_src (str_val char(3), ch_val STRING, vch_val varchar(10), str_val_neg char(3), ch_val_neg STRING, vch_val_neg varchar(10)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_length.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_length.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_length.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_length.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ Example: PREHOOK: query: CREATE TABLE dest1(len INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(len INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -158,6 +159,7 @@ PREHOOK: query: -- Test with non-ascii c CREATE TABLE dest1(name STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: -- Test with non-ascii characters. CREATE TABLE dest1(name STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_keys.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_keys.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_keys.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_keys.q.out Fri Aug 22 21:36:47 2014 @@ -1,7 +1,9 @@ PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: -- Test map_keys() UDF DESCRIBE FUNCTION map_keys Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_values.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_values.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_values.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_map_values.q.out Fri Aug 22 21:36:47 2014 @@ -1,7 +1,9 @@ PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: -- Test map_values() UDF DESCRIBE FUNCTION map_values Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_printf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_printf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_printf.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_printf.q.out Fri Aug 22 21:36:47 2014 @@ -1,7 +1,9 @@ PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: -- Test printf() UDF DESCRIBE FUNCTION printf @@ -79,6 +81,7 @@ PREHOOK: query: -- Test Timestamp create table timestamp_udf (t timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@timestamp_udf POSTHOOK: query: -- Test Timestamp create table timestamp_udf (t timestamp) POSTHOOK: type: CREATETABLE @@ -121,6 +124,7 @@ FIELDS TERMINATED BY '9' STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@binay_udf POSTHOOK: query: -- Test Binary CREATE TABLE binay_udf(key binary, value int) ROW FORMAT DELIMITED @@ -140,6 +144,7 @@ POSTHOOK: Output: default@binay_udf PREHOOK: query: create table dest1 (key binary, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: create table dest1 (key binary, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_reverse.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_reverse.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_reverse.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_reverse.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ Example: PREHOOK: query: CREATE TABLE dest1(len STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(len STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -160,6 +161,7 @@ PREHOOK: query: -- Test with non-ascii c CREATE TABLE dest1(name STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: -- Test with non-ascii characters -- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to -- 0xE993AEE982B5 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_round_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_round_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_round_2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_round_2.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- test for NaN (not-a-n create table tstTbl1(n double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstTbl1 POSTHOOK: query: -- test for NaN (not-a-number) create table tstTbl1(n double) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_sentences.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_sentences.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_sentences.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_sentences.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE sent_tmp (val array<string>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@sent_tmp POSTHOOK: query: CREATE TABLE sent_tmp (val array<string>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@sent_tmp PREHOOK: query: CREATE TABLE sent_tmp2 (val string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@sent_tmp2 POSTHOOK: query: CREATE TABLE sent_tmp2 (val string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -111,6 +113,7 @@ POSTHOOK: Output: default@sent_tmp2 PREHOOK: query: CREATE TABLE sent_tmp (val array<string>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@sent_tmp POSTHOOK: query: CREATE TABLE sent_tmp (val array<string>) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -118,6 +121,7 @@ POSTHOOK: Output: default@sent_tmp PREHOOK: query: CREATE TABLE sent_tmp2 (val string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@sent_tmp2 POSTHOOK: query: CREATE TABLE sent_tmp2 (val string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_sort_array.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_sort_array.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_sort_array.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_sort_array.q.out Fri Aug 22 21:36:47 2014 @@ -1,7 +1,9 @@ PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: -- Test sort_array() UDF DESCRIBE FUNCTION sort_array @@ -99,6 +101,7 @@ CREATE TABLE dest1 ( ) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: -- Test it against data in a table. CREATE TABLE dest1 ( tinyints ARRAY<TINYINT>, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ Converts the specified time to number of PREHOOK: query: create table oneline(key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@oneline POSTHOOK: query: create table oneline(key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_translate.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_translate.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_translate.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_translate.q.out Fri Aug 22 21:36:47 2014 @@ -24,6 +24,7 @@ PREHOOK: query: -- Create some tables to CREATE TABLE table_input(input STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@table_input POSTHOOK: query: -- Create some tables to serve some input data CREATE TABLE table_input(input STRING) POSTHOOK: type: CREATETABLE @@ -32,6 +33,7 @@ POSTHOOK: Output: default@table_input PREHOOK: query: CREATE TABLE table_translate(input_string STRING, from_string STRING, to_string STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@table_translate POSTHOOK: query: CREATE TABLE table_translate(input_string STRING, from_string STRING, to_string STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ Converts the current or specified time t PREHOOK: query: create table oneline(key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@oneline POSTHOOK: query: create table oneline(key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_using.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_using.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_using.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_using.q.out Fri Aug 22 21:36:47 2014 @@ -1,14 +1,15 @@ #### A masked pattern was here #### PREHOOK: type: CREATEFUNCTION PREHOOK: Output: database:default -PREHOOK: Output: lookup +PREHOOK: Output: default.lookup #### A masked pattern was here #### POSTHOOK: type: CREATEFUNCTION POSTHOOK: Output: database:default -POSTHOOK: Output: lookup +POSTHOOK: Output: default.lookup PREHOOK: query: create table udf_using (c1 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@udf_using POSTHOOK: query: create table udf_using (c1 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -43,9 +44,9 @@ POSTHOOK: Output: default@udf_using PREHOOK: query: drop function lookup PREHOOK: type: DROPFUNCTION PREHOOK: Output: database:default -PREHOOK: Output: lookup +PREHOOK: Output: default.lookup POSTHOOK: query: drop function lookup POSTHOOK: type: DROPFUNCTION POSTHOOK: Output: database:default -POSTHOOK: Output: lookup +POSTHOOK: Output: default.lookup #### A masked pattern was here #### Modified: hive/branches/cbo/ql/src/test/results/clientpositive/udf_when.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/udf_when.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/udf_when.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/udf_when.q.out Fri Aug 22 21:36:47 2014 @@ -2,12 +2,24 @@ PREHOOK: query: DESCRIBE FUNCTION when PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION when POSTHOOK: type: DESCFUNCTION -There is no documentation for function 'when' +CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END - When a = true, returns b; when c = true, return d; else return e PREHOOK: query: DESCRIBE FUNCTION EXTENDED when PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED when POSTHOOK: type: DESCFUNCTION -There is no documentation for function 'when' +CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END - When a = true, returns b; when c = true, return d; else return e +Example: + SELECT + CASE + WHEN deptno=1 THEN Engineering + WHEN deptno=2 THEN Finance + ELSE admin + END, + CASE + WHEN zone=7 THEN Americas + ELSE Asia-Pac + END + FROM emp_details PREHOOK: query: EXPLAIN SELECT CASE WHEN 1=1 THEN 2 @@ -179,4 +191,4 @@ FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -123 123.0 abcd +123.0 123.0 abcd