Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Not A Problem
-
None
-
None
-
None
Description
Currently, users just can write csv file with specified directory as follows:
INSERT OVERWRITE INTO LOCATION '/dir/subdir' SELECT l_orderkey, l_quantity FROM lineitem;
In above case, the output file has made by default csv file parameters. So, users can't use another field delimiter and compression options.
Thus, we need to support that users can choice their table parameters as follows:
INSERT OVERWRITE INTO LOCATION '/dir/subdir' USING csv WITH ('csvfile.delimiter'='\u001','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec') SELECT l_orderkey, l_quantity FROM lineitem;