Support Questions
Find answers, ask questions, and share your expertise

Create table as select issue Unsupported type 'null_type' impala

New Contributor

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,

 

1 ACCEPTED SOLUTION

Expert Contributor

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

View solution in original post

1 REPLY 1

Expert Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.