| 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: 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 40013 from org.apache.hadoop.hive.ql.ddl.DDLTask. Unable to alter table. The following columns have types incompatible with the existing columns in their respective positions : |
| a,b |