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

TPC-DS Q84 fails to run with "Could not find col: '' in the table schema"

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Works for Me
    • Affects Version/s: Impala 2.7.0
    • Fix Version/s: Kudu_Impala
    • Component/s: Backend
    • Labels:

      Description

      The query runs fine against Parquet but fails against a kudu backed table.

      Error

      Could not find col: '' in the table schema
      Could not find col: '' in the table schema
      Could not find col: '' in the table schema
      Could not find col: '' in the table schema
      Could not find col: '' in the table schema
      

      Query

      select 
          c_customer_id as customer_id,
          concat(c_last_name, ', ', c_first_name) as customername
      from
          customer,
          customer_address,
          customer_demographics,
          household_demographics,
          income_band,
          store_returns
      where
          ca_city = 'Deerfield'
              and c_current_addr_sk = ca_address_sk
              and ib_lower_bound >= 33614
              and ib_upper_bound <= 33614 + 50000
              and ib_income_band_sk = hd_income_band_sk
              and cd_demo_sk = c_current_cdemo_sk
              and hd_demo_sk = c_current_hdemo_sk
              and sr_cdemo_sk = cd_demo_sk
      order by c_customer_id
      limit 100
      

        Attachments

          Activity

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              mmokhtar Mostafa Mokhtar
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: