hive - Auto execution of "validate metadata" in Impala -


i have tableau connected cloudera impala data. table reading metastore keeps on updating so, when want viz update (pressing f5) have go impala in cloudera , execute "invalidate metadata" before refreshing viz. know can done using connection hive server 2, takes long time execute query. question there anyway automatically execute "validate metadata" , "refresh" queries in impala cloudera?

thanks,

amr

unfortunately impala not offer mechanism automatically update metadata yet. working on future, though haven't committed such functionality particular release yet.

in meantime, there may things can make easier. firstly, how table being updated? there new data files? if so, can run refresh faster. also, sure invalidate/refresh specific table, e.g. refresh my_table. see documentation [invalidate metadata][1] , refresh more information.

is there etl process in background? users modify workflow issue refresh command impala after updating table, e.g. in script adding impala-shell -i <impalad-host> -q "refresh my_table"


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

node.js - How to abort query on demand using Neo4j drivers -