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 Thu, 23 Jun 2016 05:30:20 GMT
Sounds like it is picking up results from both metastores!

May be the cluster is not set up correctly. it should always pickup from
the active node (just one)



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 23 June 2016 at 06:23, karthi keyan <karthi93.sankar@gmail.com> wrote:

> Hi Mich,
>
> Here is have used derby as JDBC metastore.
>
> jdbc:derby://<host>:1527/metastore_db;create=true
>
> Let me explain the config:
>
> Actually in a cluster pointing the same MetaStore from 2 Hiverserver
> Running in two different node.
>
> 1- Starting Derby server - (networkserver)
> 2- Starting metaStore services.
> 3- Hiveserver 2 - Node 1
> 4- Hiveserver 2 - Node 2
>
> I think pointing same metastore will leads the issue ??  But it occurs in
> random not everytime !!
>
> -Karthik
>
>
>
> On Thu, Jun 23, 2016 at 2:48 AM, Mich Talebzadeh <
> mich.talebzadeh@gmail.com> wrote:
>
>> 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