PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION_txt PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION_txt POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_PRECISION POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE DECIMAL_PRECISION_txt(dec decimal(20,10)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_PRECISION_txt POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION_txt(dec decimal(20,10)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_PRECISION_txt PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION_txt PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@decimal_precision_txt POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv8.txt' INTO TABLE DECIMAL_PRECISION_txt POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@decimal_precision_txt PREHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(20,10)) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_PRECISION POSTHOOK: query: CREATE TABLE DECIMAL_PRECISION(dec decimal(20,10)) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_PRECISION PREHOOK: query: INSERT OVERWRITE TABLE DECIMAL_PRECISION SELECT * FROM DECIMAL_PRECISION_txt PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision_txt PREHOOK: Output: default@decimal_precision POSTHOOK: query: INSERT OVERWRITE TABLE DECIMAL_PRECISION SELECT * FROM DECIMAL_PRECISION_txt POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision_txt POSTHOOK: Output: default@decimal_precision POSTHOOK: Lineage: decimal_precision.dec SIMPLE [(decimal_precision_txt)decimal_precision_txt.FieldSchema(name:dec, type:decimal(20,10), comment:null), ] PREHOOK: query: SELECT * FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0.123456789 0.123456789 1.2345678901 1.2345678901 1.2345678901 12.3456789012 12.3456789012 12.3456789012 123.4567890123 123.4567890123 123.4567890123 1234.5678901235 1234.5678901235 1234.5678901235 12345.6789012346 12345.6789012346 123456.7890123456 123456.7890123457 1234567.890123456 1234567.8901234568 12345678.90123456 12345678.9012345679 123456789.0123456 123456789.0123456789 1234567890.123456 1234567890.123456789 PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 1 -1 0 1 -1 0 1 -1 0 1 -1 0 1 -1 0.123456789 1.123456789 -0.876543211 0.123456789 1.123456789 -0.876543211 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 12.3456789012 13.3456789012 11.3456789012 12.3456789012 13.3456789012 11.3456789012 12.3456789012 13.3456789012 11.3456789012 123.4567890123 124.4567890123 122.4567890123 123.4567890123 124.4567890123 122.4567890123 123.4567890123 124.4567890123 122.4567890123 1234.5678901235 1235.5678901235 1233.5678901235 1234.5678901235 1235.5678901235 1233.5678901235 1234.5678901235 1235.5678901235 1233.5678901235 12345.6789012346 12346.6789012346 12344.6789012346 12345.6789012346 12346.6789012346 12344.6789012346 123456.7890123456 123457.7890123456 123455.7890123456 123456.7890123457 123457.7890123457 123455.7890123457 1234567.890123456 1234568.890123456 1234566.890123456 1234567.8901234568 1234568.8901234568 1234566.8901234568 12345678.90123456 12345679.90123456 12345677.90123456 12345678.9012345679 12345679.9012345679 12345677.9012345679 123456789.0123456 123456790.0123456 123456788.0123456 123456789.0123456789 123456790.0123456789 123456788.0123456789 1234567890.123456 1234567891.123456 1234567889.123456 1234567890.123456789 1234567891.123456789 1234567889.123456789 PREHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.123456789 0.246913578 0.041152263 0.123456789 0.246913578 0.041152263 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 12.3456789012 24.6913578024 4.1152263004 12.3456789012 24.6913578024 4.1152263004 12.3456789012 24.6913578024 4.1152263004 123.4567890123 246.9135780246 41.1522630041 123.4567890123 246.9135780246 41.1522630041 123.4567890123 246.9135780246 41.1522630041 1234.5678901235 2469.135780247 411.522630041167 1234.5678901235 2469.135780247 411.522630041167 1234.5678901235 2469.135780247 411.522630041167 12345.6789012346 24691.3578024692 4115.226300411533 12345.6789012346 24691.3578024692 4115.226300411533 123456.7890123456 246913.5780246912 41152.2630041152 123456.7890123457 246913.5780246914 41152.263004115233 1234567.890123456 2469135.780246912 411522.630041152 1234567.8901234568 2469135.7802469136 411522.630041152267 12345678.90123456 24691357.80246912 4115226.30041152 12345678.9012345679 24691357.8024691358 4115226.300411522633 123456789.0123456 246913578.0246912 41152263.0041152 123456789.0123456789 246913578.0246913578 41152263.0041152263 1234567890.123456 2469135780.246912 411522630.041152 1234567890.123456789 2469135780.246913578 411522630.041152263 PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0.123456789 0.013717421 0.123456789 0.013717421 1.2345678901 0.137174210011 1.2345678901 0.137174210011 1.2345678901 0.137174210011 12.3456789012 1.371742100133 12.3456789012 1.371742100133 12.3456789012 1.371742100133 123.4567890123 13.717421001367 123.4567890123 13.717421001367 123.4567890123 13.717421001367 1234.5678901235 137.174210013722 1234.5678901235 137.174210013722 1234.5678901235 137.174210013722 12345.6789012346 1371.742100137178 12345.6789012346 1371.742100137178 123456.7890123456 13717.421001371733 123456.7890123457 13717.421001371744 1234567.890123456 137174.210013717333 1234567.8901234568 137174.210013717422 12345678.90123456 1371742.100137173333 12345678.9012345679 1371742.100137174211 123456789.0123456 13717421.001371733333 123456789.0123456789 13717421.0013717421 1234567890.123456 137174210.013717333333 1234567890.123456789 137174210.013717421 PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0.123456789 0.0045724736667 0.123456789 0.0045724736667 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 12.3456789012 0.4572473667111 12.3456789012 0.4572473667111 12.3456789012 0.4572473667111 123.4567890123 4.5724736671222 123.4567890123 4.5724736671222 123.4567890123 4.5724736671222 1234.5678901235 45.7247366712407 1234.5678901235 45.7247366712407 1234.5678901235 45.7247366712407 12345.6789012346 457.2473667123926 12345.6789012346 457.2473667123926 123456.7890123456 4572.4736671239111 123456.7890123457 4572.4736671239148 1234567.890123456 45724.7366712391111 1234567.8901234568 45724.7366712391407 12345678.90123456 457247.3667123911111 12345678.9012345679 457247.3667123914037 123456789.0123456 4572473.6671239111111 123456789.0123456789 4572473.6671239140333 1234567890.123456 45724736.6712391111111 1234567890.123456789 45724736.6712391403333 PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0.123456789 0.015241578750190521 0.123456789 0.015241578750190521 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 12.3456789012 152.41578753153483936144 12.3456789012 152.41578753153483936144 12.3456789012 152.41578753153483936144 123.4567890123 15241.57875322755800955129 123.4567890123 15241.57875322755800955129 123.4567890123 15241.57875322755800955129 1234.5678901235 1524157.87532399036884525225 1234.5678901235 1524157.87532399036884525225 1234.5678901235 1524157.87532399036884525225 12345.6789012346 152415787.53238916034140423716 12345.6789012346 152415787.53238916034140423716 123456.7890123456 15241578753.23881726870921383936 123456.7890123457 15241578753.23884196006701630849 1234567.890123456 1524157875323.881726870921383936 1234567.8901234568 1524157875323.88370217954558146624 12345678.90123456 152415787532388.1726870921383936 12345678.9012345679 152415787532388.36774881877789971041 123456789.0123456 15241578753238817.26870921383936 123456789.0123456789 15241578753238836.75019051998750190521 1234567890.123456 NULL 1234567890.123456789 NULL PREHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: decimal_precision Statistics: Num rows: 75 Data size: 3472 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: dec (type: decimal(20,10)) outputColumnNames: _col0 Statistics: Num rows: 75 Data size: 3472 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(_col0), sum(_col0) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: struct), _col1 (type: decimal(30,10)) Execution mode: vectorized Reduce Operator Tree: Group By Operator aggregations: avg(VALUE._col0), sum(VALUE._col1) mode: mergepartial outputColumnNames: _col0, _col1 Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### 88499534.57586576220645 2743485571.8518386284 PREHOOK: query: SELECT dec * cast('12345678901234567890.12345678' as decimal(38,18)) FROM DECIMAL_PRECISION LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec * cast('12345678901234567890.12345678' as decimal(38,18)) FROM DECIMAL_PRECISION LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL PREHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('1234567890123456789012345678.12345678' as decimal(38,18)) LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT * from DECIMAL_PRECISION WHERE dec > cast('1234567890123456789012345678.12345678' as decimal(38,18)) LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### PREHOOK: query: SELECT dec * 12345678901234567890.12345678 FROM DECIMAL_PRECISION LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT dec * 12345678901234567890.12345678 FROM DECIMAL_PRECISION LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### NULL PREHOOK: query: SELECT MIN(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT MIN(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### 12345678901234567890.12345678 PREHOOK: query: SELECT COUNT(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision #### A masked pattern was here #### POSTHOOK: query: SELECT COUNT(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### 75 PREHOOK: query: DROP TABLE DECIMAL_PRECISION_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_precision_txt PREHOOK: Output: default@decimal_precision_txt POSTHOOK: query: DROP TABLE DECIMAL_PRECISION_txt POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_precision_txt POSTHOOK: Output: default@decimal_precision_txt PREHOOK: query: DROP TABLE DECIMAL_PRECISION PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_precision PREHOOK: Output: default@decimal_precision POSTHOOK: query: DROP TABLE DECIMAL_PRECISION POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_precision POSTHOOK: Output: default@decimal_precision