A couple of JIRA cases have been logged to support operators that, in my opinion, would be
better left out of Drill. (Or enabled only for compatibility with hive-in-its-crazier-years
or with mysql-in-its-crazier-years or postgres-in-its-crazier-years.)
https://issues.apache.org/jira/browse/DRILL-497 is for "!=" operator (synonym of "<>")
https://issues.apache.org/jira/browse/DRILL-777 is for "%" operator (synonym for MOD)
Is there a published list of operators that you intend Drill to support?
Julian
|