beliefer commented on issue #11980:
URL: https://github.com/apache/gluten/issues/11980#issuecomment-4396322092
@jinchengchenghh You can reproduce this issue with below SQL.
```
CREATE TABLE htmp1_wide (c1 DECIMAL(38, 18), c2 INT, c3 TIMESTAMP) STORED AS
ORC;
INSERT INTO htmp1_wide
SELECT cast(id AS decimal(38,18)),
id % 3,
cast(id % 9 AS TIMESTAMP)
FROM range(1, 101);
CREATE TABLE htmp1 (c1 DECIMAL(20, 0), c2 INT, c3 TIMESTAMP) STORED AS ORC
LOCATION 'hdfs://.../htmp1_wide';
CREATE TABLE htmp2_wide (c1 DECIMAL(38, 18), c2 INT, c3 TIMESTAMP) STORED AS
ORC;
INSERT INTO htmp2_wide
SELECT cast(id AS decimal(38,18)),
id % 3,
cast(id % 5 AS TIMESTAMP)
FROM range(1, 101);
CREATE TABLE htmp2 (c1 DECIMAL(20, 0), c2 INT, c3 TIMESTAMP) STORED AS ORC
LOCATION 'hdfs://.../htmp2_wide';
set spark.gluten.sql.columnar.forceShuffledHashJoin=false;
set spark.gluten.sql.columnar.shuffledHashJoin=false;
SELECT /*+ MERGE(htmp1) */ htmp1.c2 AS 1c2, htmp1.c3 AS 1c3, htmp2.c2 AS 2c2
FROM htmp1 JOIN htmp2 ON htmp1.c1 = htmp2.c1;
```
--
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]
