Re: Show Redudant database name in Beeline -Hive 2.0

Small clarification , Here i have started One MetaStore in Node 1 and started Hiveserver2 in the same node. In Node 2 i have started another HiveServer2 which pointing the metaStore of Node 1 .. On Thu, Jun 23, 2016 at 11:00 AM, Mich Talebzadeh wrote: > Sounds like it is picking up results from

Re: Show Redudant database name in Beeline -Hive 2.0

Sounds like it is picking up results from both metastores! May be the cluster is not set up correctly. it should always pickup from the active node (just one) Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Show Redudant database name in Beeline -Hive 2.0

Hi Mich, Here is have used derby as JDBC metastore. jdbc:derby://:1527/metastore_db;create=true Let me explain the config: Actually in a cluster pointing the same MetaStore from 2 Hiverserver Running in two different node. 1- Starting Derby server - (networkserver) 2- Starting metaStore servic

Re: Show Redudant database name in Beeline -Hive 2.0

Hi Karthi, Those database names are picked up from the metadata of Hive/ Do you know the type of RDBMS that holds your Hive database. Check hive-site.xml for javax.jdo.option.ConnectionURL HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6A

Re: Show Redudant database name in Beeline -Hive 2.0

Hi Mich, Some times am facing this kind of issue with database "DEFAULT".. Connected to: Apache Hive (version 2.0.1) Driver: Hive JDBC (version 2.0.1) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://host:1/default> show databases; ++--+ | database_name | +

Re: Show Redudant database name in Beeline -Hive 2.0

hm That is very strange. What other database besides default you expect to be there Mine is as below Beeline version 2.0.0 by Apache Hive 0: jdbc:hive2://rhes564:10010/default> show databases; ++--+ | database_name | ++--+ | accounts | | asehadoop | | d

Show Redudant database name in Beeline -Hive 2.0

Hi all, Am using Hive 2.0 , once i have connected via beeline and i queried "show databases;" command , It will show same database name by more than once. ​ Is there any issue over this ??? Best, Karthik