[
https://issues.apache.org/jira/browse/HIVE-27825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17780824#comment-17780824
]
Ayush Saxena commented on HIVE-27825:
-------------------------------------
Committed to master.
Thanx [~okumin] for the contribution!!!
> Better error message for an empty quoted identifier
> ---------------------------------------------------
>
> Key: HIVE-27825
> URL: https://issues.apache.org/jira/browse/HIVE-27825
> Project: Hive
> Issue Type: Improvement
> Components: Parser
> Affects Versions: 4.0.0-beta-1
> Reporter: okumin
> Assignee: okumin
> Priority: Minor
> Labels: pull-request-available
>
> SemanticAnalyzer throws a StringIndexOutOfBoundsException when a quoted
> identifier is empty. It is likely to happen when a template system fails to
> fill a database name or table name. We should return a better message so that
> a user can easily identify where is wrong.
>
> {code:java}
> 0: jdbc:hive2://hive-hiveserver2:10000/defaul> SELECT * FROM ``;
> Error: Error while compiling statement: FAILED:
> StringIndexOutOfBoundsException String index out of range: 0
> (state=42000,code=40000) {code}
> This is the stacktrace on HiveServer2.
> {code:java}
> org.apache.hive.service.cli.HiveSQLException: Error while compiling
> statement: FAILED: StringIndexOutOfBoundsException String index out of range: > 0
> at
> org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:376)
> ~[hive-service-4.0.0-beta-2-SNAPSHOT.jar:4.0.0-beta-2-SNAPSHOT]
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:214)
> ~[hive-service-4.0.0-beta-2-SNAPSHOT.jar:4.0.0-beta-2-SNAPSHOT]
> ...
> Caused by: java.lang.StringIndexOutOfBoundsException: String index out of
> range: 0
> at java.lang.String.charAt(String.java:658) ~[?:1.8.0_275]
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.unescapeIdentifier(BaseSemanticAnalyzer.java:608)
> ~[hive-exec-4.0.0-beta-2-SNAPSHOT.jar:4.0.0-beta-2-SNAPSHOT]
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getDbTableNamePair(BaseSemanticAnalyzer.java:424)
> ~[hive-exec-4.0.0-beta-2-SNAPSHOT.jar:4.0.0-beta-2-SNAPSHOT]{code}
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
