Create table as select issue Unsupported type 'null_type' impala

[#1]

Hi  i having a issue while creating table as select from an another table.

CREATE TABLE <database>.table1 as

select

column1 ,

column 2,

NULL as column3

from 

<databse>.table2

;

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.

thanks,

[#2 · Accepted solution]

Hi Davood,

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;

Cheers, Lars