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 "\,";

   

Reply via email to