taiyang-li opened a new issue, #7868:
URL: https://github.com/apache/incubator-gluten/issues/7868
### Description
``` sql
set spark.sql.planChangeLog.level = error;
set spark.gluten.enabled = false;
CREATE TABLE aj (
country STRING,
event STRUCT<time:BIGINT, lng:BIGINT, lat:BIGINT, net:STRING,
log_extra:MAP<STRING, STRING>, event_id:STRING, event_info:MAP<STRING,
STRING>>
)
USING orc;
INSERT INTO aj VALUES
('USA', named_struct('time', 1622547800, 'lng', -122, 'lat', 37, 'net',
'wifi', 'log_extra', map('key1', 'value1'), 'event_id', 'event1',
'event_info', map('tab_type', '5', 'action', '13'))),
('Canada', named_struct('time', 1622547801, 'lng', -79, 'lat', 43, 'net',
'4g', 'log_extra', map('key2', 'value2'), 'event_id', 'event2',
'event_info', map('tab_type', '4', 'action', '12')));
explain extended
SELECT * FROM (
SELECT
game_name,
CASE WHEN
event.event_info['tab_type'] IN (5) THEN '1' ELSE '0' END AS entrance
FROM aj
LATERAL VIEW explode(split(country, ', ')) game_name AS game_name
WHERE event.event_info['action'] IN (13)
) WHERE game_name = 'xxx';
```
--
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]
