You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/30 17:40:00 UTC
[jira] [Resolved] (IMPALA-2609) Table aliases with spaces do work
properly
[ 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org