comphead commented on issue #19075:
URL: https://github.com/apache/datafusion/issues/19075#issuecomment-3608545321
To reproduce
```
DataFusion CLI v51.0.0
> -- Script to register TPC-DS parquet tables
-- Run this script in datafusion-cli to register all TPC-DS tables
-- Usage: datafusion-cli -f register_tpcds_tables.sql
CREATE EXTERNAL TABLE call_center
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/call_center.parquet';
CREATE EXTERNAL TABLE catalog_page
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/catalog_page.parquet';
CREATE EXTERNAL TABLE catalog_returns
STORED AS PARQUET
LOCATION
'../datafusion-benchmarks/tpcds/data_parquet/catalog_returns.parquet';
CREATE EXTERNAL TABLE catalog_sales
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/catalog_sales.parquet';
CREATE EXTERNAL TABLE customer_address
STORED AS PARQUET
LOCATION
'../datafusion-benchmarks/tpcds/data_parquet/customer_address.parquet';
CREATE EXTERNAL TABLE customer_demographics
STORED AS PARQUET
LOCATION
'../datafusion-benchmarks/tpcds/data_parquet/customer_demographics.parquet';
CREATE EXTERNAL TABLE customer
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/customer.parquet';
CREATE EXTERNAL TABLE date_dim
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/date_dim.parquet';
CREATE EXTERNAL TABLE household_demographics
STORED AS PARQUET
LOCATION
'../datafusion-benchmarks/tpcds/data_parquet/household_demographics.parquet';
CREATE EXTERNAL TABLE income_band
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/income_band.parquet';
CREATE EXTERNAL TABLE inventory
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/inventory.parquet';
CREATE EXTERNAL TABLE item
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/item.parquet';
CREATE EXTERNAL TABLE promotion
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/promotion.parquet';
CREATE EXTERNAL TABLE reason
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/reason.parquet';
CREATE EXTERNAL TABLE ship_mode
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/ship_mode.parquet';
CREATE EXTERNAL TABLE store_returns
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/store_returns.parquet';
CREATE EXTERNAL TABLE store_sales
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/store_sales.parquet';
CREATE EXTERNAL TABLE store
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/store.parquet';
CREATE EXTERNAL TABLE time_dim
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/time_dim.parquet';
CREATE EXTERNAL TABLE warehouse
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/warehouse.parquet';
CREATE EXTERNAL TABLE web_page
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/web_page.parquet';
CREATE EXTERNAL TABLE web_returns
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/web_returns.parquet';
CREATE EXTERNAL TABLE web_sales
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/web_sales.parquet';
CREATE EXTERNAL TABLE web_site
STORED AS PARQUET
LOCATION '../datafusion-benchmarks/tpcds/data_parquet/web_site.parquet';
0 row(s) fetched.
Elapsed 0.029 seconds.
0 row(s) fetched.
Elapsed 0.004 seconds.
0 row(s) fetched.
Elapsed 0.019 seconds.
0 row(s) fetched.
Elapsed 0.036 seconds.
0 row(s) fetched.
Elapsed 0.009 seconds.
0 row(s) fetched.
Elapsed 0.007 seconds.
0 row(s) fetched.
Elapsed 0.011 seconds.
0 row(s) fetched.
Elapsed 0.003 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.001 seconds.
0 row(s) fetched.
Elapsed 0.012 seconds.
0 row(s) fetched.
Elapsed 0.003 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.001 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.013 seconds.
0 row(s) fetched.
Elapsed 0.033 seconds.
0 row(s) fetched.
Elapsed 0.003 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.002 seconds.
0 row(s) fetched.
Elapsed 0.013 seconds.
0 row(s) fetched.
Elapsed 0.024 seconds.
0 row(s) fetched.
Elapsed 0.003 seconds.
> -- SQLBench-DS query 13 derived from TPC-DS query 13 under the terms of
the TPC Fair Use Policy.
-- TPC-DS queries are Copyright 2021 Transaction Processing Performance
Council.
-- This query was generated at scale factor 1.
select avg(ss_quantity)
,avg(ss_ext_sales_price)
,avg(ss_ext_wholesale_cost)
,sum(ss_ext_wholesale_cost)
from store_sales
,store
,customer_demographics
,household_demographics
,customer_address
,date_dim
where s_store_sk = ss_store_sk
and ss_sold_date_sk = d_date_sk and d_year = 2001
and((ss_hdemo_sk=hd_demo_sk
and cd_demo_sk = ss_cdemo_sk
and cd_marital_status = 'U'
and cd_education_status = '4 yr Degree'
and ss_sales_price between 100.00 and 150.00
and hd_dep_count = 3
)or
(ss_hdemo_sk=hd_demo_sk
and cd_demo_sk = ss_cdemo_sk
and cd_marital_status = 'S'
and cd_education_status = 'Unknown'
and ss_sales_price between 50.00 and 100.00
and hd_dep_count = 1
) or
(ss_hdemo_sk=hd_demo_sk
and cd_demo_sk = ss_cdemo_sk
and cd_marital_status = 'D'
and cd_education_status = '2 yr Degree'
and ss_sales_price between 150.00 and 200.00
and hd_dep_count = 1
))
and((ss_addr_sk = ca_address_sk
and ca_country = 'United States'
and ca_state in ('CO', 'MI', 'MN')
and ss_net_profit between 100 and 200
) or
(ss_addr_sk = ca_address_sk
and ca_country = 'United States'
and ca_state in ('NC', 'NY', 'TX')
and ss_net_profit between 150 and 300
) or
(ss_addr_sk = ca_address_sk
and ca_country = 'United States'
and ca_state in ('CA', 'NE', 'TN')
and ss_net_profit between 50 and 250
))
;
thread 'main' (115968842) panicked at
datafusion/physical-expr/src/projection.rs:374:22:
Expected column reference in projection
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
