If the query contains a subquery in the FROM clause and the alias to the subquery contains space,    select `alias with space`.code from (select * from sample_07) `alias with space`   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   Is this a known issue?   /Saravana ... View more

Hi,   The query "select count(*) from sample_07 where exists(select code from sample_08 where sample_08.salary = sample_07.salary); " works fine in Impala Hue. When it is executed through JDBC, I am getting the following exception   Exception in thread "main" java.sql.SQLException: [Simba][ImpalaJDBCDriver](500320) Error during translation: code 42000, type Syntax error or access violation, message AEExistsPredicate is not supported at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.defaultVisit(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.defaultVisit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.AEDefaultVisitor.visit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.bool.AEExistsPredicate.acceptVisitor(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.relation.AESelect.acceptVisitor(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.relation.AEAggregate.acceptVisitor(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.relation.AEProject.acceptVisitor(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visitChildren(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visitChildren(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQLAENodeVisitor.visit(Unknown Source) at com.cloudera.impala.sqlengine.aeprocessor.aetree.statement.AEQuery.acceptVisitor(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQueryTranslator.translate(Unknown Source) at com.cloudera.impala.impala.querytranslation.ImpalaQueryTranslator.translate(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](500320) Error during translation: code 42000, type Syntax error or access violation, message AEExistsPredicate is not supported ... 23 more   Is this a known issue or is it a bug?   /Saravana ... View more