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 Wed, 22 Jun 2016 21:18:27 GMT
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.sankar@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.talebzadeh@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.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