Re: query about avatica odbc

2017-12-03 Thread Josh Elser
Hi Victor, An ODBC driver for Avatica would be a great addition to the project, but I am not aware of anyone who has volunteered to take on this development effort. On 12/1/17 9:03 PM, victor wrote: Hi, calcite development team: we now use calcite for some databases development , t

Re: "Streaming aggregation requires at least one monotonic expression"

2017-12-03 Thread Julian Hyde
If you change > AS "rowtime”, to > AS "rowtime2", is the behavior any different? I am concerned that the “rowtime” column is visible in the GROUP BY clause. (It shouldn’t be, but bugs happen.) > On Dec 3, 2017, at 3:04 PM, Christian Tzolov wrote: > > I have implemented a StreamingTable wi

Re: "Streaming aggregation requires at least one monotonic expression"

2017-12-03 Thread Christian Tzolov
a step further! Although, not documented ​it appears that the streamable table must implement the getStatistics() method even if it returns empty sets. Otherwise the ​m​ onotonicity ​ computation in ItentifierNamespace#getMonotonicity ​ ​ will always return ​ ​ SqlMonotonicity.NOT_MONOTONIC ​ cau

"Streaming aggregation requires at least one monotonic expression"

2017-12-03 Thread Christian Tzolov
I have implemented a StreamingTable with monotonic ​ ​ rowtime ​ ​ column: 1: jdbc:calcite:model=/Users/ctzolov/Dev/proj> !columns "BookMaster ​"​ +---+-++-+---+---+-+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TY