New Contributor
Posts: 7
Registered: ‎06-29-2015

Generating multiple files in Impala exporting

I am exporting Impala result set data to HDFS files, but its writting to multiple files please let me know how to write in single file in HDFS


for this i am using below command

CREATE EXTERNAL TABLE foo_1 row format delimited fields terminated by ',' STORED AS TEXTFILE  LOCATION '/exporttest/sample.txt' AS SELECT * FROM tab1 ;