Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6913

Excessive error output

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.15.0
    • Component/s: None
    • Labels:

      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.

        Attachments

          Activity

            People

            • Assignee:
              arina Arina Ielchiieva
              Reporter:
              vitalii Vitalii Diravka
              Reviewer:
              Volodymyr Vysotskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: