hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Show Redudant database name in Beeline -Hive 2.0
Date Tue, 21 Jun 2016 07:12:37 GMT
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.sankar@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
>

Mime
View raw message