Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Create table as select issue Unsupported type 'null_type' impala

avatar
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

avatar
Super Collaborator

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

avatar
Super Collaborator

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