做接口平台,将 hive sql放在shell里,用
hive -e "'
select xxx, concat_ws(",",collect_set(字段)) 字段 from tablexxx;
"
报 FAILED: ParseException line cannot recognize input near ',' ',' 'collect_set' in function specification
处理方式如下:
1 将","修改成 ','
hive -e "'
select xxx, concat_ws(',',collect_set(字段)) 字段 from tablexxx;
"
2 将上面sql原封不动的帖到 xxx.hql中,后用
hive -f xxx.hql 执行