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.talebza...@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.san...@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.talebza...@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.san...@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.talebza...@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.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 >>>>>> >>>>> >>>>> >>>> >>> >> >
