Re: Errors when attempting to use timestamp-millis fields with QueryRecord

2019-03-08 Thread Edward George
Hi Koji, Thanks for the information. Ed On Fri, 8 Mar 2019 at 02:03 Koji Kawamura wrote: > Hello, > > I believe this is a known issue. Unfortunately, querying against > timestamp column is not supported. > https://issues.apache.org/jira/browse/NIFI-5888 > > I'm working on fixing this at

Re: Errors when attempting to use timestamp-millis fields with QueryRecord

2019-03-07 Thread Koji Kawamura
Hello, I believe this is a known issue. Unfortunately, querying against timestamp column is not supported. https://issues.apache.org/jira/browse/NIFI-5888 I'm working on fixing this at Calcite project, the sql execution engine underneath QueryRecord.

Errors when attempting to use timestamp-millis fields with QueryRecord

2019-03-07 Thread Edward George
I have some input avro with some fields using the timestamp-millis logicalType. I've been attempting to use them with QueryRecord to filter, or otherwise operate on the fields, using timestamp operations and I get errors produced. For instance the following SQL queries: SELECT * FROM FLOWFILE