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