How can I specify a column of java object in my sql select list after switching to calcite

2022-11-10 Thread tore yang via user
My cache has a column of type java map, the column name is "mymap". when I send a query "select id,mymap from mytable", it complains "Error: Failed to parse the query. (state=4200,code=1001). but when I run the query "select * from mytable", the column mymap returns perfectly. this wasn't a prob

How to enable "FUN" for Calcite in Apache Ignite

2022-11-07 Thread tore yang via user
I have some built in operator in my query which can only be recognized when CalciteConnectionProperty.FUN is set, for instance "select * from mycache where DATEDIFF("Minute",date1,date2)> 30". The function "DATEDIFF" caused an error "No match found for function signuature "DATEDIFF()" How ca

Can Apache Ignite 2.14.0 work without H2?

2022-11-03 Thread tore yang via user
I found this sentence in the 2.14.0 release note: Calcite-based SQL engine is now independent of H2-based SQL engine and doesn't require 'ignite-indexing' module and H2 to be in classpath anymore. However when I start a simplest Ignite object, it gives error saying class not found for org.h2.v