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
>
