Hi Mich, Here is have used derby as JDBC metastore.
jdbc:derby://<host>: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 services. 3- Hiveserver 2 - Node 1 4- Hiveserver 2 - Node 2 I think pointing same metastore will leads the issue ?? But it occurs in random not everytime !! -Karthik On Thu, Jun 23, 2016 at 2:48 AM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > 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 > <name>javax.jdo.option.ConnectionURL</name> > > HTH > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 22 June 2016 at 15:31, karthi keyan <karthi93.san...@gmail.com> wrote: > >> 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:10000/default> show databases; >> +----------------+--+ >> | database_name | >> +----------------+--+ >> | default | >> | default | >> +----------------+--+ >> 2 rows selected (0.126 seconds) >> >> >> for Logging where to find the logging details?? >> >> Best, >> Karthik >> >> On Tue, Jun 21, 2016 at 12:42 PM, Mich Talebzadeh < >> mich.talebza...@gmail.com> wrote: >> >>> 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 | >>> | default | >>> | iqhadoop | >>> | mytable_db | >>> | oraclehadoop | >>> | test | >>> | twitterdb | >>> +----------------+--+ >>> >>> Can you log in to your metadata and see database or ask an admin guy to >>> do so >>> >>> It is in table DBS. >>> >>> select db_id, substr(name,1,20) AS DBName from dbs order by 1; >>> DB_ID DBNAME >>> ---------- -------------------- >>> 1 default >>> 2 asehadoop >>> 6 oraclehadoop >>> 11 test >>> 16 iqhadoop >>> 22 mytable_db >>> 31 accounts >>> 36 twitterdb >>> >>> HTH >>> >>> >>> Dr Mich Talebzadeh >>> >>> >>> >>> LinkedIn * >>> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>> >>> >>> >>> http://talebzadehmich.wordpress.com >>> >>> >>> >>> On 21 June 2016 at 07:56, karthi keyan <karthi93.san...@gmail.com> >>> wrote: >>> >>>> 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 >>>> >>> >>> >> >
