[
https://issues.apache.org/jira/browse/KYLIN-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17928358#comment-17928358
]
Guoliang Sun commented on KYLIN-6046:
-------------------------------------
h3. Dev Design
When `kylin.source.name-case-sensitive-enabled` is set to false,
`HackSelectStarWithColumnACL` will first convert the parsed "database
name.table name" from the SQL to uppercase before retrieving the table
metadata.
When `kylin.source.name-case-sensitive-enabled` is set to true, the parsed
"database name.table name" from the SQL will remain unchanged.
> Table Not Found Due to Lowercase Table Names Enclosed in Double Quotes in SQL
> -----------------------------------------------------------------------------
>
> Key: KYLIN-6046
> URL: https://issues.apache.org/jira/browse/KYLIN-6046
> Project: Kylin
> Issue Type: Bug
> Affects Versions: 5.0.0
> Reporter: Guoliang Sun
> Priority: Major
>
> Identical SQL Works for ADMIN but Fails for Regular User with Error: [HIVE
> Exception] Failed to Parse Table: ssb.dates
> - Additional Observations:
> - If the double quotes are removed, the regular user can query
> successfully.
> - However, if the project setting
> `kylin.source.name-case-sensitive-enabled=true` (case-sensitive parameter) is
> enabled, it causes the regular user's query to always fail.
> - This issue does not occur in older versions.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
