http://git-wip-us.apache.org/repos/asf/hive/blob/bbfc4d9d/ql/src/test/results/clientpositive/cte_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cte_2.q.out b/ql/src/test/results/clientpositive/cte_2.q.out index 4b0bc71..f68d9df 100644 --- a/ql/src/test/results/clientpositive/cte_2.q.out +++ b/ql/src/test/results/clientpositive/cte_2.q.out @@ -188,3 +188,31 @@ POSTHOOK: query: drop view v1 POSTHOOK: type: DROPVIEW POSTHOOK: Input: default@v1 POSTHOOK: Output: default@v1 +PREHOOK: query: drop view if exists view_3 +PREHOOK: type: DROPVIEW +POSTHOOK: query: drop view if exists view_3 +POSTHOOK: type: DROPVIEW +PREHOOK: query: create view view_3 as select cstring2, AVG(cint) from alltypesorc group by cstring2 limit 10 +PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: database:default +PREHOOK: Output: default@view_3 +POSTHOOK: query: create view view_3 as select cstring2, AVG(cint) from alltypesorc group by cstring2 limit 10 +POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: database:default +POSTHOOK: Output: default@view_3 +PREHOOK: query: drop view if exists view_4 +PREHOOK: type: DROPVIEW +POSTHOOK: query: drop view if exists view_4 +POSTHOOK: type: DROPVIEW +PREHOOK: query: create view view_4 as select s.cstring1, v.ctimestamp1 from alltypesorc s join alltypesorc v on (s.cstring2= v.cstring1) +PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: database:default +PREHOOK: Output: default@view_4 +POSTHOOK: query: create view view_4 as select s.cstring1, v.ctimestamp1 from alltypesorc s join alltypesorc v on (s.cstring2= v.cstring1) +POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: database:default +POSTHOOK: Output: default@view_4
http://git-wip-us.apache.org/repos/asf/hive/blob/bbfc4d9d/ql/src/test/results/clientpositive/current_date_timestamp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/current_date_timestamp.q.out b/ql/src/test/results/clientpositive/current_date_timestamp.q.out index 9c26095..93e5104 100644 --- a/ql/src/test/results/clientpositive/current_date_timestamp.q.out +++ b/ql/src/test/results/clientpositive/current_date_timestamp.q.out @@ -11,6 +11,356 @@ true true true true true true true true +PREHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row +select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: --ensure that timestamp is same for all the rows while using current_timestamp() query should return single row +select count(*) from (select current_timestamp() from alltypesorc union select current_timestamp() from src limit 5 ) subq +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### +1 +PREHOOK: query: select count(*) from (select current_timestamp() from alltypesorc + union + select current_timestamp() from src + limit 5 ) subqr +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from (select current_timestamp() from alltypesorc + union + select current_timestamp() from src + limit 5 ) subqr +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### +1 +PREHOOK: query: --current_timestamp() should appear as expression +explain extended select current_timestamp() from alltypesorc +PREHOOK: type: QUERY +POSTHOOK: query: --current_timestamp() should appear as expression +explain extended select current_timestamp() from alltypesorc +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-0 is a root stage + +STAGE PLANS: + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + TableScan + alias: alltypesorc + Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: COMPLETE + GatherStats: false + Select Operator + expressions: 2012-01-01 01:02:03.0 (type: timestamp) + outputColumnNames: _col0 + Statistics: Num rows: 12288 Data size: 491520 Basic stats: COMPLETE Column stats: COMPLETE + ListSink + +PREHOOK: query: --current_timestamp() + insert +create temporary table tmp_runtimeconstant( + ts1 timestamp, + ts2 timestamp, + dt date, + s string, + v varchar(50), + c char(50) + ) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: --current_timestamp() + insert +create temporary table tmp_runtimeconstant( + ts1 timestamp, + ts2 timestamp, + dt date, + s string, + v varchar(50), + c char(50) + ) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tmp_runtimeconstant +PREHOOK: query: insert into table tmp_runtimeconstant + select current_timestamp(), + cast(current_timestamp() as timestamp), + cast(current_timestamp() as date), + cast(current_timestamp() as string), + cast(current_timestamp() as varchar(50)), + cast(current_timestamp() as char(50)) + from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: insert into table tmp_runtimeconstant + select current_timestamp(), + cast(current_timestamp() as timestamp), + cast(current_timestamp() as date), + cast(current_timestamp() as string), + cast(current_timestamp() as varchar(50)), + cast(current_timestamp() as char(50)) + from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: Lineage: tmp_runtimeconstant.c SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.dt SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.s SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.ts1 SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.ts2 SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.v SIMPLE [] +PREHOOK: query: select ts1 = ts2, + to_date(ts2) = dt, + s = v, + v = c +from tmp_runtimeconstant +PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +POSTHOOK: query: select ts1 = ts2, + to_date(ts2) = dt, + s = v, + v = c +from tmp_runtimeconstant +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +true true true true +true true true true +true true true true +true true true true +true true true true +PREHOOK: query: --current_date() + insert +drop table if exists tmp_runtimeconstant +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@tmp_runtimeconstant +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: --current_date() + insert +drop table if exists tmp_runtimeconstant +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@tmp_runtimeconstant +POSTHOOK: Output: default@tmp_runtimeconstant +PREHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: create temporary table tmp_runtimeconstant(d date, t timestamp) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tmp_runtimeconstant +PREHOOK: query: insert into table tmp_runtimeconstant + select current_date(), current_timestamp() from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: insert into table tmp_runtimeconstant + select current_date(), current_timestamp() from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE [] +PREHOOK: query: select to_date(t)=d from tmp_runtimeconstant +PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +POSTHOOK: query: select to_date(t)=d from tmp_runtimeconstant +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +true +true +true +true +true +PREHOOK: query: --current_timestamp() + current_date() + where +drop table if exists tmp_runtimeconstant +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@tmp_runtimeconstant +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: --current_timestamp() + current_date() + where +drop table if exists tmp_runtimeconstant +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@tmp_runtimeconstant +POSTHOOK: Output: default@tmp_runtimeconstant +PREHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: create temporary table tmp_runtimeconstant(t timestamp, d date) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tmp_runtimeconstant +PREHOOK: query: insert into table tmp_runtimeconstant + select current_timestamp(), current_date() from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: query: insert into table tmp_runtimeconstant + select current_timestamp(), current_date() from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Output: default@tmp_runtimeconstant +POSTHOOK: Lineage: tmp_runtimeconstant.d SIMPLE [] +POSTHOOK: Lineage: tmp_runtimeconstant.t SIMPLE [] +PREHOOK: query: select count(*) from tmp_runtimeconstant + where current_timestamp() >= t + and current_date <> d +PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +POSTHOOK: query: select count(*) from tmp_runtimeconstant + where current_timestamp() >= t + and current_date <> d +POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_runtimeconstant +#### A masked pattern was here #### +0 +PREHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second() +select unix_timestamp(current_timestamp()), + hour(current_timestamp()), + minute(current_timestamp()), + second(current_timestamp()) + from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +POSTHOOK: query: --current_timestamp() as argument for unix_timestamp(), hour(), minute(), second() +select unix_timestamp(current_timestamp()), + hour(current_timestamp()), + minute(current_timestamp()), + second(current_timestamp()) + from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +1325408523 1 2 3 +1325408523 1 2 3 +1325408523 1 2 3 +1325408523 1 2 3 +1325408523 1 2 3 +PREHOOK: query: --current_timestamp() as argument for various date udfs +select to_date(current_timestamp()), + year(current_timestamp()), + month(current_timestamp()), + day(current_timestamp()), + weekofyear(current_timestamp()), + datediff(current_timestamp(),current_timestamp), + to_date(date_add(current_timestamp(), 31)), + to_date(date_sub(current_timestamp(), 31)), + last_day(current_timestamp()), + next_day(current_timestamp(),'FRIDAY') + from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +POSTHOOK: query: --current_timestamp() as argument for various date udfs +select to_date(current_timestamp()), + year(current_timestamp()), + month(current_timestamp()), + day(current_timestamp()), + weekofyear(current_timestamp()), + datediff(current_timestamp(),current_timestamp), + to_date(date_add(current_timestamp(), 31)), + to_date(date_sub(current_timestamp(), 31)), + last_day(current_timestamp()), + next_day(current_timestamp(),'FRIDAY') + from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +PREHOOK: query: --current_date() as argument for various date udfs +select to_date(current_date()), + year(current_date()), + month(current_date()), + day(current_date()), + weekofyear(current_date()), + datediff(current_date(),current_date), + to_date(date_add(current_date(), 31)), + to_date(date_sub(current_date(), 31)), + last_day(current_date()), + next_day(current_date(),'FRIDAY') + from alltypesorc limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +POSTHOOK: query: --current_date() as argument for various date udfs +select to_date(current_date()), + year(current_date()), + month(current_date()), + day(current_date()), + weekofyear(current_date()), + datediff(current_date(),current_date), + to_date(date_add(current_date(), 31)), + to_date(date_sub(current_date(), 31)), + last_day(current_date()), + next_day(current_date(),'FRIDAY') + from alltypesorc limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +2012-01-01 2012 1 1 52 0 2012-02-01 2011-12-01 2012-01-31 2012-01-06 +PREHOOK: query: select current_timestamp() - current_timestamp(), + current_timestamp() - current_date(), + current_date() - current_timestamp(), + current_date() - current_date() + from alltypesorc limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +POSTHOOK: query: select current_timestamp() - current_timestamp(), + current_timestamp() - current_date(), + current_date() - current_timestamp(), + current_date() - current_date() + from alltypesorc limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +0 00:00:00.000000000 0 01:02:03.000000000 -0 01:02:03.000000000 0 00:00:00.000000000 +PREHOOK: query: select ctimestamp1 - current_date(), + ctimestamp1- ctimestamp2, + current_date() - current_date(), + current_date() - ctimestamp2 +from alltypesorc +where ctimestamp1 is not null + and ctimestamp2 is not null + limit 5 +PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +POSTHOOK: query: select ctimestamp1 - current_date(), + ctimestamp1- ctimestamp2, + current_date() - current_date(), + current_date() - ctimestamp2 +from alltypesorc +where ctimestamp1 is not null + and ctimestamp2 is not null + limit 5 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### +-15340 08:00:12.326000000 -0 00:00:21.201000000 0 00:00:00.000000000 15340 07:59:51.125000000 +-15340 08:00:03.213000000 -0 00:00:04.759000000 0 00:00:00.000000000 15340 07:59:58.454000000 +-15340 08:00:14.813000000 -0 00:00:21.774000000 0 00:00:00.000000000 15340 07:59:53.039000000 +-15340 08:00:08.566000000 -0 00:00:21.918000000 0 00:00:00.000000000 15340 07:59:46.648000000 +-15340 07:59:44.993000000 -0 00:00:00.141000000 0 00:00:00.000000000 15340 07:59:44.852000000 PREHOOK: query: select current_date, current_timestamp from src limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src