You have defined a parquet only table. It interprets your CSV file as parquet.
You can for instance define 2 tables:
* one external for the CSV file
* one table for the parquet file
Afterwards you select from the first table and insert in the second table.
> On 1. Mar 2018, at 08:31, Anubhav T
Hi i m trying to load data from a csv file into parquet in hive but got
this exception
hive> create table if not exists REGION( R_NAME string, R_REGIONKEY string,
R_COMMENT string ) stored as parquet;
OK
Time taken: 0.414 seconds
hive> load data local inpath
'file:///home/anubhav/Downloads/dbgen/r