Reply
Highlighted
Explorer
Posts: 6
Registered: ‎10-14-2016
Accepted Solution

[Simba][ImpalaJDBCDriver](500320) Error during translation.

Hello, 

 

We have an error when we try to execute Update via JDBC connection to KUDU with Impala JDBC4.

 

The error is : 

 

java.sql.SQLException: [Simba][ImpalaJDBCDriver](500320) Error during translation.

Caused by: com.cloudera.impala.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500320) Error during translation.

 

Our current dependencies are : 

 

<dependency>
<groupId>com.cloudera.impala.jdbc</groupId>
<artifactId>ImpalaJDBC4</artifactId>
<version>2.5.5</version>
</dependency>
<dependency>
<groupId>com.cloudera</groupId>
<artifactId>TCLIServiceClient</artifactId>
<version>2.5.5</version>
</dependency>
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-metastore</artifactId>
<version>2.1.0</version>
</dependency>
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-service</artifactId>
<version>2.1.0</version>
</dependency>

 

 And our code is :

 

String query = "UPDATE table_XX SET status = 'ENABLED' WHERE id = 1234";

stmt = connection.createStatement();
stmt.executeUpdate(query);

 

Cloudera Employee
Posts: 16
Registered: ‎12-19-2013

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

Hi,


Can you use the latest JDBC driver? I just ran an UPDATE successfully with the 2.5.34 driver.

 

http://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-34.html

 

Thanks

Explorer
Posts: 6
Registered: ‎10-14-2016

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

[ Edited ]

Hi, 

 

We have tested with the last version and now it works fine!

 

Thanks

Cloudera Employee
Posts: 1
Registered: ‎11-15-2016

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

I still have issue with V 2.5.34:
java.sql.SQLException: [Simba][ImpalaJDBCDriver](500323) Error processing query translation statement.
at com.cloudera.impala.querytranslation.ImpalaQueryTranslator.translate(Unknown Source)
at com.cloudera.impala.querytranslation.ImpalaQueryTranslator.translate(Unknown Source)
at com.cloudera.hivecommon.dataengine.HiveJDBCDSIExtQueryExecutor.execute(Unknown Source)
at com.cloudera.jdbc.common.SStatement.executeNoParams(Unknown Source)
at com.cloudera.jdbc.common.SStatement.executeUpdate(Unknown Source)
Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500323) Error processing query translation statement.
... 5 more
Explorer
Posts: 7
Registered: ‎11-09-2015

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

I do have the same issue with 2.5.36 any time I try to do either update or delete (Mac JDBC version if it makes any difference)

 

[UPDATE - 0 rows, 0.025 secs]  [Code: 500323, SQL State: HY000]  [Simba][ImpalaJDBCDriver](500323) Error processing query translation statement.

 

 

Any ideas? 

Cloudera Employee
Posts: 50
Registered: ‎09-28-2015

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

Can you try adding a semicolon at the end of the query string? I believe
there may be a bug in the Simba driver which requires a semicolon for
update/delete statements.
Explorer
Posts: 7
Registered: ‎11-09-2015

Re: [Simba][ImpalaJDBCDriver](500320) Error during translation.

I am running the query from DBVisualizer with semicolon.

 

The explain works fine, but the query fails. (works with hive jdbc though)

 

explain
update sfmta set heading = 666 where vehicle_tag=1492 and report_time = 1356998404;

 

Thanks

 

Announcements
Unanswered Topics
No posts to display.