Impal Kudu JDBC Delete on PK not working ([Simba][ImpalaJDBCDriver](500323) Error processing query )

[#1]

Delete operation with PK (int) not working via JDBC:

CREATE TABLE cities_1 (
  cid INT PRIMARY KEY,
  name STRING
)
  PARTITION BY HASH(cid) PARTITIONS 8
  STORED AS KUDU;
insert into cities_1(cid,name) values(1234567890,"NoName");
select * from cities_1 where cid = 1234567890;
update cities_1 set name = "NoName1" where cid = 1234567890;
delete from cities_1 where cid = 1234567890; -> FAILED
delete from cities_1 where name = "NoName1"; -> WORKS

 JDBC connector 2.5.36

[#2]

delete from cities_1 where cid = CAST(1234567890 AS INTEGER); -> WORKS, but looks like a hack 🙂

[#3]

Hi vlogvinskiy,

Thank you for your report. What version of Impala are you using? Your commands work on the Impala shell on my development environment. Can you try them on an Impala shell? In the meantime, I'll reach out to the team working on the driver and I'll get back to you as soon as I hear from them.

Cheers, Lars

[#4]

Impala shell works ok, issue only with JDBC driver.

impalad -version
impalad version 2.7.0-cdh5.10.0 RELEASE (build 785a073cd07e2540d521ecebb8b38161ccbd2aa2)
Built on Fri Jan 20 12:03:56 PST 2017

[#5]

Thank you for the additional information. The team working on the driver has identified the issue and a fix will be included in the next release of the drivers. Until then I'm afraid you'll be stuck with the somewhat ugly workaround.

Cheers, Lars