[ 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org