Khurram Faraaz created DRILL-5003: ------------------------------------- Summary: need a better error message Key: DRILL-5003 URL: https://issues.apache.org/jira/browse/DRILL-5003 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Affects Versions: 1.9.0 Reporter: Khurram Faraaz Priority: Minor
We need a better error message, Drill 1.9.0 returns an AssertionError. {noformat} 0: jdbc:drill:schema=dfs.tmp> SELECT * . . . . . . . . . . . . . . > FROM ( . . . . . . . . . . . . . . > select * from `t_alltype.parquet` t1, `t_alltype.parquet` t2 . . . . . . . . . . . . . . > WHERE EXISTS(t1.c4 = t2.c4) OR (t1.c4 IS NULL AND t2.c4 IS NULL) . . . . . . . . . . . . . . > ); Error: SYSTEM ERROR: AssertionError: Internal error: not a query: `t1`.`c4` = `t2`.`c4` [Error Id: 91e7af43-27a7-4577-802a-643705aeaf4f on centos-01.qa.lab:31010] (state=,code=0) {noformat} {noformat} 0: jdbc:drill:schema=dfs.tmp> SELECT * . . . . . . . . . . . . . . > FROM ( . . . . . . . . . . . . . . > select * from `t_alltype.parquet` t1, `t_alltype.parquet` t2 . . . . . . . . . . . . . . > WHERE EXISTS(t1.c4 = t2.c4 OR (t1.c4 IS NULL AND t2.c4 IS NULL)) . . . . . . . . . . . . . . > ); Error: SYSTEM ERROR: AssertionError: Internal error: not a query: `t1`.`c4` = `t2`.`c4` OR `t1`.`c4` IS NULL AND `t2`.`c4` IS NULL {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)