> > would resulting in this exception. It's impala syntax ?
> > On 06/5/2018 21:54，Mike Labman wrote：
> > Just use column number in your group by.
> >
> > select datediff(day,now()) from test_table where day>='2018-06-01' group
> > by 1
This sql really worked, thanks a lot!
2018-06-06
skyyws
发件人：Fredy Wijaya
发送时间：2018-06-06 10:14
主题：Re: A question about AnalysisException
收件人："dev"
抄送：
It looks like a bug in Impala SQL rewrite. We've had quite a number of SQL
rewrite bugs lately. Try disabling the
instead of constants
> would resulting in this exception. It's impala syntax ?
> On 06/5/2018 21:54，Mike Labman wrote：
> Just use column number in your group by.
>
> select datediff(day,now()) from test_table where day>='2018-06-01' group
> by 1
>
>
y 1
-Original Message-
From: skyyws [mailto:sky...@163.com]
Sent: Tuesday, June 05, 2018 9:49 AM
To: dev
Subject: Re: A question about AnalysisException
Here is the corret result of the sql below:
select datediff(day,now()) from test_table where day>='2018-06-01&
Just use column number in your group by.
select datediff(day,now()) from test_table where day>='2018-06-01' group by 1
-Original Message-
From: skyyws [mailto:sky...@163.com]
Sent: Tuesday, June 05, 2018 9:49 AM
To: dev
Subject: Re: A question about AnalysisException
Here
Here is the corret result of the sql below:
select datediff(day,now()) from test_table where day>='2018-06-01' group by
datediff(day,now());
| datediff(day, now()) |
+--+
| -4 |
| 0|
| -3 |
| -1 |
| -2
