HIVE-11440: Create Parquet predicate push down (PPD) unit tests and q-tests (Ferdinand Xu, reviewed by Sergio Pena)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/f2056a13 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/f2056a13 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/f2056a13 Branch: refs/heads/master Commit: f2056a13e734ed2a00e185c069a85e514bb175b1 Parents: f530f44 Author: Ferdinand Xu <cheng.a...@intel.com> Authored: Wed Sep 2 00:34:45 2015 -0400 Committer: Ferdinand Xu <cheng.a...@intel.com> Committed: Wed Sep 2 00:39:21 2015 -0400 ---------------------------------------------------------------------- .../clientpositive/parquet_ppd_boolean.q | 35 ++ .../queries/clientpositive/parquet_ppd_char.q | 76 +++ .../queries/clientpositive/parquet_ppd_date.q | 101 ++++ .../clientpositive/parquet_ppd_decimal.q | 163 ++++++ .../clientpositive/parquet_ppd_timestamp.q | 98 ++++ .../clientpositive/parquet_ppd_varchar.q | 76 +++ .../clientpositive/parquet_ppd_boolean.q.out | 200 ++++++++ .../clientpositive/parquet_ppd_char.q.out | 220 +++++++++ .../clientpositive/parquet_ppd_date.q.out | 301 ++++++++++++ .../clientpositive/parquet_ppd_decimal.q.out | 490 +++++++++++++++++++ .../clientpositive/parquet_ppd_timestamp.q.out | 292 +++++++++++ .../clientpositive/parquet_ppd_varchar.q.out | 220 +++++++++ 12 files changed, 2272 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..05c6c50 --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_boolean.q @@ -0,0 +1,35 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET mapred.min.split.size=1000; +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; + +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 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; + + +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 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 http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..b01612c --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_char.q @@ -0,0 +1,76 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET hive.optimize.ppd=true; +SET mapred.min.split.size=1000; +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; + +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"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c="apple"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c!="apple"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c!="apple"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c<"hello"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c<"hello"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c<="hello"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c<="hello"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c="apple "; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c="apple "; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c in ("apple", "carrot"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c in ("apple", "carrot"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c in ("apple", "hello"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c in ("apple", "hello"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where c in ("carrot"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where c in ("carrot"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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 http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..a18a9cf --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_date.q @@ -0,0 +1,101 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET hive.optimize.ppd=true; +SET mapred.min.split.size=1000; +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; + +-- date data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where da='1970-02-20'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da='1970-02-20'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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)); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da!='1970-02-20'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where da<'1970-02-27'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da<'1970-02-27'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where da<'1970-02-29'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da<'1970-02-29'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where da<'1970-02-15'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da<'1970-02-15'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where da<='1970-02-20'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where da<='1970-02-20'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where da<='1970-02-27'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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)); + +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)); + +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)); + +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)); + +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)); + +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)); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'; http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..679164b --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q @@ -0,0 +1,163 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET mapred.min.split.size=1000; +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; + +-- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where d=0.22; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d=0.22; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d='0.22'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d='0.22'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d!=0.22; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d!=0.22; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d!='0.22'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d!='0.22'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<11.22; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<11.22; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<'11.22'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<'11.22'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<1; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<1; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<=11.22; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<=11.22; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<='11.22'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<='11.22'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<=11.22BD; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<=11.22BD; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where d<=12; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where d<=12; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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)); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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'; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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)); http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..e0802a0 --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_timestamp.q @@ -0,0 +1,98 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET hive.optimize.ppd=true; +SET mapred.min.split.size=1000; +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; + +-- 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'; + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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)); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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); + +set hive.optimize.index.filter=true; +select sum(hash(*)) 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)); + +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)); + +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)); + +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)); + +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)); + +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)); + +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); + +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); + +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); + +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); + +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); + +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); http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..be50ca2 --- /dev/null +++ b/ql/src/test/queries/clientpositive/parquet_ppd_varchar.q @@ -0,0 +1,76 @@ +SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; +SET hive.optimize.ppd=true; +SET mapred.min.split.size=1000; +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; + +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"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v="bee"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v!="bee"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v!="bee"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v<"world"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v<"world"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v<="world"; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v<="world"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v="bee "; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v="bee "; + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v in ("bee", "orange"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v in ("bee", "orange"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v in ("bee", "world"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v in ("bee", "world"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypestbl where v in ("orange"); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypestbl where v in ("orange"); + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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"; + +set hive.optimize.index.filter=false; +select sum(hash(*)) 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 http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..78b7aa6 --- /dev/null +++ b/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out @@ -0,0 +1,200 @@ +PREHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), b boolean) stored as parquet +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@newtypestbl +POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), b boolean) stored as parquet +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: 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: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@newtypestbl +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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where b<=false +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427776000 http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/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 new file mode 100644 index 0000000..e62462c --- /dev/null +++ b/ql/src/test/results/clientpositive/parquet_ppd_char.q.out @@ -0,0 +1,220 @@ +PREHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@newtypestbl +POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +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: 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: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@newtypestbl +POSTHOOK: Lineage: newtypestbl.c EXPRESSION [] +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" +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" +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) 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: 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: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) 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") +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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) 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: 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: 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: 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" +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: 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" +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: 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" +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: 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" +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: 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: 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: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/ql/src/test/results/clientpositive/parquet_ppd_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_date.q.out b/ql/src/test/results/clientpositive/parquet_ppd_date.q.out new file mode 100644 index 0000000..aba302e --- /dev/null +++ b/ql/src/test/results/clientpositive/parquet_ppd_date.q.out @@ -0,0 +1,301 @@ +PREHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@newtypestbl +POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +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: 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: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@newtypestbl +POSTHOOK: Lineage: newtypestbl.c EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.d EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.da EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.v EXPRESSION [] +PREHOOK: query: -- date data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where da='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: -- date data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where da='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da= date '1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da= date '1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as date) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da=cast('1970-02-20' as varchar(20)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da!='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da!='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da!='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da!='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-27' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-27' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-27' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-27' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-29' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-29' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-29' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-29' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-15' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-15' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-15' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<'1970-02-15' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-20' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-20' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-27' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-27' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-27' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da<='1970-02-27' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-19' and '1970-02-28' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where da between '1970-02-18' and '1970-02-19' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL http://git-wip-us.apache.org/repos/asf/hive/blob/f2056a13/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out b/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out new file mode 100644 index 0000000..9e48df8 --- /dev/null +++ b/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out @@ -0,0 +1,490 @@ +PREHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@newtypestbl +POSTHOOK: query: create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet +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: 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: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@newtypestbl +POSTHOOK: Lineage: newtypestbl.c EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.d EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.da EXPRESSION [] +POSTHOOK: Lineage: newtypestbl.v EXPRESSION [] +PREHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where d=0.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: -- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests) +select sum(hash(*)) from newtypestbl where d=0.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d=0.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d=0.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d='0.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d='0.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d='0.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d='0.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d=cast('0.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d=cast('0.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d=cast('0.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d=cast('0.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!=0.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!=0.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!=0.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!=0.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!='0.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!='0.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!='0.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!='0.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d!=cast('0.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<11.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<11.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<11.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<11.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<'11.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<'11.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<'11.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<'11.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<cast('11.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<cast('11.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<cast('11.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<cast('11.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<1 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<1 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<='11.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<='11.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<='11.22' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<='11.22' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=cast('11.22' as decimal) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22BD +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22BD +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22BD +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=11.22BD +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=12 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=12 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d<=12 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d<=12 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '1.0') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.22', '11.22') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0') +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', '1.0') +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +NULL +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1000 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1000 +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and 1000 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +81475875500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and '2.0' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and '2.0' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and '2.0' +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and '2.0' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 0 and cast(3 as float) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +-252951929000 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500 +PREHOOK: query: select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)) +PREHOOK: type: QUERY +PREHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(*)) from newtypestbl where d between 1 and cast(30 as char(10)) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@newtypestbl +#### A masked pattern was here #### +334427804500