Hi,

I am a newbie to Calcite and SQL. Recently, I am trying to develop a
calcite adapter for a new kind of data source. This data source has some
different operators compared to SQL. For example, in SQL, if we want to
find all rows that don't contain a certain keyword:

select * from table where value not like 'abc%'


In this new data source, the query string is:


select * from table where value <> 'abc%'



So in this data source, <> is a new operator.


As of now, I have to manually generate the where clause in the filter rule.
Does Calcite support adding new operator, so that it can automatically
translate? Thanks!


Sincerely,
Junwei Li

Reply via email to