Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Impala Jdbc throws exception where Impala Hue works fine

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Rising Star
2 REPLIES 2

avatar
Rising Star

avatar
Explorer

Filed a bug in Jira IMPALA-2610