You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by dj...@apache.org on 2018/05/08 18:42:47 UTC
[42/58] [abbrv] hive git commit: HIVE-18910 : Migrate to Murmur hash
for shuffle and bucketing (Deepak Jaiswal, reviewed by Jasone Dere)
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/default_constraint.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/default_constraint.q.out b/ql/src/test/results/clientpositive/llap/default_constraint.q.out
deleted file mode 100644
index dd8cc4f..0000000
--- a/ql/src/test/results/clientpositive/llap/default_constraint.q.out
+++ /dev/null
@@ -1,2793 +0,0 @@
-PREHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647,
- d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89)
- clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@numericDataType
-POSTHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647,
- d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89)
- clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@numericDataType
-PREHOOK: query: DESC FORMATTED numericDataType
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@numericdatatype
-POSTHOOK: query: DESC FORMATTED numericDataType
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@numericdatatype
-# col_name data_type comment
-a tinyint
-b smallint
-c int
-d bigint
-e double
-f decimal(9,2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [a]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.numericdatatype
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:32767S
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:2147483647
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:9223372036854775807L
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:f Default Value:1234567.89
-
-Constraint Name: tinyint_constraint
-Column Name:a Default Value:127Y
-
-PREHOOK: query: EXPLAIN INSERT INTO numericDataType(a) values(3Y)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(a) values(3Y)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(3)) (type: array<struct<col1:int>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: col1 (type: int), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: UDFToByte(_col0) (type: tinyint)
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: int), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: UDFToByte(VALUE._col0) (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO numericDataType(a) values(3Y)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: INSERT INTO numericDataType(a) values(3Y)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@numericdatatype
-POSTHOOK: Lineage: numericdatatype.a SCRIPT []
-POSTHOOK: Lineage: numericdatatype.b SIMPLE []
-POSTHOOK: Lineage: numericdatatype.c SIMPLE []
-POSTHOOK: Lineage: numericdatatype.d SIMPLE []
-POSTHOOK: Lineage: numericdatatype.e SIMPLE []
-POSTHOOK: Lineage: numericdatatype.f SIMPLE []
-PREHOOK: query: SELECT * FROM numericDataType
-PREHOOK: type: QUERY
-PREHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM numericDataType
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-3 32767 2147483647 9223372036854775807 3.4E38 1234567.89
-PREHOOK: query: EXPLAIN INSERT INTO numericDataType(e,f) values(4.5, 678.4)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(e,f) values(4.5, 678.4)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(4.5,678.4)) (type: array<struct<col1:decimal(2,1),col2:decimal(4,1)>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: 127Y (type: tinyint), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), col1 (type: decimal(2,1)), col2 (type: decimal(4,1))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col0 (type: tinyint)
- Statistics: Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(2,1)), _col5 (type: decimal(4,1))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), UDFToDouble(VALUE._col4) (type: double), CAST( VALUE._col5 AS decimal(9,2)) (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO numericDataType(e,f) values(4.5, 678.4)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: INSERT INTO numericDataType(e,f) values(4.5, 678.4)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@numericdatatype
-POSTHOOK: Lineage: numericdatatype.a SIMPLE []
-POSTHOOK: Lineage: numericdatatype.b SIMPLE []
-POSTHOOK: Lineage: numericdatatype.c SIMPLE []
-POSTHOOK: Lineage: numericdatatype.d SIMPLE []
-POSTHOOK: Lineage: numericdatatype.e SCRIPT []
-POSTHOOK: Lineage: numericdatatype.f SCRIPT []
-PREHOOK: query: SELECT * FROM numericDataType
-PREHOOK: type: QUERY
-PREHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM numericDataType
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-3 32767 2147483647 9223372036854775807 3.4E38 1234567.89
-127 32767 2147483647 9223372036854775807 4.5 678.40
-PREHOOK: query: DROP TABLE numericDataType
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@numericdatatype
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: DROP TABLE numericDataType
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@numericdatatype
-POSTHOOK: Output: default@numericdatatype
-PREHOOK: query: -- Date/time
-CREATE TABLE table1(d DATE DEFAULT DATE'2018-02-14', t TIMESTAMP DEFAULT TIMESTAMP'2016-02-22 12:45:07.000000000',
- tz timestamp with local time zone DEFAULT TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles',
- d1 DATE DEFAULT current_date() ENABLE, t1 TIMESTAMP DEFAULT current_timestamp() DISABLE)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table1
-POSTHOOK: query: -- Date/time
-CREATE TABLE table1(d DATE DEFAULT DATE'2018-02-14', t TIMESTAMP DEFAULT TIMESTAMP'2016-02-22 12:45:07.000000000',
- tz timestamp with local time zone DEFAULT TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles',
- d1 DATE DEFAULT current_date() ENABLE, t1 TIMESTAMP DEFAULT current_timestamp() DISABLE)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table1
-PREHOOK: query: DESC FORMATTED table1
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table1
-POSTHOOK: query: DESC FORMATTED table1
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table1
-# col_name data_type comment
-d date
-t timestamp
-tz timestamp with local time zone('US/Pacific')
-d1 date
-t1 timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.table1
-Constraint Name: #### A masked pattern was here ####
-Column Name:d1 Default Value:current_date()
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:DATE'2018-02-14'
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:t Default Value:TIMESTAMP'2016-02-22 12:45:07.000000000'
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:t1 Default Value:current_timestamp()
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:tz Default Value:TIMESTAMPLOCALTZ'2016-01-03 12:26:34 America/Los_Angeles'
-
-PREHOOK: query: EXPLAIN INSERT INTO table1(t) values ("1985-12-31 12:45:07")
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO table1(t) values ("1985-12-31 12:45:07")
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('1985-12-31 12:45:07')) (type: array<struct<col1:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: DATE'2018-02-14' (type: date), CAST( col1 AS TIMESTAMP) (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), null (type: timestamp)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.table1
- Execution mode: llap
- LLAP IO: no inputs
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- 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
- name: default.table1
-
-PREHOOK: query: INSERT INTO table1(t) values ("1985-12-31 12:45:07")
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@table1
-POSTHOOK: query: INSERT INTO table1(t) values ("1985-12-31 12:45:07")
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@table1
-POSTHOOK: Lineage: table1.d SIMPLE []
-POSTHOOK: Lineage: table1.d1 EXPRESSION []
-POSTHOOK: Lineage: table1.t SCRIPT []
-POSTHOOK: Lineage: table1.t1 SIMPLE []
-POSTHOOK: Lineage: table1.tz SIMPLE []
-PREHOOK: query: SELECT d, t, tz,d1=current_date(), t1 from table1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table1
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT d, t, tz,d1=current_date(), t1 from table1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table1
-#### A masked pattern was here ####
-2018-02-14 1985-12-31 12:45:07 2016-01-03 12:26:34.0 US/Pacific true NULL
-PREHOOK: query: EXPLAIN INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('1985-12-31','2018-02-27 17:32:14.259')) (type: array<struct<col1:string,col2:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: CAST( col1 AS DATE) (type: date), TIMESTAMP'2016-02-22 12:45:07.0' (type: timestamp), TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0 US/Pacific' (type: timestamp with local time zone), CURRENT_DATE() (type: date), CAST( col2 AS TIMESTAMP) (type: timestamp)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.table1
- Execution mode: llap
- LLAP IO: no inputs
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- 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
- name: default.table1
-
-PREHOOK: query: INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259')
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@table1
-POSTHOOK: query: INSERT INTO table1(d, t1) values ("1985-12-31", '2018-02-27 17:32:14.259')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@table1
-POSTHOOK: Lineage: table1.d SCRIPT []
-POSTHOOK: Lineage: table1.d1 EXPRESSION []
-POSTHOOK: Lineage: table1.t SIMPLE []
-POSTHOOK: Lineage: table1.t1 SCRIPT []
-POSTHOOK: Lineage: table1.tz SIMPLE []
-PREHOOK: query: SELECT d, t, tz,d1=current_date(), t1=current_timestamp() from table1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table1
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT d, t, tz,d1=current_date(), t1=current_timestamp() from table1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table1
-#### A masked pattern was here ####
-2018-02-14 1985-12-31 12:45:07 2016-01-03 12:26:34.0 US/Pacific true NULL
-1985-12-31 2016-02-22 12:45:07 2016-01-03 12:26:34.0 US/Pacific true false
-PREHOOK: query: DROP TABLE table1
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table1
-PREHOOK: Output: default@table1
-POSTHOOK: query: DROP TABLE table1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table1
-POSTHOOK: Output: default@table1
-PREHOOK: query: CREATE TABLE table2(i STRING DEFAULT 'current_database()', j STRING DEFAULT current_user(),
- k STRING DEFAULT 'Current_User()', v varchar(350) DEFAULT cast('varchar_default_value' as varchar(350)),
- c char(20) DEFAULT cast('char_value' as char(20)))
- clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table2
-POSTHOOK: query: CREATE TABLE table2(i STRING DEFAULT 'current_database()', j STRING DEFAULT current_user(),
- k STRING DEFAULT 'Current_User()', v varchar(350) DEFAULT cast('varchar_default_value' as varchar(350)),
- c char(20) DEFAULT cast('char_value' as char(20)))
- clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table2
-PREHOOK: query: DESC FORMATTED table2
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table2
-POSTHOOK: query: DESC FORMATTED table2
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table2
-# col_name data_type comment
-i string
-j string
-k string
-v varchar(350)
-c char(20)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [i]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.table2
-Constraint Name: #### A masked pattern was here ####
-Column Name:j Default Value:current_user()
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:k Default Value:'Current_User()'
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:v Default Value:cast('varchar_default_value' as varchar(350))
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:cast('char_value' as char(20))
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:i Default Value:'current_database()'
-
-PREHOOK: query: EXPLAIN INSERT INTO table2(i) values('default')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO table2(i) values('default')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('default')) (type: array<struct<col1:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: col1 (type: string), CURRENT_USER() (type: string), 'Current_User()' (type: string), CAST( 'varchar_default_value' AS varchar(350)) (type: varchar(350)), CAST( 'char_value' AS CHAR(20)) (type: char(20))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: varchar(350)), _col4 (type: char(20))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: varchar(350)), VALUE._col4 (type: char(20))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 405 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.table2
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.table2
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO table2(i) values('default')
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@table2
-POSTHOOK: query: INSERT INTO table2(i) values('default')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@table2
-POSTHOOK: Lineage: table2.c EXPRESSION []
-POSTHOOK: Lineage: table2.i SCRIPT []
-POSTHOOK: Lineage: table2.j EXPRESSION []
-POSTHOOK: Lineage: table2.k SIMPLE []
-POSTHOOK: Lineage: table2.v EXPRESSION []
-PREHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table2
-#### A masked pattern was here ####
-default true Current_User() varchar_default_value char_value
-PREHOOK: query: EXPLAIN INSERT INTO table2(v, c) values('varchar_default2', 'char')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO table2(v, c) values('varchar_default2', 'char')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('varchar_default2','char')) (type: array<struct<col1:string,col2:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: 'current_database()' (type: string), CURRENT_USER() (type: string), 'Current_User()' (type: string), col1 (type: string), col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 298 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 1 Data size: 298 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), CAST( VALUE._col3 AS varchar(350)) (type: varchar(350)), CAST( VALUE._col4 AS CHAR(20)) (type: char(20))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 836 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 836 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.table2
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.table2
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO table2(v, c) values('varchar_default2', 'char')
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@table2
-POSTHOOK: query: INSERT INTO table2(v, c) values('varchar_default2', 'char')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@table2
-POSTHOOK: Lineage: table2.c SCRIPT []
-POSTHOOK: Lineage: table2.i SIMPLE []
-POSTHOOK: Lineage: table2.j EXPRESSION []
-POSTHOOK: Lineage: table2.k SIMPLE []
-POSTHOOK: Lineage: table2.v SCRIPT []
-PREHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT i,j=current_user(),k,v,c FROM table2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table2
-#### A masked pattern was here ####
-default true Current_User() varchar_default_value char_value
-current_database() true Current_User() varchar_default2 char
-PREHOOK: query: DROP TABLE table2
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table2
-PREHOOK: Output: default@table2
-POSTHOOK: query: DROP TABLE table2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table2
-POSTHOOK: Output: default@table2
-PREHOOK: query: CREATE TABLE misc(b BOOLEAN DEFAULT true, b1 BINARY DEFAULT cast('bin' as binary))
- clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@misc
-POSTHOOK: query: CREATE TABLE misc(b BOOLEAN DEFAULT true, b1 BINARY DEFAULT cast('bin' as binary))
- clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@misc
-PREHOOK: query: DESC FORMATTED misc
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@misc
-POSTHOOK: query: DESC FORMATTED misc
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@misc
-# col_name data_type comment
-b boolean
-b1 binary
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [b]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.misc
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:true
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b1 Default Value:cast('bin' as binary)
-
-PREHOOK: query: EXPLAIN INSERT INTO misc(b) values(false)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO misc(b) values(false)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(false)) (type: array<struct<col1:boolean>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: col1 (type: boolean), CAST( 'bin' AS BINARY) (type: binary)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col0 (type: boolean)
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: boolean), _col1 (type: binary)
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: boolean), VALUE._col1 (type: binary)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.misc
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.misc
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO misc(b) values(false)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@misc
-POSTHOOK: query: INSERT INTO misc(b) values(false)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@misc
-POSTHOOK: Lineage: misc.b SCRIPT []
-POSTHOOK: Lineage: misc.b1 EXPRESSION []
-PREHOOK: query: SELECT b, b1 from misc
-PREHOOK: type: QUERY
-PREHOOK: Input: default@misc
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT b, b1 from misc
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@misc
-#### A masked pattern was here ####
-false bin
-PREHOOK: query: EXPLAIN INSERT INTO misc(b1) values('011')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO misc(b1) values('011')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('011')) (type: array<struct<col1:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: true (type: boolean), col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col0 (type: boolean)
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: boolean), _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: boolean), CAST( VALUE._col1 AS BINARY) (type: binary)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 148 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 148 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.misc
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.misc
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO misc(b) values(false)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@misc
-POSTHOOK: query: INSERT INTO misc(b) values(false)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@misc
-POSTHOOK: Lineage: misc.b SCRIPT []
-POSTHOOK: Lineage: misc.b1 EXPRESSION []
-PREHOOK: query: SELECT b, b1 from misc
-PREHOOK: type: QUERY
-PREHOOK: Input: default@misc
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT b, b1 from misc
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@misc
-#### A masked pattern was here ####
-false bin
-false bin
-PREHOOK: query: DROP TABLE misc
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@misc
-PREHOOK: Output: default@misc
-POSTHOOK: query: DROP TABLE misc
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@misc
-POSTHOOK: Output: default@misc
-PREHOOK: query: CREATE table t11(i int default cast(cast(4 as double) as int),
- b1 boolean default cast ('true' as boolean), b2 int default cast (5.67 as int),
- b3 tinyint default cast (45 as tinyint), b4 float default cast (45.4 as float),
- b5 bigint default cast (567 as bigint), b6 smallint default cast (88 as smallint),
- j varchar(50) default cast(current_timestamp() as varchar(50)),
- k string default cast(cast(current_user() as varchar(50)) as string),
- tz1 timestamp with local time zone DEFAULT cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone),
- ts timestamp default cast('2016-01-01 12:01:01' as timestamp),
- dc decimal(8,2) default cast(4.5 as decimal(8,2)),
- c2 double default cast(5 as double), c4 char(2) default cast(cast(cast('ab' as string) as varchar(2)) as char(2)))
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@t11
-POSTHOOK: query: CREATE table t11(i int default cast(cast(4 as double) as int),
- b1 boolean default cast ('true' as boolean), b2 int default cast (5.67 as int),
- b3 tinyint default cast (45 as tinyint), b4 float default cast (45.4 as float),
- b5 bigint default cast (567 as bigint), b6 smallint default cast (88 as smallint),
- j varchar(50) default cast(current_timestamp() as varchar(50)),
- k string default cast(cast(current_user() as varchar(50)) as string),
- tz1 timestamp with local time zone DEFAULT cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone),
- ts timestamp default cast('2016-01-01 12:01:01' as timestamp),
- dc decimal(8,2) default cast(4.5 as decimal(8,2)),
- c2 double default cast(5 as double), c4 char(2) default cast(cast(cast('ab' as string) as varchar(2)) as char(2)))
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@t11
-PREHOOK: query: DESC FORMATTED t11
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@t11
-POSTHOOK: query: DESC FORMATTED t11
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@t11
-# col_name data_type comment
-i int
-b1 boolean
-b2 int
-b3 tinyint
-b4 float
-b5 bigint
-b6 smallint
-j varchar(50)
-k string
-tz1 timestamp with local time zone('US/Pacific')
-ts timestamp
-dc decimal(8,2)
-c2 double
-c4 char(2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.t11
-Constraint Name: #### A masked pattern was here ####
-Column Name:tz1 Default Value:cast('2016-01-03 12:26:34 America/Los_Angeles' as timestamp with local time zone)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b1 Default Value:cast ('true' as boolean)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:i Default Value:cast(cast(4 as double) as int)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b2 Default Value:cast (5.67 as int)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:j Default Value:cast(current_timestamp() as varchar(50))
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b3 Default Value:cast (45 as tinyint)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:k Default Value:cast(cast(current_user() as varchar(50)) as string)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b4 Default Value:cast (45.4 as float)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b5 Default Value:cast (567 as bigint)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:b6 Default Value:cast (88 as smallint)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c2 Default Value:cast(5 as double)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c4 Default Value:cast(cast(cast('ab' as string) as varchar(2)) as char(2))
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:ts Default Value:cast('2016-01-01 12:01:01' as timestamp)
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:dc Default Value:cast(4.5 as decimal(8,2))
-
-PREHOOK: query: EXPLAIN INSERT INTO t11(c4) values('vi')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO t11(c4) values('vi')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct('vi')) (type: array<struct<col1:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: UDFToInteger(UDFToDouble(4)) (type: int), UDFToBoolean('true') (type: boolean), UDFToInteger(5.67) (type: int), UDFToByte(45) (type: tinyint), UDFToFloat(45.4) (type: float), UDFToLong(567) (type: bigint), UDFToShort(88) (type: smallint), CAST( CURRENT_TIMESTAMP() AS varchar(50)) (type: varchar(50)), UDFToString(CAST( CURRENT_USER() AS varchar(50))) (type: string), CAST( '2016-01-03 12:26:34 America/Los_Angeles' AS timestamp with local time zone) (type: timestamp with local time zone), CAST( '2016-01-01 12:01:01' AS TIMESTAMP) (type: timestamp), CAST( 4.5 AS decimal(8,2)) (type: decimal(8,2)), UDFToDouble(5) (type: double), CAST( col1 AS CHAR(2)) (type: char(2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 1 Data size: 522 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 522 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.t11
- Execution mode: llap
- LLAP IO: no inputs
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- 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
- name: default.t11
-
-PREHOOK: query: INSERT INTO t11(c4) values('vi')
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@t11
-POSTHOOK: query: INSERT INTO t11(c4) values('vi')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@t11
-POSTHOOK: Lineage: t11.b1 EXPRESSION []
-POSTHOOK: Lineage: t11.b2 EXPRESSION []
-POSTHOOK: Lineage: t11.b3 EXPRESSION []
-POSTHOOK: Lineage: t11.b4 EXPRESSION []
-POSTHOOK: Lineage: t11.b5 EXPRESSION []
-POSTHOOK: Lineage: t11.b6 EXPRESSION []
-POSTHOOK: Lineage: t11.c2 EXPRESSION []
-POSTHOOK: Lineage: t11.c4 SCRIPT []
-POSTHOOK: Lineage: t11.dc EXPRESSION []
-POSTHOOK: Lineage: t11.i EXPRESSION []
-POSTHOOK: Lineage: t11.j EXPRESSION []
-POSTHOOK: Lineage: t11.k EXPRESSION []
-POSTHOOK: Lineage: t11.ts EXPRESSION []
-POSTHOOK: Lineage: t11.tz1 EXPRESSION []
-PREHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t11
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t11
-#### A masked pattern was here ####
-2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi
-PREHOOK: query: EXPLAIN INSERT INTO t11(b1,c4) values(true,'ga')
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO t11(b1,c4) values(true,'ga')
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(true,'ga')) (type: array<struct<col1:boolean,col2:string>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: UDFToInteger(UDFToDouble(4)) (type: int), col1 (type: boolean), UDFToInteger(5.67) (type: int), UDFToByte(45) (type: tinyint), UDFToFloat(45.4) (type: float), UDFToLong(567) (type: bigint), UDFToShort(88) (type: smallint), CAST( CURRENT_TIMESTAMP() AS varchar(50)) (type: varchar(50)), UDFToString(CAST( CURRENT_USER() AS varchar(50))) (type: string), CAST( '2016-01-03 12:26:34 America/Los_Angeles' AS timestamp with local time zone) (type: timestamp with local time zone), CAST( '2016-01-01 12:01:01' AS TIMESTAMP) (type: timestamp), CAST( 4.5 AS decimal(8,2)) (type: decimal(8,2)), UDFToDouble(5) (type: double), CAST( col2 AS CHAR(2)) (type: char(2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 1 Data size: 519 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 519 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.t11
- Execution mode: llap
- LLAP IO: no inputs
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- 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
- name: default.t11
-
-PREHOOK: query: INSERT INTO t11(c4) values('vi')
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@t11
-POSTHOOK: query: INSERT INTO t11(c4) values('vi')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@t11
-POSTHOOK: Lineage: t11.b1 EXPRESSION []
-POSTHOOK: Lineage: t11.b2 EXPRESSION []
-POSTHOOK: Lineage: t11.b3 EXPRESSION []
-POSTHOOK: Lineage: t11.b4 EXPRESSION []
-POSTHOOK: Lineage: t11.b5 EXPRESSION []
-POSTHOOK: Lineage: t11.b6 EXPRESSION []
-POSTHOOK: Lineage: t11.c2 EXPRESSION []
-POSTHOOK: Lineage: t11.c4 SCRIPT []
-POSTHOOK: Lineage: t11.dc EXPRESSION []
-POSTHOOK: Lineage: t11.i EXPRESSION []
-POSTHOOK: Lineage: t11.j EXPRESSION []
-POSTHOOK: Lineage: t11.k EXPRESSION []
-POSTHOOK: Lineage: t11.ts EXPRESSION []
-POSTHOOK: Lineage: t11.tz1 EXPRESSION []
-PREHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t11
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT ts, tz1, dc, b1,b2,b3,b4,b5,b6,j=cast(current_timestamp() as varchar(50)), k=cast(current_user() as string), c2, c4 from t11
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t11
-#### A masked pattern was here ####
-2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi
-2016-01-01 12:01:01 2016-01-03 12:26:34.0 US/Pacific 4.50 true 5 45 45.4 567 88 false true 5.0 vi
-PREHOOK: query: DROP TABLE t11
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@t11
-PREHOOK: Output: default@t11
-POSTHOOK: query: DROP TABLE t11
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@t11
-POSTHOOK: Output: default@t11
-PREHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647,
- d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89)
- clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@numericDataType
-POSTHOOK: query: CREATE TABLE numericDataType(a TINYINT CONSTRAINT tinyint_constraint DEFAULT 127Y ENABLE, b SMALLINT DEFAULT 32767S, c INT DEFAULT 2147483647,
- d BIGINT DEFAULT 9223372036854775807L, e DOUBLE DEFAULT 3.4E38, f DECIMAL(9,2) DEFAULT 1234567.89)
- clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@numericDataType
-PREHOOK: query: ALTER TABLE numericDataType DROP CONSTRAINT tinyint_constraint
-PREHOOK: type: ALTERTABLE_DROPCONSTRAINT
-POSTHOOK: query: ALTER TABLE numericDataType DROP CONSTRAINT tinyint_constraint
-POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT
-PREHOOK: query: DESC FORMATTED numericDataType
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@numericdatatype
-POSTHOOK: query: DESC FORMATTED numericDataType
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@numericdatatype
-# col_name data_type comment
-a tinyint
-b smallint
-c int
-d bigint
-e double
-f decimal(9,2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [b]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Default Constraints
-Table: default.numericdatatype
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:32767S
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:2147483647
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:9223372036854775807L
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:f Default Value:1234567.89
-
-PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(456)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(456)) (type: array<struct<col1:int>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: null (type: tinyint), col1 (type: int), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: UDFToShort(_col1) (type: smallint)
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: tinyint), _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: tinyint), UDFToShort(VALUE._col1) (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO numericDataType(b) values(456)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: INSERT INTO numericDataType(b) values(456)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@numericdatatype
-POSTHOOK: Lineage: numericdatatype.a SIMPLE []
-POSTHOOK: Lineage: numericdatatype.b SCRIPT []
-POSTHOOK: Lineage: numericdatatype.c SIMPLE []
-POSTHOOK: Lineage: numericdatatype.d SIMPLE []
-POSTHOOK: Lineage: numericdatatype.e SIMPLE []
-POSTHOOK: Lineage: numericdatatype.f SIMPLE []
-PREHOOK: query: SELECT * from numericDataType
-PREHOOK: type: QUERY
-PREHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * from numericDataType
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89
-PREHOOK: query: ALTER TABLE numericDataType ADD CONSTRAINT uk1 UNIQUE(a,b) DISABLE NOVALIDATE
-PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
-POSTHOOK: query: ALTER TABLE numericDataType ADD CONSTRAINT uk1 UNIQUE(a,b) DISABLE NOVALIDATE
-POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT
-PREHOOK: query: DESC FORMATTED numericDataType
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@numericdatatype
-POSTHOOK: query: DESC FORMATTED numericDataType
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@numericdatatype
-# col_name data_type comment
-a tinyint
-b smallint
-c int
-d bigint
-e double
-f decimal(9,2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- numFiles 1
- totalSize 1063
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [b]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Unique Constraints
-Table: default.numericdatatype
-Constraint Name: uk1
-Column Name:a Key Sequence:1
-Column Name:b Key Sequence:2
-
-
-# Default Constraints
-Table: default.numericdatatype
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:32767S
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:2147483647
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:9223372036854775807L
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:f Default Value:1234567.89
-
-PREHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(56)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(b) values(56)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(56)) (type: array<struct<col1:int>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: null (type: tinyint), col1 (type: int), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), 1234567.89 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: UDFToShort(_col1) (type: smallint)
- Statistics: Num rows: 1 Data size: 136 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: tinyint), _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(9,2))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: tinyint), UDFToShort(VALUE._col1) (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), VALUE._col5 (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
-PREHOOK: query: INSERT INTO numericDataType(b) values(456)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: INSERT INTO numericDataType(b) values(456)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@numericdatatype
-POSTHOOK: Lineage: numericdatatype.a SIMPLE []
-POSTHOOK: Lineage: numericdatatype.b SCRIPT []
-POSTHOOK: Lineage: numericdatatype.c SIMPLE []
-POSTHOOK: Lineage: numericdatatype.d SIMPLE []
-POSTHOOK: Lineage: numericdatatype.e SIMPLE []
-POSTHOOK: Lineage: numericdatatype.f SIMPLE []
-PREHOOK: query: SELECT * from numericDataType
-PREHOOK: type: QUERY
-PREHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * from numericDataType
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@numericdatatype
-#### A masked pattern was here ####
-NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89
-NULL 456 2147483647 9223372036854775807 3.4E38 1234567.89
-PREHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT second_null_constraint NOT NULL ENABLE
-PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@numericdatatype
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT second_null_constraint NOT NULL ENABLE
-POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@numericdatatype
-POSTHOOK: Output: default@numericdatatype
-PREHOOK: query: DESC FORMATTED numericDataType
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@numericdatatype
-POSTHOOK: query: DESC FORMATTED numericDataType
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@numericdatatype
-# col_name data_type comment
-a tinyint
-b smallint
-c int
-d bigint
-e double
-f decimal(9,2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
-#### A masked pattern was here ####
- numFiles 2
- totalSize 2127
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [b]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Unique Constraints
-Table: default.numericdatatype
-Constraint Name: uk1
-Column Name:a Key Sequence:1
-Column Name:b Key Sequence:2
-
-
-# Not Null Constraints
-Table: default.numericdatatype
-Constraint Name: second_null_constraint
-Column Name: a
-
-
-# Default Constraints
-Table: default.numericdatatype
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:32767S
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:2147483647
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:9223372036854775807L
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:f Default Value:1234567.89
-
-PREHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT default_constraint DEFAULT 127Y ENABLE
-PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@numericdatatype
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: ALTER TABLE numericDataType CHANGE a a TINYINT CONSTRAINT default_constraint DEFAULT 127Y ENABLE
-POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@numericdatatype
-POSTHOOK: Output: default@numericdatatype
-PREHOOK: query: DESC FORMATTED numericDataType
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@numericdatatype
-POSTHOOK: query: DESC FORMATTED numericDataType
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@numericdatatype
-# col_name data_type comment
-a tinyint
-b smallint
-c int
-d bigint
-e double
-f decimal(9,2)
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
-#### A masked pattern was here ####
- numFiles 2
- totalSize 2127
- transactional true
- transactional_properties default
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: 2
-Bucket Columns: [b]
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-
-# Constraints
-
-# Unique Constraints
-Table: default.numericdatatype
-Constraint Name: uk1
-Column Name:a Key Sequence:1
-Column Name:b Key Sequence:2
-
-
-# Not Null Constraints
-Table: default.numericdatatype
-Constraint Name: second_null_constraint
-Column Name: a
-
-
-# Default Constraints
-Table: default.numericdatatype
-Constraint Name: #### A masked pattern was here ####
-Column Name:b Default Value:32767S
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:c Default Value:2147483647
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:d Default Value:9223372036854775807L
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:e Default Value:3.4E38
-
-Constraint Name: #### A masked pattern was here ####
-Column Name:f Default Value:1234567.89
-
-Constraint Name: default_constraint
-Column Name:a Default Value:127Y
-
-PREHOOK: query: EXPLAIN INSERT INTO numericDataType(f) values(847.45)
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO numericDataType(f) values(847.45)
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: _dummy_table
- Row Limit Per Split: 1
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: array(const struct(847.45)) (type: array<struct<col1:decimal(5,2)>>)
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- UDTF Operator
- Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
- function name: inline
- Select Operator
- expressions: 127Y (type: tinyint), 32767S (type: smallint), 2147483647 (type: int), 9223372036854775807L (type: bigint), 3.4E38D (type: double), col1 (type: decimal(5,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE
- Filter Operator
- predicate: enforce_constraint(127Y is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Map-reduce partition columns: _col1 (type: smallint)
- Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: double), _col5 (type: decimal(5,2))
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 2
- Execution mode: llap
- Reduce Operator Tree:
- Select Operator
- expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: double), CAST( VALUE._col5 AS decimal(9,2)) (type: decimal(9,2))
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: false
- table:
- input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
- output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
- serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: default.numericdatatype
- Write Type: INSERT
-
-PREHOOK: query: --plan should have both DEFAULT and NOT NULL
-INSERT INTO numericDataType(f) values(847.45)
-PREHOOK: type: QUERY
-PREHOOK: Input: _dummy_database@_dummy_table
-PREHOOK: Output: default@numericdatatype
-POSTHOOK: query: --plan should have both DEFAULT and NOT NULL
-INSERT INTO numericDataType(f) values(847.45)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: _dummy_database@_dummy_table
-POSTHOOK: Output: default@
<TRUNCATED>