Create table as select issue Unsupported type 'null_type' impala

Davood — Fri, 16 Sep 2022 12:37:32 GMT

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,

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

Lars Volker — Mon, 11 Dec 2017 04:26:18 GMT

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

question Create table as select issue Unsupported type 'null_type' impala in Archives of Support Questions (Read Only)

Create table as select issue Unsupported type 'null_type' impala

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