如何指定命令行 Hive 查询应返回哪个分隔符

Question

我正在使用命令行Hive。例如hive -e "SELECT * FROM my_db.my_table;"

它当前返回看起来像制表符分隔值的内容。是否可以指定它应该使用哪个分隔符？例如，我可以让它返回管道分隔值吗？

Answer 1

  what i am done in my case, i fired a query like below.  
  INSERT OVERWRITE LOCAL DIRECTORY '/home/Desktop/test3'
  ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY ','
  select * from stud_02

  other solution would be 
   hive -e 'select *  from stud_01 limit 10' | sed 's/[[:space:]]+/,/g' >> /home/Desktop/test.csv