Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎06-01-2017

Subquery in Impala Update

Hi, I am using Impala on Kudu, When I try to update my Kudu table with a subquery, I get an Exception saying - "Subqueries are not supported as update expressions for column ..." with this I understand that Impala doesn't support subqueries in Update.

 

My usecase is I need to populate a column in Kudu table with a row number (similar to autoincrement) and for this I am using Imapala's ROW_NUMBER function. please let me know how to implement my requirement.

 

Suresh

New Contributor
Posts: 2
Registered: ‎06-01-2017

Re: Subquery in Impala Update

I got it fixed by removing the subquery and using the function directly since it solved my usecase. 

 

But the question is still open if we need to update a column with subquery invovling another table.

 

 

-Suresh

Announcements