apache / apache/hudi

Make primaryKey and other column configs case insensitive

Open
#16,606 1 comment 0 reactions 1 assignee Claimed by @yihua View on GitHub
area:sql from-jira priority:critical type:improvement
Dominant language
Java
Stars
6.2k
Forks
2.5k
Avg merge
2d 8h
Merged PRs (30d)
111

Description

The primaryKey and other configs should be case insensitive.

 

Test case to reproduce - 
test("Test primary key case sensitive") {
withTempDir { tmp =>val tableName = generateTableName // Create a partitioned table spark.sql( s""" |create table $tableName ( | id int, | name string, | price double, | ts long, | dt string |) using hudi | tblproperties (primaryKey = 'ID' | ) | partitioned by (dt) | location '${tmp.getCanonicalPath}'""".stripMargin)
spark.sql( s""" | insert into $tableName | select 1 as id, 'a1' as name, 10 as price, 1000 as ts, '2021-01-05' as dt""".stripMargin)
checkAnswer(s"select id, name, price, ts, dt from $tableName")( Seq(1, "a1", 10.0, 1000 , "2021-01-05")
)
}
}

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-8172
- Type: Improvement
- Fix version(s):
- 1.1.0

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.