How To: Query CSV

Problem Description:


Is there a way to query quoted data like



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


  • Avatar
    Jayson Minard

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

Powered by Zendesk