[
https://issues.apache.org/jira/browse/IMPALA-2609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-2609.
-----------------------------------
Resolution: Cannot Reproduce
Assignee: (was: Syed A. Hashmi)
> Table aliases with spaces do work properly
> ------------------------------------------
>
> Key: IMPALA-2609
> URL: https://issues.apache.org/jira/browse/IMPALA-2609
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.2.4, Impala 2.3.0
> Reporter: Saravana
> Priority: Minor
>
> If the query contains a subquery in the FROM clause and the alias to the
> subquery contains space,
>
> {code:sql}select `alias with space`.code from (select * from sample_07)
> `alias with space`{code}
>
> the JDBC driver throws exception
>
> Exception in thread "main" java.sql.SQLException:
> [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error
> Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
> errorMessage:AnalysisException: Syntax error in line 1:
> ...lt`.`sample_07`) AS alias with space
> ^
> Encountered: WITH
> Expected: CROSS, FROM, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIMIT, OFFSET,
> ON, ORDER, RIGHT, UNION, USING, WHERE, COMMA
>
> CAUSED BY: Exception: Syntax error
> ), Query: SELECT `alias with space`.`code` FROM (SELECT `sample_07`.`code`,
> `sample_07`.`description`, `sample_07`.`total_emp`, `sample_07`.`salary` FROM
> `default`.`sample_07`) AS alias with space.
> at
> com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown
> Source)
> at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown
> Source)
> at
> com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown
> Source)
> at
> com.cloudera.impala.hivecommon.dataengine.HiveJDBCDSIExtQueryExecutor.execute(Unknown
> Source)
> at com.cloudera.impala.jdbc.common.SStatement.executeNoParams(Unknown Source)
> at com.cloudera.impala.jdbc.common.SStatement.executeQuery(Unknown Source)
> Caused by: com.cloudera.impala.support.exceptions.GeneralException:
> [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error
> Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
> errorMessage:AnalysisException: Syntax error in line 1:
> ...lt`.`sample_07`) AS alias with space
> ^
> Encountered: WITH
> Expected: CROSS, FROM, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIMIT, OFFSET,
> ON, ORDER, RIGHT, UNION, USING, WHERE, COMMA
>
> CAUSED BY: Exception: Syntax error
> ), Query: SELECT `alias with space`.`code` FROM (SELECT `sample_07`.`code`,
> `sample_07`.`description`, `sample_07`.`total_emp`, `sample_07`.`salary` FROM
> `default`.`sample_07`) AS alias with space.
> ... 6 more
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
