kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Boris Tyukin <bo...@boristyukin.com>
Subject KuduScanner with multiple sets of compound primary keys
Date Tue, 11 Dec 2018 20:59:19 GMT
Hi guys,

my Kudu table has several PK columns and I need to create a scanner to pull
multiple rows for these primary keys. If I used Impala, it would be
something like

SELECT pk1, pk2, col1 FROM table1
WHERE
      (pk1 = 1 and pk2 = 11)
OR (pk1 = 2 and pk2 = 22)
OR (pk1 = 3 and pk2 = 33)

I tried one KuduScanner per PK set and it works but I want to see if I can
get a better performance by doing a scan on all PK sets at once. Cannot
figure out how to do the OR part with ScannerBuilder and addPredicate
method.

Thanks!

Mime
View raw message