How To: Query CSV

Problem Description:

---------------------------

Is there a way to query quoted data like

"id","name","age","address"

"1","abc","23","xyz"

from Hive?

Possible Workaround/ Resolution:

------------------------------------------

You could create an External table like:

create external table addtable

(

id string,

name string,

age string,

address string

)

row format serde 'com.bizo.hive.serde.csv.CSVSerde'

stored as textfile

location '<s3 folder location of data>';

 

Have more questions? Submit a request

Comments

  • Avatar
    Jayson Minard

    so that is available instead of:
    `org.apache.hadoop.hive.serde2.OpenCSVSerde` ?

Powered by Zendesk