calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Milinda Pathirage <mpath...@umail.iu.edu>
Subject Re: time to hour converison
Date Sat, 07 Mar 2015 03:59:02 GMT
Hi Julian,

I found the issue. It was due to the missing getStatistic implementaiton in
the Table returned from my table factory.

Thanks
Milinda

On Fri, Mar 6, 2015 at 5:08 PM, Milinda Pathirage <mpathira@umail.iu.edu>
wrote:

> Hi Julian,
>
> Look like error was due to an old jar. Query went through parsing after
> cleaning and rebuilding Calcite. But I am still getting
>
> "Streaming aggregation requires at least one monotonic expression in GROUP
> BY clause".
>
> Most probably this should be due to incompatibilities in my query planner
> code and new changes to 'chi' branch. I'll debug and see whats going on.
>
> Thanks for the help.
>
> Milinda
>
> On Fri, Mar 6, 2015 at 3:33 PM, Julian Hyde <julianhyde@gmail.com> wrote:
>
>> We support “FLOOR(rowtime TO HOUR)”. The “TO” is part of the syntax of
>> the FLOOR function, just as “AS” is part of the cast syntax “CAST(1.5 AS
>> DOUBLE)”.
>>
>> And we support the CEIL function: "CEIL(rowtime TO DAY)”.
>>
>> What query did you try? Did you re-generate the parser (“mvn clean”)?
>>
>> Julian
>>
>>
>> On Mar 6, 2015, at 12:28 PM, Milinda Pathirage <mpathira@umail.iu.edu>
>> wrote:
>>
>> > Hi Julian,
>> >
>> > Is expressions like 'rowtime TO HOUR' supported in 'chi' branch. I am
>> > getting a parser error when I tried a sample query from
>> > https://github.com/julianhyde/incubator-calcite/blob/chi/doc/STREAM.md
>> with
>> > latest build from 'chi' branch.
>> >
>> > Thanks
>> > Milinda
>> >
>> >
>> > --
>> > Milinda Pathirage
>> >
>> > PhD Student | Research Assistant
>> > School of Informatics and Computing | Data to Insight Center
>> > Indiana University
>> >
>> > twitter: milindalakmal
>> > skype: milinda.pathirage
>> > blog: http://milinda.pathirage.org
>>
>>
>
>
> --
> Milinda Pathirage
>
> PhD Student | Research Assistant
> School of Informatics and Computing | Data to Insight Center
> Indiana University
>
> twitter: milindalakmal
> skype: milinda.pathirage
> blog: http://milinda.pathirage.org
>



-- 
Milinda Pathirage

PhD Student | Research Assistant
School of Informatics and Computing | Data to Insight Center
Indiana University

twitter: milindalakmal
skype: milinda.pathirage
blog: http://milinda.pathirage.org

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message