Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> export csv, use ',' as split


Copy link to this message
-
export csv, use ',' as split
hi here,
   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(
  username string,
  mobile string,
  id_type string,
  id_no string,
  email string,
  address string,
  validate_time string
) 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