@DNADatangineer As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

@newbieone, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

Hi @Daggers  You can store avro schema file in HDFS folder and point that folder for your hive table ..There is avro.schema.url property with value can be passed while Hive creating the table ..This solution works for versioning the avro schema file in HDFS for the respective table. You can explore schema registry as well  ... View more

I am getting the same problem and I am on 5.16 My research shows that the redirect should happen automatically but that does not seem to be happening ... View more

Hi @Daggers    Please feel free to select best answer if your questions are answered to close the thread.   Thanks ... View more

Thanks for that ... View more

Hi,   So how do you scale Hive Metastore when you need to support more than 80 active connections? According to Cloudera's documentation they only mention supporting up to 80 connections which needs 16-24GB. Does passing 80 connection requires to continue extending the Heap Memory? How big can it be since 24GB is already too big isn't it?   Attaching Cloudera's memory setup recommendations: https://www.cloudera.com/documentation/enterprise/5-15-x/topics/cdh_ig_hiveserver2_configure.html   Best, Eyal ... View more

Excellent ! these specific examples are what is needed. ... View more

Thanks.  Well yes I think it is what I need however.... it seems some of my tables have that date changing multiple times during a day.  I looked at navigator to try and track down who may have been issuing 'COMPUTE STATS' commands but found nothing.   To make the whole picture even stranger is the fact that the table is replicated at the database level using BDR.  But the master metadata is different from the target metadata.  The target table is the one I am looking at, this is the one getting update multiple times a day.   Any suggestions on how to find what is making this LAST_ANALYZED timestamp to increment all the time ?     ... View more