Reply
New Contributor
Posts: 5
Registered: ‎10-22-2015
Accepted Solution

Impala Jdbc throws exception where Impala Hue works fine

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

Highlighted
Cloudera Employee
Posts: 35
Registered: ‎10-20-2015

Re: Impala Jdbc throws exception where Impala Hue works fine

New Contributor
Posts: 5
Registered: ‎10-22-2015

Re: Impala Jdbc throws exception where Impala Hue works fine

Filed a bug in Jira IMPALA-2610