I am trying to convert a HQL query(which is similar to SQL) into a Druid Query Object(started with GroupBy query). Assume a sample query as follows :
Considering a sample query "select a,b from table where date>=start_time and date<=end_time and a!=‘test’ "
I notice that there are selector and logical filters , as well as intervals in Druid which can be be used for where clauses. But couldn’t find an exact equivalent for predicates like >=, <=, between , in , not in …etc .
Can someone please let me know how to proceed from here? That will be really helpful.