Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎12-10-2017
Accepted Solution

Create table as select issue Unsupported type 'null_type' impala

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,

 

Cloudera Employee
Posts: 74
Registered: ‎12-07-2015

Re: Create table as select issue Unsupported type 'null_type' impala

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

Announcements