hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From karthi keyan <karthi93.san...@gmail.com>
Subject Re: Show Redudant database name in Beeline -Hive 2.0
Date Thu, 23 Jun 2016 05:49:35 GMT
Small clarification ,
 Here i have started One MetaStore in Node 1 and started Hiveserver2 in the
same node. In Node 2 i have started another HiveServer2 which pointing the
metaStore of Node 1 ..

On Thu, Jun 23, 2016 at 11:00 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> wrote:

> 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