@drgenious    You can use set hive.merge.tezfiles=true; to fix merge file issue ... View more

AFAIK the table location should be set at the time of Creation.   You can set files in a different location.   You can use  ALTER TABLE jsont1 SET LOCATION "hdfs://mycluster:8020/jsam/j1"; to change the location and need to move the files manually from old location to new location. ... View more

@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

@Mas_Jamie    CDS table is for Column Descriptors. CD stands for column descriptor. It is used to decouple columns from tables/partitions to reduce storage needs. tables/partitions are almost 1-1 map to these descriptors… but a table may have more than one Column Descriptor in the case of schema evolution! ... View more