jacky created SPARK-38695:
-----------------------------
Summary: ORC can not surport the dataType,such as char or varchar
Key: SPARK-38695
URL: https://issues.apache.org/jira/browse/SPARK-38695
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.2.1, 3.1.2
Reporter: jacky
When testing Spark performance with TPCDS，run some sql,such as:q1，I found this
error
!image-2022-03-30-15-39-02-557.png!
I used the sql to create table，such as
create table customer
stored as orc
as select * from tpdc_text.customer
CLUSTER BY c_customer_sk
create table store
stored as orc
as select * from tpdc_text.store
CLUSTER BY s_store_sk
create table date_dim
stored as orc
as select * from tpdc_text.date_dim;
create table store_returns
(
sr_return_time_sk bigint
, sr_item_sk bigint
, sr_customer_sk bigint
, sr_cdemo_sk bigint
, sr_hdemo_sk bigint
, sr_addr_sk bigint
, sr_store_sk bigint
, sr_reason_sk bigint
, sr_ticket_number bigint
, sr_return_quantity int
, sr_return_amt decimal(7,2)
, sr_return_tax decimal(7,2)
, sr_return_amt_inc_tax decimal(7,2)
, sr_fee decimal(7,2)
, sr_return_ship_cost decimal(7,2)
, sr_refunded_cash decimal(7,2)
, sr_reversed_charge decimal(7,2)
, sr_store_credit decimal(7,2)
, sr_net_loss decimal(7,2)
)
partitioned by (sr_returned_date_sk bigint)
stored as orc;
when，I changed this code，I can run succeed
!image-2022-03-30-14-58-32-823.png!
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
