[
https://issues.apache.org/jira/browse/DRILL-6913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728354#comment-16728354
]
Anton Gozhiy commented on DRILL-6913:
-------------------------------------
Verified with Drill version 1.15.0-SNAPSHOT (commit
af3977a8e6ea2c66a585312bf64463a3d3bd9a6c)
Cases checked:
- the cases from the issue description
- verbose true/false
- multiline queries
- non-Calcite errors just in case
- embedded/distributed mode
> Excessive error output
> ----------------------
>
> Key: DRILL-6913
> URL: https://issues.apache.org/jira/browse/DRILL-6913
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Vitalii Diravka
> Assignee: Arina Ielchiieva
> Priority: Blocker
> Labels: ready-to-commit
> Fix For: 1.15.0
>
>
> 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:
> {code:java}
> 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)
> {code}
> {code:java}
> 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>
> {code}
> Errors from drill code are fine:
> {code}
> 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)
> {code}
> In drill Web UI the output is fine for all above cases.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
