Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Generating multiple files in Impala exporting

Generating multiple files in Impala exporting

New Contributor

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 ;