Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5474

Adding a trivial subquery turns error into warning

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.9.0
    • Fix Version/s: Impala 3.2.0
    • Component/s: Backend
    • Labels:
      None
    • Epic Color:
      ghx-label-1

      Description

      This query without a subquery results in an error, which is expected.

      [localhost:21000] > set abort_on_error=1;
      ABORT_ON_ERROR set to 1
      [localhost:21000] > select id from functional_parquet.bad_column_metadata t;
      Query: select id from functional_parquet.bad_column_metadata t
      Query submitted at: 2017-06-08 15:30:44 (Coordinator: http://lv-desktop:25000)
      Query progress can be monitored at: http://lv-desktop:25000/query_plan?query_id=44e98719ba4c073:dec9e4d00000000
      ERROR: Column metadata states there are 11 values, but read 10 values from column id. file=hdfs://localhost:20500/test-warehouse/bad_column_metadata_parquet/bad_column_metadata.parquet
      

      Adding a trivial subquery turns the error into a warning:

      [localhost:21000] > set abort_on_error=1;
      ABORT_ON_ERROR set to 1
      [localhost:21000] > select id, cnt from functional_parquet.bad_column_metadata t, (select 1 cnt) u;
      Query: select id, cnt from functional_parquet.bad_column_metadata t, (select 1 cnt) u
      Query submitted at: 2017-06-08 15:34:57 (Coordinator: http://lv-desktop:25000)
      Query progress can be monitored at: http://lv-desktop:25000/query_plan?query_id=7a4eb13bf147d0f1:9156b2700000000
      WARNINGS: Column metadata states there are 11 values, but read 10 values from column id. file=hdfs://localhost:20500/test-warehouse/bad_column_metadata_parquet/bad_column_metadata.parquet
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                yzhangal Yongjun Zhang
                Reporter:
                lv Lars Volker
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: