-export csv, use ',' as split
kentkong_work 2013-07-10, 04:48
I create a table like this and put a lot data into it.
then I export query result into csv file like this:
hive -e myquery >> result.csv
but the csv uses tab as split.
how to make hive use ','? thanks!
CREATE TABLE if not exists upload_users(
) partitioned by (fileid string)
row format delimited fields terminated by "\,";
Sanjay Subramanian 2013-07-10, 15:01
Navis류승우 2013-07-11, 00:15
Nitin Pawar 2013-07-10, 07:07