12-10-2017 04:12 PM
Hi i having a issue while creating table as select from an another table.
CREATE TABLE <database>.table1 as
NULL as column3
it is throwing below err
Unsupported type 'null_type' in column 'column3' of table 'table2'
CAUSED BY: TableLoadingException: Unsupported type 'null_type' in column 'column3' of table 'table2'
can anyone help me here.
12-10-2017 08:26 PM
Impala needs a column type for column3 and NULL does not allow the planner to infer the type. Using a cast to specify the type will work: create table v as select i, cast(null as int) as j from t;