[
https://issues.apache.org/jira/browse/HIVE-28057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ayush Saxena resolved HIVE-28057.
---------------------------------
Fix Version/s: 4.1.0
Resolution: Fixed
> Iceberg: Branches with non-lowercase characters can't be accessed
> -----------------------------------------------------------------
>
> Key: HIVE-28057
> URL: https://issues.apache.org/jira/browse/HIVE-28057
> Project: Hive
> Issue Type: Bug
> Reporter: Attila Turoczy
> Assignee: Ayush Saxena
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.1.0
>
> Attachments: image-2024-02-05-16-10-55-198.png
>
>
> Repo:
> 1. Let's create a branch
> ALTER TABLE Devices CREATE Branch *Sandbox*
> 2. Check the existence for evidence
> SELECT * FROM `default`.`devices`.`refs`;
> The References show it properly
>
> !image-2024-02-05-16-10-55-198.png!
>
> 3. Select from branch
> SELECT * FROM default.Devices.branch_Sandbox;
> But if the select it would throw an exception:
> {color:#de350b}Error while compiling statement: FAILED: SemanticException
> Cannot use snapshotRef (does not exist): sandbox{color}
> I guess the select operator does have a simple equals and does not check the
> cases also the cultureInvariant could be a different issue
> *Exception*
> INFO : Compiling
> command(queryId=hive_20240205151156_891265b0-0d7c-49b6-892a-cc6f7574ed2b):
> SELECT * FROM default.Devices.branch_Sandbox
> ERROR : FAILED: SemanticException Cannot use snapshotRef (does not exist):
> sandbox
> org.apache.hadoop.hive.ql.parse.SemanticException: Cannot use snapshotRef
> (does not exist): sandbox
> at
> org.apache.iceberg.mr.hive.HiveIcebergStorageHandler.checkAndSetTableMetaRef(HiveIcebergStorageHandler.java:1017)
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1800)
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1710)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5657)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2362)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2309)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13295)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13403)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:482)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:319)
> at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:227)
> at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:108)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:202)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:656)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:602)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:596)
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:209)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:338)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:423)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899)
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:360)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:829)
> INFO : Completed compiling
> command(queryId=hive_20240205151156_891265b0-0d7c-49b6-892a-cc6f7574ed2b);
> Time taken: 0.088 seconds
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
