> Below is the document which has some more details on the same: https://impala.apache.org/docs/build/html/topics/impala_upsert.html   > Please let us know what is your concerns. ... View more

Hi Chethan   Thanks for the reply as per your examples   1. select name from census where year=2010; This works fine ie it only queries the partition but our problem is when the condition is not a literal like ='2010' but when we try to dynamically retrieve the data like your second example   We are finding that the query scans the whole table not just the partition - ie takes much longer in larger tables   ... View more

Thanks for making it clear ... View more