I have an hdfs location
create external table webevent( col1 string , col2 string ..) ROW FORMAT DELIMITEDFIELDS TERMINATED BY '\001'LINES TERMINATED BY '\n'STORED AS TEXTFILELOCATION '/user/fms/log/';
not working .
also i want the hive table to have the partition keys as well on dt .
I guess you, at least, miss the part where you define the partition in the create table statement since your "log" folder seems to contains a partition on the field/key "part_key".
you need to alter table to add partitions in order to view data in partition folders.