[jira] [Commented] (HUDI-33) Introduce config to allow users to control case-sensitivity in column projections #431

["Raymond Xu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HUDI-33?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17503472#comment-17503472 ] 

Raymond Xu commented on HUDI-33:
--------------------------------

[~vinoth] can I confirm the requirement:

[~biyan900116@gmail.com] and I discussed this, we can add a hudi config say `hoodie.sql.caseSensitive`, which is always dominated by `spark.sql.caseSensitive` if user sets it. And the config only affects when users run Spark SQL, no impact on Hive/Impala which are case-insensitive.

> Introduce config to allow users to control case-sensitivity in column projections #431
> --------------------------------------------------------------------------------------
>
>                 Key: HUDI-33
>                 URL: https://issues.apache.org/jira/browse/HUDI-33
>             Project: Apache Hudi
>          Issue Type: New Feature
>          Components: spark-sql
>            Reporter: Vinoth Chandar
>            Assignee: Yann Byron
>            Priority: Blocker
>              Labels: user-support-issues
>             Fix For: 0.11.0
>
>
> {quote}Similar to "spark.sql.caseSensitive", Needed in this context -
> Avro & Presto field names seems to be case sensitive (support fields differing only in case)
> whereas Hive/Impala/SparkSQL(default) are case-insensitive. Spark allows this to be configurable
> using spark.sql.caseSensitive=true
> For a RT table setup with no delta-files (for a latest file-slice) -> we translate parquet schema to Avro. Here the field-name case is dependent on parquet schema. Hive (1.x/2.x/CDH) translate column projections to lower-cases.
> {quote}
> ref
> https://github.com/uber/hudi/issues/431



--
This message was sent by Atlassian Jira
(v8.20.1#820001)