Re: Hive 1.1.0 support on hive metastore 2.3.0

2019-12-09 Thread Priyam Gupta
Thanks. Will try out MR3. On Mon, Dec 9, 2019 at 3:51 PM Sungwoo Park wrote: > I didn't try to run multiple versions of Hive on the same cluster. If your > installation of Hive uses Tez installed on the Hadoop system, I guess > running multiple versions of Hive might not be easy because

Re: Hive 1.1.0 support on hive metastore 2.3.0

2019-12-09 Thread Sungwoo Park
I didn't try to run multiple versions of Hive on the same cluster. If your installation of Hive uses Tez installed on the Hadoop system, I guess running multiple versions of Hive might not be easy because different versions of Hive use different versions of Tez (especially if you want to run

Re: Hive 1.1.0 support on hive metastore 2.3.0

2019-12-09 Thread Priyam Gupta
Thanks Park for sharing the tests that you did. I will try out for the specific version for my use cases. Is there any better way/approach where we can have a single meta store and can launch multiple hive clusters of different versions point to the same metastore db. Thanks. On Mon, Dec 9,

Re: Hive 1.1.0 support on hive metastore 2.3.0

2019-12-08 Thread Sungwoo Park
Not a definitive answer, but my test result might help. I tested with HiveServer2 1.2.2 and Metastore 2.3.6. Queries in the TPC-DS benchmark (which only read data and never update) run okay. Creating new tables and loading data to tables also work okay. So, I guess for basic uses of Hive, running

Hive 1.1.0 support on hive metastore 2.3.0

2019-12-08 Thread Priyam Gupta
Hi, In order to have single hive metastore supporting different clusters of hive, I have upgraded my hive metastore schema (on postgres) from version 1.1.0 to version 2.3.0. Will hive cluster on version 1.1.0 work if I point it to upgraded metastore db which is as per hive version 2.3.0.