Support Questions

satya2yuva · ‎11-28-2016

Hi,

i would like to run the query LOAD DATA INPATH '/user/maria_dev/drivers.csv' OVERWRITE INTO TABLE temp_drivers;

But my hive default fileformat is ORC, Data is in .csv format.help.png

pgreiff · ‎11-29-2016

Satya, when you created the table temp_drivers, what storage format did you use?

In the tutorial that you linked, the create table statement was:

create table temp_drivers (col_value STRING);

If you you changed it to

create table temp_drivers (col_value STRING) stored as ORC;

Then you might consider deleting the table and creating it new.

If you did not define the 'stored as ORC' storage part in the statement then you might want to check your parameters in Hive: The default format is plain text files. TEXTFILE is the default file format, unless the configuration parameter hive.default.fileformat has a different setting.

View solution in original post

satya2yuva · ‎11-29-2016

Thank you very much, its working fine now.

Cloudera Community

Support Questions

CSV Query to run from hive.default.fileformat is ORC