@cortland I am able to acheive,please find my testcase abc.txt ==== "1","peter","He is Data enginer", "Senior Engineer" "2","Anee","Hadoop Engineer","Lead" "3","James","Data, Architect","Sr Architect" hdfs dfs -put abc.txt /user/hive/ create external table test_csv(num string ,name string ,work string ,designation string ) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' with serdeproperties ( "separatorChar" = ',' ,"quoteChar" = '"' ) STORED AS TEXTFILE; LOAD DATA INPATH '/user/hive/abc.txt' INTO TABLE test_csv; select * from test_csv +---------------+----------------+---------------------+-----------------------+ | test_csv.num | test_csv.name | test_csv.work | test_csv.designation | +---------------+----------------+---------------------+-----------------------+ | 1 | peter | He is Data enginer | Senior Engineer | | 2 | Anee | Hadoop Engineer | Lead | | 3 | James | Data, Architect | Sr Architect | | 1 | peter | He is Data enginer | Senior Engineer | | 2 | Anee | Hadoop Engineer | Lead | | 3 | James | Data, Architect | Sr Architect | +---------------+----------------+---------------------+-----------------------+ Please accept it as solution,if your queries are answered and the testcase works in your scenario.
... View more
