alamb commented on code in PR #24803:
URL: https://github.com/apache/datafusion/pull/24803#discussion_r3894077002
##########
benchmarks/sql_benchmarks/tpcds/init/load.sql:
##########
@@ -1,47 +1,544 @@
-CREATE EXTERNAL TABLE call_center STORED AS PARQUET LOCATION
'${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/call_center.parquet';
+CREATE EXTERNAL TABLE call_center
+(
+ cc_call_center_sk INT,
+ cc_call_center_id VARCHAR,
+ cc_rec_start_date DATE,
+ cc_rec_end_date DATE,
+ cc_closed_date_sk INT,
+ cc_open_date_sk INT,
+ cc_name VARCHAR,
+ cc_class VARCHAR,
+ cc_employees INT,
+ cc_sq_ft INT,
+ cc_hours VARCHAR,
+ cc_manager VARCHAR,
+ cc_mkt_id INT,
+ cc_mkt_class VARCHAR,
+ cc_mkt_desc VARCHAR,
+ cc_market_manager VARCHAR,
+ cc_division INT,
+ cc_division_name VARCHAR,
+ cc_company INT,
+ cc_company_name VARCHAR,
+ cc_street_number VARCHAR,
+ cc_street_name VARCHAR,
+ cc_street_type VARCHAR,
+ cc_suite_number VARCHAR,
+ cc_city VARCHAR,
+ cc_county VARCHAR,
+ cc_state VARCHAR,
+ cc_zip VARCHAR,
+ cc_country VARCHAR,
+ cc_gmt_offset DECIMAL(5, 2),
+ cc_tax_percentage DECIMAL(5, 2),
+ PRIMARY KEY (cc_call_center_sk)
+) STORED AS PARQUET LOCATION
'${DATA_DIR:-data}/tpcds_sf${BENCH_SIZE:-1}/call_center.parquet';
Review Comment:
maybe worth a `--` sql comment to this effect
--
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]
