随笔分类 - hive报错

hive 之only supports newline '\n' right now. Error encountered near token ''报错

摘要：only supports newline '\n' right now. Error encountered near token '' 意思是：仅支持‘\n’ 分隔符我写的分隔符方式 row format delimited fields terminated by '\001' collec 阅读全文

posted @ 2020-09-09 19:51 爱吃萝卜青菜阅读(1088) 评论(0) 推荐(0)

执行hive SQL时报错 AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?)

摘要：AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?) 错误原因这个错误是由于查询列后面的字段没有全部放在group by 后面（除聚阅读全文

posted @ 2020-04-16 10:06 爱吃萝卜青菜阅读(16958) 评论(0) 推荐(1)