Hello, there is no such function DATEDIFF in the Calcite based SQL engine in Apache Ignite currently, and it can't be enabled by any property. But you can use alternatives like: (date1 - date2) MINUTES > INTERVAL 30 MINUTES TIMESTAMPDIFF(MINUTE, date1, date2) > 30
пн, 7 нояб. 2022 г. в 19:49, tore yang via user <[email protected]>: > 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 can I enable the "FUN" in Apache Ignite? > > > Tao >
