Reply
New Contributor
Posts: 5
Registered: ‎04-20-2018

Refreshing multiple partitions in single query in Impala

Is there a way we can refresh multiple partitions in a single statement?.

 

What I am trying to execute is something like "refresh partition ( col in ('val1','val2',val3'......))".

 

So that I do not have to fire multiple refresh queries. If it is not present, are there plans to bring this feature anytime in the near future?.

Cloudera Employee
Posts: 336
Registered: ‎07-29-2015

Re: Refreshing multiple partitions in single query in Impala

We looked at adding this a while back but ran into some technical issues around whether it should discover new partitions that would match the predicates: https://issues.apache.org/jira/browse/IMPALA-4105

 

We have a few people actively working on REFRESH/INVALIDATE and related issues, hoping to drastically improve the experience there.

Announcements