About Neel_Sharma

Neel_Sharma · ‎08-05-2022

The issue is resolved by adding Stored as textfile in the table creation query. CREATE External TABLE GeoIP2_ISP_Blocks_IPv4 ( Client string, ID int, Number int, Name string, ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' Stored as textfile <---------------------- this new line needs to be added WITH SERDEPROPERTIES ( "separatorChar" = "\,", "quoteChar" = "\"" ) LOCATION 'hdfs:///user/hive/warehouse/tips/' tblproperties ("skip.header.line.count"="1"); Cloudera has changed the default file format from txt to parquet. So we need to specify this line for text files. Thanks @mszurap for the help.

Neel_Sharma · ‎08-01-2022

Hi, I am getting error when I am querying my table in impala editor. The simple query: select * from table GeoIP2_ISP_Blocks_IPv4; The error: The table creation query is give below: CREATE External TABLE GeoIP2_ISP_Blocks_IPv4 ( Client string, ID int, Number int, Name string, ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' WITH SERDEPROPERTIES ( "separatorChar" = "\,", "quoteChar" = "\"" ) LOCATION 'hdfs:///user/hive/warehouse/tips/' tblproperties ("skip.header.line.count"="1"); The same error is coming when I am creating external tables from tab delimited files. All this is happening after latest CDP Update. Please someone help me it would be really helpful.

Online	Offline
Last Visited	‎10-20-2022 09:18 AM

Member Since	‎08-01-2022 05:18 AM
Last Visited	‎10-20-2022 09:18 AM
Posts	2

Cloudera Community

Cloudera Community

Re: Error on Creating External Table from CSV in I...

Error on Creating External Table from CSV in Impal...