I have a doubt on writing contents of a table to a file using delimeters such as |   CREATE EXTERNAL TABLE additional_Variables ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/user/Data/additional_Variables' AS SELECT * FROM MYTABLE This is the SQL i use to create file. When i visit the directory to view the file generated. Instead of just one file , there is often two files generated where 1 of them is a larger file and the second one is smaller.   Is there any way to write content from a table to a single file. ... View more