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
