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 >>> >> >> >
