[
https://issues.apache.org/jira/browse/KYLIN-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17928357#comment-17928357
]
Guoliang Sun commented on KYLIN-6046:
-------------------------------------
h3. Root Cause
`HackSelectStarWithColumnACL` first parses the "database name.table name" from
the SQL and then retrieves the table metadata. However, the stored table names
are always in uppercase, while the parsed "database name.table name" from the
SQL may be in lowercase, leading to a failure in retrieving the table metadata.
*Note:* When Calcite parses SQL, the database name and table name inside quotes
retain their original case. Therefore, if the database name or table name
inside quotes is in lowercase, it results in an error when attempting to read
the table metadata.
> 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)
