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

Excessive error output

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.15.0
    • 1.15.0
    • None

    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            arina Arina Ielchiieva
            vitalii Vitalii Diravka
            Vova Vysotskyi Vova Vysotskyi
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment