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:37:00 UTC
[jira] [Resolved] (IMPALA-2629) CLONE - Impala Jdbc throws
exception "[Simba][ImpalaJDBCDriver](500320) " where Impala Hue works fine
[ https://issues.apache.org/jira/browse/IMPALA-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-2629.
-----------------------------------
Resolution: Invalid
We don't track issues with these drivers here.
> CLONE - Impala Jdbc throws exception "[Simba][ImpalaJDBCDriver](500320) " where Impala Hue works fine
> -----------------------------------------------------------------------------------------------------
>
> Key: IMPALA-2629
> URL: https://issues.apache.org/jira/browse/IMPALA-2629
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.2.4
> Reporter: Ramakrishna
> Priority: Minor
>
> The query
> {code:sql}select count(*) from sample_07 where exists(select code from sample_08 where sample_08.salary = sample_07.salary); {code}
> 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
> Using useNativeQuery option in URL is an workaround for now.
--
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