[DRILL-6913] Excessive error output

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.15.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Vitalii Diravka
• Reviewer: Vova Vysotskyi
• Created: 18/Dec/18 18:53
• Updated: 27/Sep/19 14:21
• Resolved: 20/Dec/18 22:15

Description

There are redundant and duplicate error messages in query outputs in case of some mistake in query syntax or in case of any other error from Calcite:

0: jdbc:drill:zk=local> select * from dfs.`tpch/nation.parquet`;
19:23:09.335 [23e6d301-9bf4-2d4d-69e4-335a3674fd53:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.sql.validate.SqlValidatorException: Object 'tpch/nation.parquet' not found within 'dfs'
19:23:09.336 [23e6d301-9bf4-2d4d-69e4-335a3674fd53:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Object 'tpch/nation.parquet' not found within 'dfs'
19:23:09.411 [23e6d301-9bf4-2d4d-69e4-335a3674fd53:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.sql.validate.SqlValidatorException: Object 'tpch/nation.parquet' not found within 'dfs'
19:23:09.411 [23e6d301-9bf4-2d4d-69e4-335a3674fd53:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Object 'tpch/nation.parquet' not found within 'dfs'
19:23:09.432 [Client-1] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.sql.validate.SqlValidatorException: Object 'tpch/nation.parquet' not found within 'dfs'
19:23:09.432 [Client-1] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Object 'tpch/nation.parquet' not found within 'dfs': Object 'tpch/nation.parquet' not found within 'dfs'
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Object 'tpch/nation.parquet' not found within 'dfs'


[Error Id: e3b6b9f6-1e8c-468f-954f-41b57defcf6a on vitalii-pc:31010] (state=,code=0)

0: jdbc:drill:zk=local> slect * from cp.`tpch/nation.parquet` limit 1;
20:40:27.783 [23e6c0e4-6dd7-2f72-12dc-abdb9f2f7634:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteException: Non-query expression encountered in illegal context
20:40:27.783 [23e6c0e4-6dd7-2f72-12dc-abdb9f2f7634:foreman] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: From line 1, column 1 to line 1, column 5: Non-query expression encountered in illegal context
20:40:27.787 [Client-1] ERROR o.a.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteException: Non-query expression encountered in illegal context
Error: PARSE ERROR: Non-query expression encountered in illegal context

SQL Query slect * from cp.`tpch/nation.parquet` limit 1
^


[Error Id: c1bf1800-6b70-420b-b95c-907d11889a6f on vitalii-pc:31010] (state=,code=0)
0: jdbc:drill:zk=local>

Errors from drill code are fine:

0: jdbc:drill:zk=local> select count(4,5) from cp.`tpch/nation.parquet` limit 1;
Error: SYSTEM ERROR: SchemaChangeException: Failure while materializing expression. 
Error in expression at index -1.  Error: Missing function implementation: [count(INT-REQUIRED, INT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.

Fragment 0:0

Please, refer to logs for more information.

[Error Id: de0abc5a-cda9-4ac7-b99f-58f0ef0c7a67 on vitalii-pc:31010] (state=,code=0)

In drill Web UI the output is fine for all above cases.

Issue Links

• links to: CALCITE-2463
• links to: GitHub Pull Request #1578