Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Kudu table consistency on tablet servers using impala JDBC

Highlighted

Kudu table consistency on tablet servers using impala JDBC

New Contributor

Hello,

 

I've an issue with updating an impala kudu table by cloudera impala JDBC driver version: 2.5.43

 

The case:

1. Application updates some kudu table by setting new value to some column.

2. Immediately after updating the application invokes sql request that query this table along with others

3. This application suppose that this table is updated however sometimes the query returns an old data.

  

The replication factor is 3 so I think that updating has happened on one tablet server but query has gone to other tablet server. The application works right if it waits for a couple of seconds between point 1 and 2.

 

Is it possible somehow to avoid such kind of inconsistency?

 

1 REPLY 1

Re: Kudu table consistency on tablet servers using impala JDBC

Rising Star
Impala doesn't provide "read your writes" consistency by default. In order to enable it, you need to reconfigure your Impala daemons with --kudu_read_mode=READ_AT_SNAPSHOT.

See https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/KUDU-Does-impala-scan-READ-LATEST-mode... for more information.
Don't have an account?
Coming from Hortonworks? Activate your account here