I am using hive and impala in my design, when data is refreshed with certain interval , latest data shows in Hive and not in imapala. When i execute invalidate metadata then Impala shows latest data while querying. Is there way i can configure this as one time setting rather than executing invalidate metadata all the times.
I don't think it is possible to do it as one time command
if you think "Invalidate Metadata" is taking more time to refresh the enire DB then you can restrict to some particular tables as follows "Invalidate Metadata [db.tablename]" , so this will help to save some time