Re: [ANNOUNCE] New committer: Jiajun Xie
Congratulations, Jiajun! Best, Dan Zou > 2023年2月11日 10:06，Benchao Li 写道： > > Congratulations
Re: [ANNOUNCE] Benchao Li joins Calcite PMC
Congratulations Benchao! > 2023年1月27日 18:35，Ruben Q L 写道： > > Congratulations Benchao!
share connections
Can I share connections between several machines for Avacita?
About aggregation problem
hello， The problem is about use ［count（distinct（ID））］，distinct aggregation notsupported. Does the community have a plan to solve the problem，or have a temporary solution ? thank you
have LAST_DAY function?
Hi, What functions can be used to calculate the date of the end of the month in calcite? Like oracle LAST_DAY function apache_...@163.com
Re: Re: date function error
HI,
thinks .
Can you describe it clearer?
Local server(linux) timezone is correct.
ZONE="Asia/Shanghai"
apache_...@163.com
From: Josh Elser
Date: 2017-08-16 10:52
To: dev
Subject: Re: date function error
Hi,
This sounds like a timezone issue to me. Depending on how you wrote the
date, conversion from GMT into your local timezone can appear to
"change" a date.
Can you try setting the timeZone[1] parameter in the JDBC URL?
[1] https://calcite.apache.org/avatica/docs/client_reference.html#timeZone
On 8/15/17 10:24 PM, apache_...@163.com wrote:
> Hi,
>
> when i run sql by kyline GUI,Right result is 2011-02-28,but i got
> 2011-03-01,is bug?
>
> select cast('2011-03-31' as date) - INTERVAL '1' month from KYLIN_CAL_DT
>
>
>
>
> apache_...@163.com
>
date function error
Hi,
when i run sql by kyline GUI,Right result is 2011-02-28,but i got
2011-03-01,is bug?
select cast('2011-03-31' as date) - INTERVAL '1' month from KYLIN_CAL_DT
apache_...@163.com
sql run error
Hi,
Kylin2.0 on HDP2.5.3.
sql is not work.
select T7.F16 as F3,SUM(T7.F0) as F4
from (
select T17.QTR_ID as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0
from KYLIN_CAL_DT T17
inner join
(
select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE)
I_eceb82a4498247aeb911ba59f82148f0
from KYLIN_SALES where PART_DT in('2012-01-01', '2012-01-02', '2012-01-03')
group by KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID
) T8
on T8.PART_DT = T17.CAL_DT
) T7
group by T7.F16
but this sql can work
select T7.F16 as F3,SUM(T7.F0) as F4 from
(
select F16,F0 from
(
select T17.QTR_ID as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0
from KYLIN_CAL_DT T17
inner join
(
select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE)
I_eceb82a4498247aeb911ba59f82148f0
from KYLIN_SALES where PART_DT in('2012-01-01', '2012-01-02', '2012-01-03')
group by KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID
) T8
on T8.PART_DT = T17.CAL_DT
) T7
group by F16,F0
) T7
group by T7.F16
What's the reason?
apache_...@163.com
