HIVE-11763: Use * instead of sum(hash(*)) on Parquet predicate (PPD) integration tests (Sergio Pena, reviewed by Ferdinand Xu)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/66fb9601 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/66fb9601 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/66fb9601 Branch: refs/heads/spark Commit: 66fb9601dc1195518f2cc764851823c34c9d7dfe Parents: bbb9129 Author: Sergio Pena <[email protected]> Authored: Sun Sep 13 00:20:27 2015 -0500 Committer: Sergio Pena <[email protected]> Committed: Sun Sep 13 00:20:27 2015 -0500 ---------------------------------------------------------------------- .../clientpositive/parquet_ppd_boolean.q | 42 +- .../queries/clientpositive/parquet_ppd_char.q | 46 +- .../queries/clientpositive/parquet_ppd_date.q | 64 +- .../clientpositive/parquet_ppd_decimal.q | 106 ++-- .../clientpositive/parquet_ppd_timestamp.q | 62 +- .../clientpositive/parquet_ppd_varchar.q | 46 +- .../clientpositive/parquet_predicate_pushdown.q | 20 +- .../clientpositive/parquet_ppd_boolean.q.out | 194 ++++-- .../clientpositive/parquet_ppd_char.q.out | 224 ++++--- .../clientpositive/parquet_ppd_date.q.out | 324 +++++++--- .../clientpositive/parquet_ppd_decimal.q.out | 594 ++++++++++++++----- .../clientpositive/parquet_ppd_timestamp.q.out | 314 +++++++--- .../clientpositive/parquet_ppd_varchar.q.out | 224 ++++--- .../parquet_predicate_pushdown.q.out | 118 ++-- 14 files changed, 1584 insertions(+), 794 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q b/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q index 05c6c50..a7848b4 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q @@ -4,32 +4,32 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), b boolean) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2 limit 10) uniontbl; SET hive.optimize.ppd=true; SET hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where b=true; -select sum(hash(*)) from newtypestbl where b!=true; -select sum(hash(*)) from newtypestbl where b<true; -select sum(hash(*)) from newtypestbl where b>true; -select sum(hash(*)) from newtypestbl where b<=true; +select * from newtypestbl where b=true; +select * from newtypestbl where b!=true; +select * from newtypestbl where b<true; +select * from newtypestbl where b>true; +select * from newtypestbl where b<=true; -select sum(hash(*)) from newtypestbl where b=false; -select sum(hash(*)) from newtypestbl where b!=false; -select sum(hash(*)) from newtypestbl where b<false; -select sum(hash(*)) from newtypestbl where b>false; -select sum(hash(*)) from newtypestbl where b<=false; +select * from newtypestbl where b=false; +select * from newtypestbl where b!=false; +select * from newtypestbl where b<false; +select * from newtypestbl where b>false; +select * from newtypestbl where b<=false; SET hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where b=true; -select sum(hash(*)) from newtypestbl where b!=true; -select sum(hash(*)) from newtypestbl where b<true; -select sum(hash(*)) from newtypestbl where b>true; -select sum(hash(*)) from newtypestbl where b<=true; +select * from newtypestbl where b=true; +select * from newtypestbl where b!=true; +select * from newtypestbl where b<true; +select * from newtypestbl where b>true; +select * from newtypestbl where b<=true; -select sum(hash(*)) from newtypestbl where b=false; -select sum(hash(*)) from newtypestbl where b!=false; -select sum(hash(*)) from newtypestbl where b<false; -select sum(hash(*)) from newtypestbl where b>false; -select sum(hash(*)) from newtypestbl where b<=false; \ No newline at end of file +select * from newtypestbl where b=false; +select * from newtypestbl where b!=false; +select * from newtypestbl where b<false; +select * from newtypestbl where b>false; +select * from newtypestbl where b<=false; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_char.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_char.q b/ql/src/test/queries/clientpositive/parquet_ppd_char.q index b01612c..dcad622 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_char.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_char.q @@ -5,72 +5,72 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl; set hive.optimize.index.filter=false; -- char data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where c="apple"; +select * from newtypestbl where c="apple"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c="apple"; +select * from newtypestbl where c="apple"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c!="apple"; +select * from newtypestbl where c!="apple"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c!="apple"; +select * from newtypestbl where c!="apple"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c<"hello"; +select * from newtypestbl where c<"hello"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c<"hello"; +select * from newtypestbl where c<"hello"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c<="hello"; +select * from newtypestbl where c<="hello"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c<="hello"; +select * from newtypestbl where c<="hello"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c="apple "; +select * from newtypestbl where c="apple "; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c="apple "; +select * from newtypestbl where c="apple "; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c in ("apple", "carrot"); +select * from newtypestbl where c in ("apple", "carrot"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c in ("apple", "carrot"); +select * from newtypestbl where c in ("apple", "carrot"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c in ("apple", "hello"); +select * from newtypestbl where c in ("apple", "hello"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c in ("apple", "hello"); +select * from newtypestbl where c in ("apple", "hello"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c in ("carrot"); +select * from newtypestbl where c in ("carrot"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c in ("carrot"); +select * from newtypestbl where c in ("carrot"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c between "apple" and "carrot"; +select * from newtypestbl where c between "apple" and "carrot"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c between "apple" and "carrot"; +select * from newtypestbl where c between "apple" and "carrot"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c between "apple" and "zombie"; +select * from newtypestbl where c between "apple" and "zombie"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c between "apple" and "zombie"; +select * from newtypestbl where c between "apple" and "zombie"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1"; +select * from newtypestbl where c between "carrot" and "carrot1"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1"; \ No newline at end of file +select * from newtypestbl where c between "carrot" and "carrot1"; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_date.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_date.q b/ql/src/test/queries/clientpositive/parquet_ppd_date.q index a18a9cf..a05d358 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_date.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_date.q @@ -5,97 +5,97 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl; -- date data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where da='1970-02-20'; +select * from newtypestbl where da='1970-02-20'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da='1970-02-20'; +select * from newtypestbl where da='1970-02-20'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da= date '1970-02-20'; +select * from newtypestbl where da= date '1970-02-20'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date); +select * from newtypestbl where da=cast('1970-02-20' as date); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date); +select * from newtypestbl where da=cast('1970-02-20' as date); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)); +select * from newtypestbl where da=cast('1970-02-20' as varchar(20)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)); +select * from newtypestbl where da=cast('1970-02-20' as varchar(20)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da!='1970-02-20'; +select * from newtypestbl where da!='1970-02-20'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da!='1970-02-20'; +select * from newtypestbl where da!='1970-02-20'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da<'1970-02-27'; +select * from newtypestbl where da<'1970-02-27'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da<'1970-02-27'; +select * from newtypestbl where da<'1970-02-27'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da<'1970-02-29'; +select * from newtypestbl where da<'1970-02-29'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da<'1970-02-29'; +select * from newtypestbl where da<'1970-02-29'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da<'1970-02-15'; +select * from newtypestbl where da<'1970-02-15'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da<'1970-02-15'; +select * from newtypestbl where da<'1970-02-15'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da<='1970-02-20'; +select * from newtypestbl where da<='1970-02-20'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da<='1970-02-20'; +select * from newtypestbl where da<='1970-02-20'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da<='1970-02-27'; +select * from newtypestbl where da<='1970-02-27'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da<='1970-02-27'; +select * from newtypestbl where da<='1970-02-27'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)); +select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)); +select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)); +select * from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)); +select * from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)); +select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)); +select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22'; +select * from newtypestbl where da between '1970-02-19' and '1970-02-22'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22'; +select * from newtypestbl where da between '1970-02-19' and '1970-02-22'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28'; +select * from newtypestbl where da between '1970-02-19' and '1970-02-28'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28'; +select * from newtypestbl where da between '1970-02-19' and '1970-02-28'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19'; +select * from newtypestbl where da between '1970-02-18' and '1970-02-19'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19'; +select * from newtypestbl where da between '1970-02-18' and '1970-02-19'; http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q b/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q index 679164b..cf7cba0 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q @@ -4,160 +4,160 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl; -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where d=0.22; +select * from newtypestbl where d=0.22; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d=0.22; +select * from newtypestbl where d=0.22; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d='0.22'; +select * from newtypestbl where d='0.22'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d='0.22'; +select * from newtypestbl where d='0.22'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d=cast('0.22' as float); +select * from newtypestbl where d=cast('0.22' as float); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d=cast('0.22' as float); +select * from newtypestbl where d=cast('0.22' as float); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d!=0.22; +select * from newtypestbl where d!=0.22; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d!=0.22; +select * from newtypestbl where d!=0.22; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d!='0.22'; +select * from newtypestbl where d!='0.22'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d!='0.22'; +select * from newtypestbl where d!='0.22'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float); +select * from newtypestbl where d!=cast('0.22' as float); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float); +select * from newtypestbl where d!=cast('0.22' as float); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<11.22; +select * from newtypestbl where d<11.22; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<11.22; +select * from newtypestbl where d<11.22; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<'11.22'; +select * from newtypestbl where d<'11.22'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<'11.22'; +select * from newtypestbl where d<'11.22'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<cast('11.22' as float); +select * from newtypestbl where d<cast('11.22' as float); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<cast('11.22' as float); +select * from newtypestbl where d<cast('11.22' as float); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<1; +select * from newtypestbl where d<1; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<1; +select * from newtypestbl where d<1; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<=11.22; +select * from newtypestbl where d<=11.22; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<=11.22; +select * from newtypestbl where d<=11.22; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<='11.22'; +select * from newtypestbl where d<='11.22'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<='11.22'; +select * from newtypestbl where d<='11.22'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float); +select * from newtypestbl where d<=cast('11.22' as float); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float); +select * from newtypestbl where d<=cast('11.22' as float); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal); +select * from newtypestbl where d<=cast('11.22' as decimal); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal); +select * from newtypestbl where d<=cast('11.22' as decimal); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<=11.22BD; +select * from newtypestbl where d<=11.22BD; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<=11.22BD; +select * from newtypestbl where d<=11.22BD; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d<=12; +select * from newtypestbl where d<=12; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d<=12; +select * from newtypestbl where d<=12; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0'); +select * from newtypestbl where d in ('0.22', '1.0'); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0'); +select * from newtypestbl where d in ('0.22', '1.0'); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22'); +select * from newtypestbl where d in ('0.22', '11.22'); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22'); +select * from newtypestbl where d in ('0.22', '11.22'); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0'); +select * from newtypestbl where d in ('0.9', '1.0'); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0'); +select * from newtypestbl where d in ('0.9', '1.0'); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22); +select * from newtypestbl where d in ('0.9', 0.22); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22); +select * from newtypestbl where d in ('0.9', 0.22); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)); +select * from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)); +select * from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d between 0 and 1; +select * from newtypestbl where d between 0 and 1; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d between 0 and 1; +select * from newtypestbl where d between 0 and 1; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d between 0 and 1000; +select * from newtypestbl where d between 0 and 1000; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d between 0 and 1000; +select * from newtypestbl where d between 0 and 1000; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d between 0 and '2.0'; +select * from newtypestbl where d between 0 and '2.0'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d between 0 and '2.0'; +select * from newtypestbl where d between 0 and '2.0'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float); +select * from newtypestbl where d between 0 and cast(3 as float); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float); +select * from newtypestbl where d between 0 and cast(3 as float); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)); +select * from newtypestbl where d between 1 and cast(30 as char(10)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)); +select * from newtypestbl where d between 1 and cast(30 as char(10)); http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q b/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q index e0802a0..6ed1e55 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q @@ -5,94 +5,94 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), ts timestamp) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("2011-01-01 01:01:01" as timestamp) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("2011-01-20 01:01:01" as timestamp) from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("2011-01-01 01:01:01" as timestamp) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("2011-01-20 01:01:01" as timestamp) from src src2 limit 10) uniontbl; -- timestamp data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'; +select * from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'; +select * from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20)); +select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20)); +select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts<cast('2010-10-01 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2010-10-01 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts<cast('2010-10-01 01:01:01' as timestamp); +select * from newtypestbl where ts<cast('2010-10-01 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts<=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts<=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts<=cast('2011-01-01 01:01:01' as timestamp); +select * from newtypestbl where ts<=cast('2011-01-01 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp); +select * from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp); +select * from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as timestamp)); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as timestamp)); +select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as timestamp)); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as timestamp); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as timestamp); +select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as timestamp); http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q b/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q index be50ca2..41bf7df 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q @@ -5,72 +5,72 @@ SET mapred.max.split.size=5000; create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet; -insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl; +insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl; set hive.optimize.index.filter=false; -- varchar data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where v="bee"; +select * from newtypestbl where v="bee"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v="bee"; +select * from newtypestbl where v="bee"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v!="bee"; +select * from newtypestbl where v!="bee"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v!="bee"; +select * from newtypestbl where v!="bee"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v<"world"; +select * from newtypestbl where v<"world"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v<"world"; +select * from newtypestbl where v<"world"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v<="world"; +select * from newtypestbl where v<="world"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v<="world"; +select * from newtypestbl where v<="world"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v="bee "; +select * from newtypestbl where v="bee "; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v="bee "; +select * from newtypestbl where v="bee "; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v in ("bee", "orange"); +select * from newtypestbl where v in ("bee", "orange"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v in ("bee", "orange"); +select * from newtypestbl where v in ("bee", "orange"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v in ("bee", "world"); +select * from newtypestbl where v in ("bee", "world"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v in ("bee", "world"); +select * from newtypestbl where v in ("bee", "world"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v in ("orange"); +select * from newtypestbl where v in ("orange"); set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v in ("orange"); +select * from newtypestbl where v in ("orange"); set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v between "bee" and "orange"; +select * from newtypestbl where v between "bee" and "orange"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v between "bee" and "orange"; +select * from newtypestbl where v between "bee" and "orange"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v between "bee" and "zombie"; +select * from newtypestbl where v between "bee" and "zombie"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v between "bee" and "zombie"; +select * from newtypestbl where v between "bee" and "zombie"; set hive.optimize.index.filter=false; -select sum(hash(*)) from newtypestbl where v between "orange" and "pine"; +select * from newtypestbl where v between "orange" and "pine"; set hive.optimize.index.filter=true; -select sum(hash(*)) from newtypestbl where v between "orange" and "pine"; \ No newline at end of file +select * from newtypestbl where v between "orange" and "pine"; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/queries/clientpositive/parquet_predicate_pushdown.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_predicate_pushdown.q b/ql/src/test/queries/clientpositive/parquet_predicate_pushdown.q index 32767e8..3f97dec 100644 --- a/ql/src/test/queries/clientpositive/parquet_predicate_pushdown.q +++ b/ql/src/test/queries/clientpositive/parquet_predicate_pushdown.q @@ -60,28 +60,32 @@ SET hive.optimize.index.filter=true; SELECT * FROM tbl_pred WHERE t>2 limit 1; SET hive.optimize.index.filter=false; -SELECT SUM(HASH(t)) FROM tbl_pred +SELECT * FROM tbl_pred WHERE t IS NOT NULL AND t < 0 - AND t > -2; + AND t > -2 + LIMIT 10; SET hive.optimize.index.filter=true; -SELECT SUM(HASH(t)) FROM tbl_pred +SELECT * FROM tbl_pred WHERE t IS NOT NULL AND t < 0 - AND t > -2; + AND t > -2 + LIMIT 10; SET hive.optimize.index.filter=false; -EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred +EXPLAIN SELECT * FROM tbl_pred WHERE t IS NOT NULL AND t < 0 - AND t > -2; + AND t > -2 + LIMIT 10; SET hive.optimize.index.filter=true; -EXPLAIN SELECT SUM(HASH(t)) FROM tbl_pred +EXPLAIN SELECT * FROM tbl_pred WHERE t IS NOT NULL AND t < 0 - AND t > -2; + AND t > -2 + LIMIT 10; SET hive.optimize.index.filter=false; SELECT t, s FROM tbl_pred http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out b/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out index 78b7aa6..51ea879 100644 --- a/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out +++ b/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out @@ -6,11 +6,11 @@ POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5 POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@newtypestbl -PREHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2) uniontbl +PREHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2 limit 10) uniontbl PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@newtypestbl -POSTHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2) uniontbl +POSTHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, true from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, false from src src2 limit 10) uniontbl POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@newtypestbl @@ -18,183 +18,253 @@ POSTHOOK: Lineage: newtypestbl.b EXPRESSION [] POSTHOOK: Lineage: newtypestbl.c EXPRESSION [] POSTHOOK: Lineage: newtypestbl.d EXPRESSION [] POSTHOOK: Lineage: newtypestbl.v EXPRESSION [] -PREHOOK: query: select sum(hash(*)) from newtypestbl where b=true +PREHOOK: query: select * from newtypestbl where b=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b=true +POSTHOOK: query: select * from newtypestbl where b=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b!=true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b!=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b!=true +POSTHOOK: query: select * from newtypestbl where b!=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<true +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b<true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<true +POSTHOOK: query: select * from newtypestbl where b<true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b>true +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b>true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b>true +POSTHOOK: query: select * from newtypestbl where b>true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<=true +PREHOOK: query: select * from newtypestbl where b<=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<=true +POSTHOOK: query: select * from newtypestbl where b<=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475822500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b=false +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b=false +POSTHOOK: query: select * from newtypestbl where b=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b!=false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b!=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b!=false +POSTHOOK: query: select * from newtypestbl where b!=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<false +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b<false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<false +POSTHOOK: query: select * from newtypestbl where b<false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where b>false +PREHOOK: query: select * from newtypestbl where b>false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b>false +POSTHOOK: query: select * from newtypestbl where b>false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<=false +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b<=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<=false +POSTHOOK: query: select * from newtypestbl where b<=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b=true +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b=true +POSTHOOK: query: select * from newtypestbl where b=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b!=true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b!=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b!=true +POSTHOOK: query: select * from newtypestbl where b!=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<true +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b<true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<true +POSTHOOK: query: select * from newtypestbl where b<true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b>true +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b>true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b>true +POSTHOOK: query: select * from newtypestbl where b>true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<=true +PREHOOK: query: select * from newtypestbl where b<=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<=true +POSTHOOK: query: select * from newtypestbl where b<=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475822500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b=false +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +hello world 11.22 false +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b=false +POSTHOOK: query: select * from newtypestbl where b=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b!=false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +PREHOOK: query: select * from newtypestbl where b!=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b!=false +POSTHOOK: query: select * from newtypestbl where b!=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<false +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b<false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<false +POSTHOOK: query: select * from newtypestbl where b<false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where b>false +PREHOOK: query: select * from newtypestbl where b>false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b>false +POSTHOOK: query: select * from newtypestbl where b>false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951953500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where b<=false +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +apple bee 0.22 true +PREHOOK: query: select * from newtypestbl where b<=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<=false +POSTHOOK: query: select * from newtypestbl where b<=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427776000 +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false +hello world 11.22 false http://git-wip-us.apache.org/repos/asf/hive/blob/66fb9601/ql/src/test/results/clientpositive/parquet_ppd_char.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_char.q.out b/ql/src/test/results/clientpositive/parquet_ppd_char.q.out index e62462c..af4a13c 100644 --- a/ql/src/test/results/clientpositive/parquet_ppd_char.q.out +++ b/ql/src/test/results/clientpositive/parquet_ppd_char.q.out @@ -6,11 +6,11 @@ POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5 POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@newtypestbl -PREHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl +PREHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@newtypestbl -POSTHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2) uniontbl +POSTHOOK: query: insert overwrite table newtypestbl select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@newtypestbl @@ -19,202 +19,290 @@ POSTHOOK: Lineage: newtypestbl.d EXPRESSION [] POSTHOOK: Lineage: newtypestbl.da EXPRESSION [] POSTHOOK: Lineage: newtypestbl.v EXPRESSION [] PREHOOK: query: -- char data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where c="apple" +select * from newtypestbl where c="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### POSTHOOK: query: -- char data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) -select sum(hash(*)) from newtypestbl where c="apple" +select * from newtypestbl where c="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c="apple" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c="apple" +POSTHOOK: query: select * from newtypestbl where c="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c!="apple" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c!="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c!="apple" +POSTHOOK: query: select * from newtypestbl where c!="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427804500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c!="apple" +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +PREHOOK: query: select * from newtypestbl where c!="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c!="apple" +POSTHOOK: query: select * from newtypestbl where c!="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -334427804500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c<"hello" +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +hello world 11.22 1970-02-27 +PREHOOK: query: select * from newtypestbl where c<"hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c<"hello" +POSTHOOK: query: select * from newtypestbl where c<"hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c<"hello" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c<"hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c<"hello" +POSTHOOK: query: select * from newtypestbl where c<"hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c<="hello" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c<="hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c<="hello" +POSTHOOK: query: select * from newtypestbl where c<="hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c<="hello" +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c<="hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c<="hello" +POSTHOOK: query: select * from newtypestbl where c<="hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c="apple " +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c="apple " PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c="apple " +POSTHOOK: query: select * from newtypestbl where c="apple " POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where c="apple " +PREHOOK: query: select * from newtypestbl where c="apple " PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c="apple " +POSTHOOK: query: select * from newtypestbl where c="apple " POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "carrot") +PREHOOK: query: select * from newtypestbl where c in ("apple", "carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "carrot") +POSTHOOK: query: select * from newtypestbl where c in ("apple", "carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "carrot") +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c in ("apple", "carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "carrot") +POSTHOOK: query: select * from newtypestbl where c in ("apple", "carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "hello") +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c in ("apple", "hello") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "hello") +POSTHOOK: query: select * from newtypestbl where c in ("apple", "hello") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "hello") +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c in ("apple", "hello") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("apple", "hello") +POSTHOOK: query: select * from newtypestbl where c in ("apple", "hello") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("carrot") +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c in ("carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("carrot") +POSTHOOK: query: select * from newtypestbl where c in ("carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where c in ("carrot") +PREHOOK: query: select * from newtypestbl where c in ("carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c in ("carrot") +POSTHOOK: query: select * from newtypestbl where c in ("carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "carrot" +PREHOOK: query: select * from newtypestbl where c between "apple" and "carrot" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "carrot" +POSTHOOK: query: select * from newtypestbl where c between "apple" and "carrot" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "carrot" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c between "apple" and "carrot" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "carrot" +POSTHOOK: query: select * from newtypestbl where c between "apple" and "carrot" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### --252951929000 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "zombie" +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c between "apple" and "zombie" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "zombie" +POSTHOOK: query: select * from newtypestbl where c between "apple" and "zombie" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "zombie" +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c between "apple" and "zombie" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "apple" and "zombie" +POSTHOOK: query: select * from newtypestbl where c between "apple" and "zombie" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -81475875500 -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1" +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +hello world 11.22 1970-02-27 +apple bee 0.22 1970-02-20 +PREHOOK: query: select * from newtypestbl where c between "carrot" and "carrot1" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1" +POSTHOOK: query: select * from newtypestbl where c between "carrot" and "carrot1" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL -PREHOOK: query: select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1" +PREHOOK: query: select * from newtypestbl where c between "carrot" and "carrot1" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl #### A masked pattern was here #### -POSTHOOK: query: select sum(hash(*)) from newtypestbl where c between "carrot" and "carrot1" +POSTHOOK: query: select * from newtypestbl where c between "carrot" and "carrot1" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -NULL
