all distinct aggregate functions need to have the same set of parameters

ゝ一纸荒年。 2023-07-04 04:44 76阅读 0赞

I got the following error in my Impala query:

  1. select 
  2.    upload_key, 
  3.    max(my_timestamp) as upload_time, 
  4.    max(color_key) as max_color_fk, 
  5.    count(distinct color_key) as color_count, 
  6.    count(distinct id) as toy_count 
  7. from upload_table 
  8. group by upload_key

and got the error:

AnalysisException: all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT color_key); deviating function: count(DISTINCT id)

I am not sure why I got this error. What I did was for each group (grouped by upload_key), I tried to compute how many distinct id as well as how many distinct color_key.
Does any one have any idea

  1. --错误消息表明DISTINCT只允许在一个列[组合]上使用，但是您尝试使用两个列，即color_key＆id。
  2. -- 解决方法是先两个Select一下，然后再join起来。
  3. select
  4.    t1.upload_key,
  5.    t1.u

发表评论

表情：
评论列表 （有 0 条评论，76人围观）

还没有评论，来说两句吧...

相关阅读