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

• 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: function kudu
• Target Version: Kudu_Impala
• Assignee: Dimitris Tsirogiannis
• Reporter: Mostafa Mokhtar
• Created: 27/Jul/16 03:30
• Updated: 10/Oct/16 17:56
• Resolved: 10/Oct/16 17:56

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