I know this post was a long time ago, but does the script below add text qualifiers if a field contains one or more  '|'?   INSERT OVERWRITE DIRECTORY '/tmp/text-pipe' ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE SELECT * FROM textcomma; Thanks!  ... View more

@Sivakumar Mahalingam Notice "-rw-r--r--" which indicate that the supplied path is a File (Not a Directory) Thats the reason you got an error earlier like: hdfs://quickstart.cloudera:8020/etc/hive/data/weather is not a directory or unable to create one . You have the mentioned PATH as a "file" it should be directory. Try running the following command and then # hdfs dfs -ls /etc/hive/data . ... View more