If your success rate is increased by increasing hive.metastore.connect.retries, mostly likely your Thrift server is too busy to get connected. Can you check your /tmp/<userid>/hive.log in your local machine and see if exception related to metastore?
On Sep 30, 2010, at 11:21 PM, S. Venkatesh wrote: >> Amareshwari, this should be a metastore issue. Did you see this kind of >> issue in create table (without select) alone? > Nope. > >> Which RDBMS are you using for metastore? MySQL or Oracle? > MySQL > >> Was your >> database/thrift server heavy-loaded at that time? > Running with just one user. > > -- > Regards, > Venkatesh > > “Perfection (in design) is achieved not when there is nothing more to > add, but rather when there is nothing more to take away.” > - Antoine de Saint-Exupéry