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.

Impala KUDU table - howto bulk update

Impala KUDU table - howto bulk update

New Contributor

Hello! I need to performing updates of KUDU table, Is there any option to du update in bulk?

 

The flow is following:
1 .Fetch 1000 rows
2. Process rows, calculate new value for each row
3. Update KUDU table with new values

 

Updating row by row with one DB query per row - slow. I am seeking bulk update solution. I found only this "You can update in bulk using the same approaches outlined in Inserting In Bulk." here https://www.cloudera.com/documentation/kudu/latest/topics/kudu_impala.html#update_bulk but how to du this? I need example, if it is possible

Thanks

1 REPLY 1

Re: Impala KUDU table - howto bulk update

Expert Contributor
Are you looking to use the direct API or would you be OK with a SQL
solution?

Certainly the easiest would be to simply use a SQL query from Impala such
as:

update t set my_col='foo' where bar > 123;

If you want to use the API, I'd suggest using the AUTO_FLUSH_BACKGROUND
mode to ensure that many updates get batched together into a single
round-trip RPC to the tablet servers.

Todd