PREHOOK: query: SELECT * FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
238	val_238
PREHOOK: query: CREATE TABLE test_table123 (a INT, b MAP<STRING, STRING>) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_table123
POSTHOOK: query: CREATE TABLE test_table123 (a INT, b MAP<STRING, STRING>) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_table123
PREHOOK: query: INSERT OVERWRITE TABLE test_table123 PARTITION(ds="foo1") SELECT 1, MAP("a1", "b1") FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@test_table123@ds=foo1
POSTHOOK: query: INSERT OVERWRITE TABLE test_table123 PARTITION(ds="foo1") SELECT 1, MAP("a1", "b1") FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@test_table123@ds=foo1
POSTHOOK: Lineage: test_table123 PARTITION(ds=foo1).a SIMPLE []
POSTHOOK: Lineage: test_table123 PARTITION(ds=foo1).b EXPRESSION []
PREHOOK: query: SELECT * from test_table123 WHERE ds="foo1"
PREHOOK: type: QUERY
PREHOOK: Input: default@test_table123
PREHOOK: Input: default@test_table123@ds=foo1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * from test_table123 WHERE ds="foo1"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@test_table123
POSTHOOK: Input: default@test_table123@ds=foo1
#### A masked pattern was here ####
1	{"a1":"b1"}	foo1
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a BIGINT, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a BIGINT, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a DOUBLE, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a DOUBLE, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a BOOLEAN, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a BOOLEAN, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: ALTER TABLE test_table123 CHANGE COLUMN a a_new BOOLEAN
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
POSTHOOK: query: ALTER TABLE test_table123 CHANGE COLUMN a a_new BOOLEAN
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@test_table123
POSTHOOK: Output: default@test_table123
PREHOOK: query: -- All the above ALTERs will succeed since they are between compatible types.
-- The following ALTER will fail as MAP<STRING, STRING> and STRING are not
-- compatible.
ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@test_table123
PREHOOK: Output: default@test_table123
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. The following columns have types incompatible with the existing columns in their respective positions :
b