Re: Hive support for concurrency with Oracle Metastore

2015-04-08 Thread Alan Gates
All locks in Hive are on database, table, or partition level. There are no row level locks. When using DbTxnManager the locking is chosen to be as fine grained as possible (ie only partitions are locked when we can a priori know the partitions that will be used in the query). Alan. Mich

Hive support for concurrency with Oracle Metastore

2015-04-08 Thread Mich Talebzadeh
Hi, Thanks for all the useful info. I managed to set up hive concurrency using Oracle Metastore for Hive. Had to modify hive-txn-schema-0.14.0.oracle.sql script in order to drop the existing tables as I had created the metastore with hive-schema-0.14.0.oracle.sql initially. All the