06-01-2017 01:27 AM
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.
06-01-2017 03:39 AM
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.