You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2015/03/11 22:50:24 UTC
svn commit: r1666021 [3/7] - in /hive/branches/cbo: ./
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/queries/clientnegative/
contrib/src/test/queries/clientpositive/
contrib/src/test/results/clientnegative/ contrib/src/test/results/clie...
Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/vectorized_dynamic_partition_pruning.q
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/vectorized_dynamic_partition_pruning.q?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/queries/clientpositive/vectorized_dynamic_partition_pruning.q (original)
+++ hive/branches/cbo/ql/src/test/queries/clientpositive/vectorized_dynamic_partition_pruning.q Wed Mar 11 21:50:22 2015
@@ -9,49 +9,49 @@ set hive.vectorized.execution.enabled=tr
select distinct ds from srcpart;
select distinct hr from srcpart;
-EXPLAIN create table srcpart_date as select ds as ds, ds as date from srcpart group by ds;
-create table srcpart_date stored as orc as select ds as ds, ds as date from srcpart group by ds;
+EXPLAIN create table srcpart_date as select ds as ds, ds as `date` from srcpart group by ds;
+create table srcpart_date stored as orc as select ds as ds, ds as `date` from srcpart group by ds;
create table srcpart_hour stored as orc as select hr as hr, hr as hour from srcpart group by hr;
-create table srcpart_date_hour stored as orc as select ds as ds, ds as date, hr as hr, hr as hour from srcpart group by ds, hr;
+create table srcpart_date_hour stored as orc as select ds as ds, ds as `date`, hr as hr, hr as hour from srcpart group by ds, hr;
create table srcpart_double_hour stored as orc as select (hr*2) as hr, hr as hour from srcpart group by hr;
-- single column, single key
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
-select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
+select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
set hive.tez.dynamic.partition.pruning=false;
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
-select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
+select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
set hive.tez.dynamic.partition.pruning=true;
select count(*) from srcpart where ds = '2008-04-08';
-- multiple sources, single key
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
set hive.tez.dynamic.partition.pruning=false;
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
set hive.tez.dynamic.partition.pruning=true;
select count(*) from srcpart where hr = 11 and ds = '2008-04-08';
-- multiple columns single source
-EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
-select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
+EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
+select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
set hive.tez.dynamic.partition.pruning=false;
-EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
-select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
+EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
+select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
set hive.tez.dynamic.partition.pruning=true;
select count(*) from srcpart where ds = '2008-04-08' and hr = 11;
-- empty set
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
-select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
+select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
set hive.tez.dynamic.partition.pruning=false;
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
-select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
+select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
set hive.tez.dynamic.partition.pruning=true;
select count(*) from srcpart where ds = 'I DONT EXIST';
@@ -74,34 +74,34 @@ select count(*) from srcpart where cast(
-- parent is reduce tasks
-EXPLAIN select count(*) from srcpart join (select ds as ds, ds as date from srcpart group by ds) s on (srcpart.ds = s.ds) where s.date = '2008-04-08';
-select count(*) from srcpart join (select ds as ds, ds as date from srcpart group by ds) s on (srcpart.ds = s.ds) where s.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart join (select ds as ds, ds as `date` from srcpart group by ds) s on (srcpart.ds = s.ds) where s.`date` = '2008-04-08';
+select count(*) from srcpart join (select ds as ds, ds as `date` from srcpart group by ds) s on (srcpart.ds = s.ds) where s.`date` = '2008-04-08';
select count(*) from srcpart where ds = '2008-04-08';
-- non-equi join
-EXPLAIN select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr);
-select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr);
+EXPLAIN select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr);
+select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr);
-- old style join syntax
-EXPLAIN select count(*) from srcpart, srcpart_date_hour where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11 and srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr;
-select count(*) from srcpart, srcpart_date_hour where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11 and srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr;
+EXPLAIN select count(*) from srcpart, srcpart_date_hour where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11 and srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr;
+select count(*) from srcpart, srcpart_date_hour where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11 and srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr;
-- left join
-EXPLAIN select count(*) from srcpart left join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
-EXPLAIN select count(*) from srcpart_date left join srcpart on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart left join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
+EXPLAIN select count(*) from srcpart_date left join srcpart on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
-- full outer
-EXPLAIN select count(*) from srcpart full outer join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart full outer join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
-- with static pruning
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart.hr = 13;
+where srcpart_date.`date` = '2008-04-08' and srcpart.hr = 13;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart.hr = 13;
+where srcpart_date.`date` = '2008-04-08' and srcpart.hr = 13;
-- union + subquery
EXPLAIN select count(*) from srcpart where srcpart.ds in (select max(srcpart.ds) from srcpart union all select min(srcpart.ds) from srcpart);
@@ -116,26 +116,26 @@ set hive.auto.convert.join.noconditional
set hive.auto.convert.join.noconditionaltask.size = 10000000;
-- single column, single key
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
-select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
+select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
select count(*) from srcpart where ds = '2008-04-08';
-- multiple sources, single key
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11;
select count(*) from srcpart where hr = 11 and ds = '2008-04-08';
-- multiple columns single source
-EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
-select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11;
+EXPLAIN select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
+select count(*) from srcpart join srcpart_date_hour on (srcpart.ds = srcpart_date_hour.ds and srcpart.hr = srcpart_date_hour.hr) where srcpart_date_hour.`date` = '2008-04-08' and srcpart_date_hour.hour = 11;
select count(*) from srcpart where ds = '2008-04-08' and hr = 11;
-- empty set
-EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
+EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
-- Disabled until TEZ-1486 is fixed
--- select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = 'I DONT EXIST';
+-- select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = 'I DONT EXIST';
-- expressions
EXPLAIN select count(*) from srcpart join srcpart_double_hour on (srcpart.hr = cast(srcpart_double_hour.hr/2 as int)) where srcpart_double_hour.hour = 11;
@@ -145,27 +145,27 @@ select count(*) from srcpart join srcpar
select count(*) from srcpart where hr = 11;
-- parent is reduce tasks
-EXPLAIN select count(*) from srcpart join (select ds as ds, ds as date from srcpart group by ds) s on (srcpart.ds = s.ds) where s.date = '2008-04-08';
-select count(*) from srcpart join (select ds as ds, ds as date from srcpart group by ds) s on (srcpart.ds = s.ds) where s.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart join (select ds as ds, ds as `date` from srcpart group by ds) s on (srcpart.ds = s.ds) where s.`date` = '2008-04-08';
+select count(*) from srcpart join (select ds as ds, ds as `date` from srcpart group by ds) s on (srcpart.ds = s.ds) where s.`date` = '2008-04-08';
select count(*) from srcpart where ds = '2008-04-08';
-- left join
-EXPLAIN select count(*) from srcpart left join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
-EXPLAIN select count(*) from srcpart_date left join srcpart on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart left join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
+EXPLAIN select count(*) from srcpart_date left join srcpart on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
-- full outer
-EXPLAIN select count(*) from srcpart full outer join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.date = '2008-04-08';
+EXPLAIN select count(*) from srcpart full outer join srcpart_date on (srcpart.ds = srcpart_date.ds) where srcpart_date.`date` = '2008-04-08';
-- with static pruning
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
+where srcpart_date.`date` = '2008-04-08' and srcpart_hour.hour = 11 and srcpart.hr = 11;
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
-where srcpart_date.date = '2008-04-08' and srcpart.hr = 13;
+where srcpart_date.`date` = '2008-04-08' and srcpart.hr = 13;
-- Disabled until TEZ-1486 is fixed
-- select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr)
--- where srcpart_date.date = '2008-04-08' and srcpart.hr = 13;
+-- where srcpart_date.`date` = '2008-04-08' and srcpart.hr = 13;
-- union + subquery
EXPLAIN select distinct(ds) from srcpart where srcpart.ds in (select max(srcpart.ds) from srcpart union all select min(srcpart.ds) from srcpart);
@@ -181,8 +181,8 @@ set hive.vectorized.execution.enabled=fa
set hive.exec.max.dynamic.partitions=1000;
insert into table srcpart_orc partition (ds, hr) select key, value, ds, hr from srcpart;
-EXPLAIN select count(*) from srcpart_orc join srcpart_date_hour on (srcpart_orc.ds = srcpart_date_hour.ds and srcpart_orc.hr = srcpart_date_hour.hr) where srcpart_date_hour.hour = 11 and (srcpart_date_hour.date = '2008-04-08' or srcpart_date_hour.date = '2008-04-09');
-select count(*) from srcpart_orc join srcpart_date_hour on (srcpart_orc.ds = srcpart_date_hour.ds and srcpart_orc.hr = srcpart_date_hour.hr) where srcpart_date_hour.hour = 11 and (srcpart_date_hour.date = '2008-04-08' or srcpart_date_hour.date = '2008-04-09');
+EXPLAIN select count(*) from srcpart_orc join srcpart_date_hour on (srcpart_orc.ds = srcpart_date_hour.ds and srcpart_orc.hr = srcpart_date_hour.hr) where srcpart_date_hour.hour = 11 and (srcpart_date_hour.`date` = '2008-04-08' or srcpart_date_hour.`date` = '2008-04-09');
+select count(*) from srcpart_orc join srcpart_date_hour on (srcpart_orc.ds = srcpart_date_hour.ds and srcpart_orc.hr = srcpart_date_hour.hr) where srcpart_date_hour.hour = 11 and (srcpart_date_hour.`date` = '2008-04-08' or srcpart_date_hour.`date` = '2008-04-09');
select count(*) from srcpart where (ds = '2008-04-08' or ds = '2008-04-09') and hr = 11;
drop table srcpart_orc;
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_all_role.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_all_role.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_all_role.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_all_role.q.out Wed Mar 11 21:50:22 2015
@@ -2,6 +2,4 @@ PREHOOK: query: set role ADMIN
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: set role ADMIN
POSTHOOK: type: SHOW_ROLES
-PREHOOK: query: create role all
-PREHOOK: type: CREATEROLE
-FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Role name cannot be one of the reserved roles: [ALL, DEFAULT, NONE]
+FAILED: ParseException line 2:12 Failed to recognize predicate 'all'. Failed rule: 'identifier' in create role
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_none_role.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_none_role.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_none_role.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_cannot_create_none_role.q.out Wed Mar 11 21:50:22 2015
@@ -2,6 +2,4 @@ PREHOOK: query: set role ADMIN
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: set role ADMIN
POSTHOOK: type: SHOW_ROLES
-PREHOOK: query: create role None
-PREHOOK: type: CREATEROLE
-FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Role name cannot be one of the reserved roles: [ALL, DEFAULT, NONE]
+FAILED: ParseException line 2:12 Failed to recognize predicate 'None'. Failed rule: 'identifier' in create role
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/lateral_view_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/lateral_view_join.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/lateral_view_join.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/lateral_view_join.q.out Wed Mar 11 21:50:22 2015
@@ -1 +1 @@
-FAILED: ParseException line 1:62 missing EOF at 'myTable' near 'AS'
+FAILED: ParseException line 1:59 Failed to recognize predicate 'AS'. Failed rule: 'identifier' in table alias
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/select_charliteral.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/select_charliteral.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/select_charliteral.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/select_charliteral.q.out Wed Mar 11 21:50:22 2015
@@ -1,2 +1 @@
-FAILED: ParseException line 3:11 missing \' at ',' near '_c17' in character string literal
-line 4:0 mismatched input '<EOF>' expecting \' near '_c17' in character string literal
+FAILED: ParseException line 3:7 cannot recognize input near '_c17' ',' 'count' in expression specification
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex.q.out Wed Mar 11 21:50:22 2015
@@ -8,7 +8,7 @@ PREHOOK: query: -- This should fail bec
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time TIMESTAMP,
request STRING,
status INT,
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex2.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex2.q.out Wed Mar 11 21:50:22 2015
@@ -8,7 +8,7 @@ PREHOOK: query: -- Mismatch between the
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
@@ -27,7 +27,7 @@ POSTHOOK: query: -- Mismatch between the
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
Modified: hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex3.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/serde_regex3.q.out Wed Mar 11 21:50:22 2015
@@ -8,7 +8,7 @@ PREHOOK: query: -- null input.regex, rai
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/array_map_access_nonconstant.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/array_map_access_nonconstant.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/array_map_access_nonconstant.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/array_map_access_nonconstant.q.out Wed Mar 11 21:50:22 2015
@@ -1,8 +1,8 @@
-PREHOOK: query: create table array_table (array array<string>, index int )
+PREHOOK: query: create table array_table (`array` array<string>, index int )
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@array_table
-POSTHOOK: query: create table array_table (array array<string>, index int )
+POSTHOOK: query: create table array_table (`array` array<string>, index int )
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@array_table
@@ -17,10 +17,10 @@ POSTHOOK: Output: default@array_table
POSTHOOK: Lineage: array_table.array EXPRESSION []
POSTHOOK: Lineage: array_table.index EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: explain
-select index, array[index] from array_table
+select index, `array`[index] from array_table
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select index, array[index] from array_table
+select index, `array`[index] from array_table
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -39,11 +39,11 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 80 Basic stats: COMPLETE Column stats: NONE
ListSink
-PREHOOK: query: select index, array[index] from array_table
+PREHOOK: query: select index, `array`[index] from array_table
PREHOOK: type: QUERY
PREHOOK: Input: default@array_table
#### A masked pattern was here ####
-POSTHOOK: query: select index, array[index] from array_table
+POSTHOOK: query: select index, `array`[index] from array_table
POSTHOOK: type: QUERY
POSTHOOK: Input: default@array_table
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/decimal_10_0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/decimal_10_0.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/decimal_10_0.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/decimal_10_0.q.out Wed Mar 11 21:50:22 2015
@@ -1,38 +1,38 @@
-PREHOOK: query: DROP TABLE IF EXISTS DECIMAL
+PREHOOK: query: DROP TABLE IF EXISTS `DECIMAL`
PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL
+POSTHOOK: query: DROP TABLE IF EXISTS `DECIMAL`
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE DECIMAL (dec decimal)
+PREHOOK: query: CREATE TABLE `DECIMAL` (dec decimal)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@DECIMAL
-POSTHOOK: query: CREATE TABLE DECIMAL (dec decimal)
+POSTHOOK: query: CREATE TABLE `DECIMAL` (dec decimal)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/decimal_10_0.txt' OVERWRITE INTO TABLE DECIMAL
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/decimal_10_0.txt' OVERWRITE INTO TABLE `DECIMAL`
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@decimal
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/decimal_10_0.txt' OVERWRITE INTO TABLE DECIMAL
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/decimal_10_0.txt' OVERWRITE INTO TABLE `DECIMAL`
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@decimal
-PREHOOK: query: SELECT dec FROM DECIMAL
+PREHOOK: query: SELECT dec FROM `DECIMAL`
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dec FROM DECIMAL
+POSTHOOK: query: SELECT dec FROM `DECIMAL`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal
#### A masked pattern was here ####
1000000000
NULL
-PREHOOK: query: DROP TABLE DECIMAL
+PREHOOK: query: DROP TABLE `DECIMAL`
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal
PREHOOK: Output: default@decimal
-POSTHOOK: query: DROP TABLE DECIMAL
+POSTHOOK: query: DROP TABLE `DECIMAL`
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal
POSTHOOK: Output: default@decimal
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/innerjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/innerjoin.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/innerjoin.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/innerjoin.q.out Wed Mar 11 21:50:22 2015
@@ -1142,44 +1142,46 @@ POSTHOOK: Input: default@dest_j1
98 val_98
98 val_98
PREHOOK: query: -- verify that INNER is a non-reserved word for backwards compatibility
-create table inner(i int)
+-- change from HIVE-6617, inner is a SQL2011 reserved keyword.
+create table `inner`(i int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@inner
POSTHOOK: query: -- verify that INNER is a non-reserved word for backwards compatibility
-create table inner(i int)
+-- change from HIVE-6617, inner is a SQL2011 reserved keyword.
+create table `inner`(i int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inner
-PREHOOK: query: select i from inner
+PREHOOK: query: select i from `inner`
PREHOOK: type: QUERY
PREHOOK: Input: default@inner
#### A masked pattern was here ####
-POSTHOOK: query: select i from inner
+POSTHOOK: query: select i from `inner`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inner
#### A masked pattern was here ####
-PREHOOK: query: create table i(inner int)
+PREHOOK: query: create table i(`inner` int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@i
-POSTHOOK: query: create table i(inner int)
+POSTHOOK: query: create table i(`inner` int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@i
-PREHOOK: query: select inner from i
+PREHOOK: query: select `inner` from i
PREHOOK: type: QUERY
PREHOOK: Input: default@i
#### A masked pattern was here ####
-POSTHOOK: query: select inner from i
+POSTHOOK: query: select `inner` from i
POSTHOOK: type: QUERY
POSTHOOK: Input: default@i
#### A masked pattern was here ####
-PREHOOK: query: explain select * from (select * from src) inner left outer join src
-on inner.key=src.key
+PREHOOK: query: explain select * from (select * from src) `inner` left outer join src
+on `inner`.key=src.key
PREHOOK: type: QUERY
-POSTHOOK: query: explain select * from (select * from src) inner left outer join src
-on inner.key=src.key
+POSTHOOK: query: explain select * from (select * from src) `inner` left outer join src
+on `inner`.key=src.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/keyword_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/keyword_1.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/keyword_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/keyword_1.q.out Wed Mar 11 21:50:22 2015
@@ -1,12 +1,12 @@
PREHOOK: query: -- SORT_BEFORE_DIFF
-create table test_user (user string, `group` string)
+create table test_user (`user` string, `group` string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_user
POSTHOOK: query: -- SORT_BEFORE_DIFF
-create table test_user (user string, `group` string)
+create table test_user (`user` string, `group` string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_user
@@ -16,9 +16,9 @@ PREHOOK: Output: default@test_user
POSTHOOK: query: grant select on table test_user to user hive_test
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@test_user
-PREHOOK: query: explain select user from test_user
+PREHOOK: query: explain select `user` from test_user
PREHOOK: type: QUERY
-POSTHOOK: query: explain select user from test_user
+POSTHOOK: query: explain select `user` from test_user
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out Wed Mar 11 21:50:22 2015
@@ -1,38 +1,38 @@
-PREHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE
+PREHOOK: query: CREATE TABLE `table`(`string` string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table
-POSTHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE
+POSTHOOK: query: CREATE TABLE `table`(`string` string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@table
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/docurl.txt' INTO TABLE table
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/docurl.txt' INTO TABLE `table`
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@table
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/docurl.txt' INTO TABLE table
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/docurl.txt' INTO TABLE `table`
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@table
-PREHOOK: query: SELECT table, count(1)
+PREHOOK: query: SELECT `table`, count(1)
FROM
(
- FROM table
- SELECT TRANSFORM (table.string)
+ FROM `table`
+ SELECT TRANSFORM (`table`.`string`)
#### A masked pattern was here ####
) subq
-GROUP BY table
+GROUP BY `table`
PREHOOK: type: QUERY
PREHOOK: Input: default@table
#### A masked pattern was here ####
-POSTHOOK: query: SELECT table, count(1)
+POSTHOOK: query: SELECT `table`, count(1)
FROM
(
- FROM table
- SELECT TRANSFORM (table.string)
+ FROM `table`
+ SELECT TRANSFORM (`table`.`string`)
#### A masked pattern was here ####
) subq
-GROUP BY table
+GROUP BY `table`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out Wed Mar 11 21:50:22 2015
@@ -1,18 +1,18 @@
-PREHOOK: query: DROP TABLE insert
+PREHOOK: query: DROP TABLE `insert`
PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE insert
+POSTHOOK: query: DROP TABLE `insert`
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE insert (key INT, as STRING)
+PREHOOK: query: CREATE TABLE `insert` (key INT, `as` STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@insert
-POSTHOOK: query: CREATE TABLE insert (key INT, as STRING)
+POSTHOOK: query: CREATE TABLE `insert` (key INT, `as` STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@insert
-PREHOOK: query: EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+PREHOOK: query: EXPLAIN INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+POSTHOOK: query: EXPLAIN INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -71,32 +71,32 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+PREHOOK: query: INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@insert
-POSTHOOK: query: INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+POSTHOOK: query: INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@insert
POSTHOOK: Lineage: insert.as SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT SUM(HASH(hash)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (hash) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (hash) FROM `insert`
) t
PREHOOK: type: QUERY
PREHOOK: Input: default@insert
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(HASH(hash)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (hash) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (hash) FROM `insert`
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@insert
#### A masked pattern was here ####
10226524244
-PREHOOK: query: EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+PREHOOK: query: EXPLAIN INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+POSTHOOK: query: EXPLAIN INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -155,41 +155,41 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+PREHOOK: query: INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@insert
-POSTHOOK: query: INSERT INTO TABLE insert SELECT * FROM src LIMIT 100
+POSTHOOK: query: INSERT INTO TABLE `insert` SELECT * FROM src LIMIT 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@insert
POSTHOOK: Lineage: insert.as SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT SUM(HASH(sum)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (sum) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (sum) FROM `insert`
) t
PREHOOK: type: QUERY
PREHOOK: Input: default@insert
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(HASH(sum)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (sum) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (sum) FROM `insert`
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@insert
#### A masked pattern was here ####
20453048488
-PREHOOK: query: SELECT COUNT(*) FROM insert
+PREHOOK: query: SELECT COUNT(*) FROM `insert`
PREHOOK: type: QUERY
PREHOOK: Input: default@insert
#### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(*) FROM insert
+POSTHOOK: query: SELECT COUNT(*) FROM `insert`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@insert
#### A masked pattern was here ####
200
-PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10
+PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE `insert` SELECT * FROM src LIMIT 10
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10
+POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE `insert` SELECT * FROM src LIMIT 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -248,34 +248,34 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10
+PREHOOK: query: INSERT OVERWRITE TABLE `insert` SELECT * FROM src LIMIT 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@insert
-POSTHOOK: query: INSERT OVERWRITE TABLE insert SELECT * FROM src LIMIT 10
+POSTHOOK: query: INSERT OVERWRITE TABLE `insert` SELECT * FROM src LIMIT 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@insert
POSTHOOK: Lineage: insert.as SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: insert.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT SUM(HASH(add)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (add) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (add) FROM `insert`
) t
PREHOOK: type: QUERY
PREHOOK: Input: default@insert
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(HASH(add)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (add) FROM insert
+ SELECT TRANSFORM(*) USING 'tr \t _' AS (add) FROM `insert`
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@insert
#### A masked pattern was here ####
-826625916
-PREHOOK: query: DROP TABLE insert
+PREHOOK: query: DROP TABLE `insert`
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@insert
PREHOOK: Output: default@insert
-POSTHOOK: query: DROP TABLE insert
+POSTHOOK: query: DROP TABLE `insert`
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@insert
POSTHOOK: Output: default@insert
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out Wed Mar 11 21:50:22 2015
@@ -10,11 +10,11 @@ POSTHOOK: query: -- HIVE-5199, HIVE-5285
DROP TABLE PW17
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW17(USER STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
+PREHOOK: query: CREATE TABLE PW17(`USER` STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW17
-POSTHOOK: query: CREATE TABLE PW17(USER STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
+POSTHOOK: query: CREATE TABLE PW17(`USER` STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW17
@@ -66,11 +66,11 @@ PREHOOK: type: DROPTABLE
POSTHOOK: query: -- Test for non-parititioned table.
DROP TABLE PW17_2
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW17_2(USER STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
+PREHOOK: query: CREATE TABLE PW17_2(`USER` STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW17_2
-POSTHOOK: query: CREATE TABLE PW17_2(USER STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
+POSTHOOK: query: CREATE TABLE PW17_2(`USER` STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW17_2
@@ -97,11 +97,11 @@ PREHOOK: query: DROP TABLE PW17_3
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE PW17_3
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW17_3(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
+PREHOOK: query: CREATE TABLE PW17_3(`USER` STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW17_3
-POSTHOOK: query: CREATE TABLE PW17_3(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
+POSTHOOK: query: CREATE TABLE PW17_3(`USER` STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW17_3
@@ -151,11 +151,11 @@ PREHOOK: query: DROP TABLE PW17_4
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE PW17_4
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW17_4(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
+PREHOOK: query: CREATE TABLE PW17_4(`USER` STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW17_4
-POSTHOOK: query: CREATE TABLE PW17_4(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
+POSTHOOK: query: CREATE TABLE PW17_4(`USER` STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW17_4
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out Wed Mar 11 21:50:22 2015
@@ -12,11 +12,11 @@ POSTHOOK: query: -- HIVE-5202 : Tests fo
DROP TABLE PW18
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW18(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
+PREHOOK: query: CREATE TABLE PW18(`USER` STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW18
-POSTHOOK: query: CREATE TABLE PW18(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
+POSTHOOK: query: CREATE TABLE PW18(`USER` STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW18
@@ -60,11 +60,11 @@ PREHOOK: type: DROPTABLE
POSTHOOK: query: -- Test for non-parititioned table.
DROP TABLE PW18_2
POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE PW18_2(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
+PREHOOK: query: CREATE TABLE PW18_2(`USER` STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@PW18_2
-POSTHOOK: query: CREATE TABLE PW18_2(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
+POSTHOOK: query: CREATE TABLE PW18_2(`USER` STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@PW18_2
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out Wed Mar 11 21:50:22 2015
@@ -1,9 +1,11 @@
-PREHOOK: query: -- ppd leaves invalid expr in field expr
+PREHOOK: query: -- We need the above setting for backward compatibility because 'user' is a keyword in SQL2011
+-- ppd leaves invalid expr in field expr
CREATE TABLE test_issue (fileid int, infos ARRAY<STRUCT<user:INT>>, test_c STRUCT<user_c:STRUCT<age:INT>>)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_issue
-POSTHOOK: query: -- ppd leaves invalid expr in field expr
+POSTHOOK: query: -- We need the above setting for backward compatibility because 'user' is a keyword in SQL2011
+-- ppd leaves invalid expr in field expr
CREATE TABLE test_issue (fileid int, infos ARRAY<STRUCT<user:INT>>, test_c STRUCT<user_c:STRUCT<age:INT>>)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/serde_regex.q.out Wed Mar 11 21:50:22 2015
@@ -2,7 +2,7 @@ PREHOOK: query: EXPLAIN
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
@@ -19,7 +19,7 @@ POSTHOOK: query: EXPLAIN
CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
@@ -50,7 +50,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
@@ -68,7 +68,7 @@ PREHOOK: Output: default@serde_regex
POSTHOOK: query: CREATE TABLE serde_regex(
host STRING,
identity STRING,
- user STRING,
+ `user` STRING,
time STRING,
request STRING,
status STRING,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out Wed Mar 11 21:50:22 2015
@@ -1218,3 +1218,78 @@ STAGE PLANS:
Processor Tree:
ListSink
+PREHOOK: query: explain
+select a.key, a.value, b.value
+from tab a join tab_part b on a.key = b.key and a.ds = b.ds
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select a.key, a.value, b.value
+from tab a join tab_part b on a.key = b.key and a.ds = b.ds
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-2 is a root stage
+ Stage-1 depends on stages: Stage-2
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-2
+ Spark
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 121 Data size: 1283 Basic stats: COMPLETE Column stats: NONE
+ Spark HashTable Sink Operator
+ keys:
+ 0 key (type: int), ds (type: string)
+ 1 key (type: int), ds (type: string)
+ Local Work:
+ Map Reduce Local Work
+
+ Stage: Stage-1
+ Spark
+#### A masked pattern was here ####
+ Vertices:
+ Map 2
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ keys:
+ 0 key (type: int), ds (type: string)
+ 1 key (type: int), ds (type: string)
+ outputColumnNames: _col0, _col1, _col7
+ input vertices:
+ 0 Map 1
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Local Work:
+ Map Reduce Local Work
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/innerjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/innerjoin.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/innerjoin.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/innerjoin.q.out Wed Mar 11 21:50:22 2015
@@ -1142,44 +1142,46 @@ POSTHOOK: Input: default@dest_j1
98 val_98
98 val_98
PREHOOK: query: -- verify that INNER is a non-reserved word for backwards compatibility
-create table inner(i int)
+-- change from HIVE-6617, inner is a SQL2011 reserved keyword.
+create table `inner`(i int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@inner
POSTHOOK: query: -- verify that INNER is a non-reserved word for backwards compatibility
-create table inner(i int)
+-- change from HIVE-6617, inner is a SQL2011 reserved keyword.
+create table `inner`(i int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inner
-PREHOOK: query: select i from inner
+PREHOOK: query: select i from `inner`
PREHOOK: type: QUERY
PREHOOK: Input: default@inner
#### A masked pattern was here ####
-POSTHOOK: query: select i from inner
+POSTHOOK: query: select i from `inner`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inner
#### A masked pattern was here ####
-PREHOOK: query: create table i(inner int)
+PREHOOK: query: create table i(`inner` int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@i
-POSTHOOK: query: create table i(inner int)
+POSTHOOK: query: create table i(`inner` int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@i
-PREHOOK: query: select inner from i
+PREHOOK: query: select `inner` from i
PREHOOK: type: QUERY
PREHOOK: Input: default@i
#### A masked pattern was here ####
-POSTHOOK: query: select inner from i
+POSTHOOK: query: select `inner` from i
POSTHOOK: type: QUERY
POSTHOOK: Input: default@i
#### A masked pattern was here ####
-PREHOOK: query: explain select * from (select * from src) inner left outer join src
-on inner.key=src.key
+PREHOOK: query: explain select * from (select * from src) `inner` left outer join src
+on `inner`.key=src.key
PREHOOK: type: QUERY
-POSTHOOK: query: explain select * from (select * from src) inner left outer join src
-on inner.key=src.key
+POSTHOOK: query: explain select * from (select * from src) `inner` left outer join src
+on `inner`.key=src.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_1.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_1.q.out Wed Mar 11 21:50:22 2015
@@ -26,11 +26,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -46,18 +46,18 @@ PREHOOK: query: explain
insert overwrite table outputTbl1
SELECT *
FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
) a
PREHOOK: type: QUERY
POSTHOOK: query: explain
insert overwrite table outputTbl1
SELECT *
FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -156,9 +156,9 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1
SELECT *
FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
) a
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
@@ -166,9 +166,9 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1
SELECT *
FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
@@ -211,11 +211,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from outputTbl1 order by key, values
+PREHOOK: query: select * from outputTbl1 order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 order by key, values
+POSTHOOK: query: select * from outputTbl1 order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_10.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_10.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_10.q.out Wed Mar 11 21:50:22 2015
@@ -34,11 +34,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -54,12 +54,12 @@ PREHOOK: query: explain
insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
) a
)b
PREHOOK: type: QUERY
@@ -67,12 +67,12 @@ POSTHOOK: query: explain
insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
) a
)b
POSTHOOK: type: QUERY
@@ -206,12 +206,12 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
) a
)b
PREHOOK: type: QUERY
@@ -220,12 +220,12 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, count(1) as values from inputTbl1 group by key
+ SELECT key, count(1) as `values` from inputTbl1 group by key
UNION ALL
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
) a
)b
POSTHOOK: type: QUERY
@@ -269,11 +269,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from outputTbl1 order by key, values
+PREHOOK: query: select * from outputTbl1 order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 order by key, values
+POSTHOOK: query: select * from outputTbl1 order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_11.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_11.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_11.q.out Wed Mar 11 21:50:22 2015
@@ -34,11 +34,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -54,12 +54,12 @@ PREHOOK: query: explain
insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, 2 values from inputTbl1
+ SELECT key, 2 `values` from inputTbl1
UNION ALL
- SELECT key, 3 as values from inputTbl1
+ SELECT key, 3 as `values` from inputTbl1
) a
)b
PREHOOK: type: QUERY
@@ -67,12 +67,12 @@ POSTHOOK: query: explain
insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, 2 values from inputTbl1
+ SELECT key, 2 `values` from inputTbl1
UNION ALL
- SELECT key, 3 as values from inputTbl1
+ SELECT key, 3 as `values` from inputTbl1
) a
)b
POSTHOOK: type: QUERY
@@ -192,12 +192,12 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
UNION ALL
- SELECT key, 3 as values from inputTbl1
+ SELECT key, 3 as `values` from inputTbl1
) a
)b
PREHOOK: type: QUERY
@@ -206,12 +206,12 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1
SELECT * FROM
(
-select key, 1 as values from inputTbl1
+select key, 1 as `values` from inputTbl1
union all
select * FROM (
- SELECT key, 2 as values from inputTbl1
+ SELECT key, 2 as `values` from inputTbl1
UNION ALL
- SELECT key, 3 as values from inputTbl1
+ SELECT key, 3 as `values` from inputTbl1
) a
)b
POSTHOOK: type: QUERY
@@ -255,11 +255,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: select * from outputTbl1 order by key, values
+PREHOOK: query: select * from outputTbl1 order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 order by key, values
+POSTHOOK: query: select * from outputTbl1 order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_15.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_15.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_15.q.out Wed Mar 11 21:50:22 2015
@@ -32,11 +32,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -52,18 +52,18 @@ PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
PREHOOK: type: QUERY
POSTHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -170,9 +170,9 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
@@ -180,9 +180,9 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
@@ -236,12 +236,12 @@ POSTHOOK: type: SHOWPARTITIONS
POSTHOOK: Input: default@outputtbl1
ds=1
ds=2
-PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=1
@@ -251,12 +251,12 @@ POSTHOOK: Input: default@outputtbl1@ds=1
3 1 1
7 1 1
8 2 1
-PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=2
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=2
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_16.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_16.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_16.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_16.q.out Wed Mar 11 21:50:22 2015
@@ -30,11 +30,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -50,18 +50,18 @@ PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
PREHOOK: type: QUERY
POSTHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -210,9 +210,9 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
@@ -220,9 +220,9 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, '1' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '1' as ds from inputTbl1 group by key
UNION ALL
- SELECT key, count(1) as values, '2' as ds from inputTbl1 group by key
+ SELECT key, count(1) as `values`, '2' as ds from inputTbl1 group by key
) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
@@ -276,12 +276,12 @@ POSTHOOK: type: SHOWPARTITIONS
POSTHOOK: Input: default@outputtbl1
ds=1
ds=2
-PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=1
@@ -291,12 +291,12 @@ POSTHOOK: Input: default@outputtbl1@ds=1
3 1 1
7 1 1
8 2 1
-PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=2
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=2
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_17.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_17.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_17.q.out Wed Mar 11 21:50:22 2015
@@ -26,11 +26,11 @@ create table inputTbl1(key string, val s
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -46,18 +46,18 @@ PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, 1 as values, '1' as ds from inputTbl1
+ SELECT key, 1 as `values`, '1' as ds from inputTbl1
UNION ALL
- SELECT key, 2 as values, '2' as ds from inputTbl1
+ SELECT key, 2 as `values`, '2' as ds from inputTbl1
) a
PREHOOK: type: QUERY
POSTHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, 1 as values, '1' as ds from inputTbl1
+ SELECT key, 1 as `values`, '1' as ds from inputTbl1
UNION ALL
- SELECT key, 2 as values, '2' as ds from inputTbl1
+ SELECT key, 2 as `values`, '2' as ds from inputTbl1
) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -119,9 +119,9 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, 1 as values, '1' as ds from inputTbl1
+ SELECT key, 1 as `values`, '1' as ds from inputTbl1
UNION ALL
- SELECT key, 2 as values, '2' as ds from inputTbl1
+ SELECT key, 2 as `values`, '2' as ds from inputTbl1
) a
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
@@ -129,9 +129,9 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, 1 as values, '1' as ds from inputTbl1
+ SELECT key, 1 as `values`, '1' as ds from inputTbl1
UNION ALL
- SELECT key, 2 as values, '2' as ds from inputTbl1
+ SELECT key, 2 as `values`, '2' as ds from inputTbl1
) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
@@ -185,12 +185,12 @@ POSTHOOK: type: SHOWPARTITIONS
POSTHOOK: Input: default@outputtbl1
ds=1
ds=2
-PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=1
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '1' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=1
@@ -201,12 +201,12 @@ POSTHOOK: Input: default@outputtbl1@ds=1
7 1 1
8 1 1
8 1 1
-PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=2
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '2' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=2
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_18.q.out?rev=1666021&r1=1666020&r2=1666021&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_18.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/spark/union_remove_18.q.out Wed Mar 11 21:50:22 2015
@@ -30,11 +30,11 @@ create table inputTbl1(key string, ds st
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
-PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile
+PREHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@outputTbl1
-POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile
+POSTHOOK: query: create table outputTbl1(key string, `values` bigint) partitioned by (ds string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
@@ -50,18 +50,18 @@ PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
UNION ALL
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
) a
PREHOOK: type: QUERY
POSTHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
UNION ALL
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
) a
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -168,9 +168,9 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
UNION ALL
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
) a
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
@@ -178,9 +178,9 @@ PREHOOK: Output: default@outputtbl1
POSTHOOK: query: insert overwrite table outputTbl1 partition (ds)
SELECT *
FROM (
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
UNION ALL
- SELECT key, count(1) as values, ds from inputTbl1 group by key, ds
+ SELECT key, count(1) as `values`, ds from inputTbl1 group by key, ds
) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
@@ -250,31 +250,31 @@ ds=13
ds=17
ds=18
ds=28
-PREHOOK: query: select * from outputTbl1 where ds = '11' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '11' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=11
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '11' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '11' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=11
#### A masked pattern was here ####
1 1 11
1 1 11
-PREHOOK: query: select * from outputTbl1 where ds = '18' order by key, values
+PREHOOK: query: select * from outputTbl1 where ds = '18' order by key, `values`
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=18
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds = '18' order by key, values
+POSTHOOK: query: select * from outputTbl1 where ds = '18' order by key, `values`
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=18
#### A masked pattern was here ####
8 1 18
8 1 18
-PREHOOK: query: select * from outputTbl1 where ds is not null order by key, values, ds
+PREHOOK: query: select * from outputTbl1 where ds is not null order by key, `values`, ds
PREHOOK: type: QUERY
PREHOOK: Input: default@outputtbl1
PREHOOK: Input: default@outputtbl1@ds=11
@@ -284,7 +284,7 @@ PREHOOK: Input: default@outputtbl1@ds=17
PREHOOK: Input: default@outputtbl1@ds=18
PREHOOK: Input: default@outputtbl1@ds=28
#### A masked pattern was here ####
-POSTHOOK: query: select * from outputTbl1 where ds is not null order by key, values, ds
+POSTHOOK: query: select * from outputTbl1 where ds is not null order by key, `values`, ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
POSTHOOK: Input: default@outputtbl1@ds=11