[
https://issues.apache.org/jira/browse/KYLIN-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17928290#comment-17928290
]
Guoliang Sun commented on KYLIN-6021:
-------------------------------------
Add the configuration
`kylin.storage.columnar.spark-conf.spark.gluten.sql.columnar.backend.ch.runtime_settings.use_excel_serialization=true`.
> [Gluten] Gluten query on Hive external tables in CSV format throws an error
> ---------------------------------------------------------------------------
>
> Key: KYLIN-6021
> URL: https://issues.apache.org/jira/browse/KYLIN-6021
> Project: Kylin
> Issue Type: Improvement
> Affects Versions: 5.0.0
> Reporter: Guoliang Sun
> Priority: Major
> Attachments: image-2025-02-19-14-55-57-996.png
>
>
> SQL
> {code:java}
> SELECT CASE c_name WHEN 'a' THEN 'aa' WHEN 'b' THEN 'bb' ELSE c_name END,
> CASE c_name WHEN c_name = 'a' THEN 'aa' WHEN c_name = 'b' THEN 'bb' ELSE
> c_name END, COALESCE(NULL, c_name), NULLIF(1, 1) FROM SSB_QUARD.CUSTOMER AS
> Conditional_Functions {code}
> Exception
> !image-2025-02-19-14-55-57-996.png|width=415,height=298!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
