Re: Error Accessing Mysql metastore
Thanx Nitin, we will let know once it works.. thanx alot for your responses. :) *Thanks & Regards* ∞ Shashwat Shriparv On Mon, Aug 5, 2013 at 12:53 PM, Nitin Pawar wrote: > Yes. > Please add these two to hive-site.xml > > stop your application > start hive metastore service > make sure hive is working on cli > start thirft service > start your application > make sure your application is working fine > > > > > On Mon, Aug 5, 2013 at 12:51 PM, varun kumar wrote: > >> Hi Nitin, >> >> Are these two tags need to mentioned in hive-site.xml. >> >> >> datanucleus.autoCreateSchema >> false >> >> >> datanucleus.fixedDatastore >> true >> >> >> Regards, >> Varun Kumar.P >> >> >> On Mon, Aug 5, 2013 at 10:25 AM, Nitin Pawar wrote: >> >>> shashwat, >>> >>> I don't if you have already read this or not >>> >>> >>> http://mail-archives.apache.org/mod_mbox/hive-user/201107.mbox/%3c4f6b25afffcafe44b6259a412d5f9b1033183...@exchmbx104.netflix.com%3E >>> >>> >>> On Sat, Aug 3, 2013 at 5:58 PM, shashwat shriparv < >>> dwivedishash...@gmail.com> wrote: >>> Actually this is a production server and i cant frequently change, i was working perfectly in morning, On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote: > datanucleus.fixedDataStore=true *Thanks & Regards* ∞ Shashwat Shriparv >>> >>> >>> -- >>> Nitin Pawar >>> >> >> >> >> -- >> Regards, >> Varun Kumar.P >> > > > > -- > Nitin Pawar >
Re: Error Accessing Mysql metastore
Yes. Please add these two to hive-site.xml stop your application start hive metastore service make sure hive is working on cli start thirft service start your application make sure your application is working fine On Mon, Aug 5, 2013 at 12:51 PM, varun kumar wrote: > Hi Nitin, > > Are these two tags need to mentioned in hive-site.xml. > > > datanucleus.autoCreateSchema > false > > > datanucleus.fixedDatastore > true > > > Regards, > Varun Kumar.P > > > On Mon, Aug 5, 2013 at 10:25 AM, Nitin Pawar wrote: > >> shashwat, >> >> I don't if you have already read this or not >> >> >> http://mail-archives.apache.org/mod_mbox/hive-user/201107.mbox/%3c4f6b25afffcafe44b6259a412d5f9b1033183...@exchmbx104.netflix.com%3E >> >> >> On Sat, Aug 3, 2013 at 5:58 PM, shashwat shriparv < >> dwivedishash...@gmail.com> wrote: >> >>> Actually this is a production server and i cant frequently change, i was >>> working perfectly in morning, >>> >>> >>> On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote: >>> datanucleus.fixedDataStore=true >>> >>> >>> >>> >>> *Thanks & Regards* >>> >>> ∞ >>> Shashwat Shriparv >>> >>> >> >> >> -- >> Nitin Pawar >> > > > > -- > Regards, > Varun Kumar.P > -- Nitin Pawar
Re: Error Accessing Mysql metastore
Hi Nitin, Are these two tags need to mentioned in hive-site.xml. datanucleus.autoCreateSchema false datanucleus.fixedDatastore true Regards, Varun Kumar.P On Mon, Aug 5, 2013 at 10:25 AM, Nitin Pawar wrote: > shashwat, > > I don't if you have already read this or not > > > http://mail-archives.apache.org/mod_mbox/hive-user/201107.mbox/%3c4f6b25afffcafe44b6259a412d5f9b1033183...@exchmbx104.netflix.com%3E > > > On Sat, Aug 3, 2013 at 5:58 PM, shashwat shriparv < > dwivedishash...@gmail.com> wrote: > >> Actually this is a production server and i cant frequently change, i was >> working perfectly in morning, >> >> >> On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote: >> >>> datanucleus.fixedDataStore=true >> >> >> >> >> *Thanks & Regards* >> >> ∞ >> Shashwat Shriparv >> >> > > > -- > Nitin Pawar > -- Regards, Varun Kumar.P
Re: Error Accessing Mysql metastore
shashwat, I don't if you have already read this or not http://mail-archives.apache.org/mod_mbox/hive-user/201107.mbox/%3c4f6b25afffcafe44b6259a412d5f9b1033183...@exchmbx104.netflix.com%3E On Sat, Aug 3, 2013 at 5:58 PM, shashwat shriparv wrote: > Actually this is a production server and i cant frequently change, i was > working perfectly in morning, > > > On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote: > >> datanucleus.fixedDataStore=true > > > > > *Thanks & Regards* > > ∞ > Shashwat Shriparv > > -- Nitin Pawar
Re: Error Accessing Mysql metastore
Actually this is a production server and i cant frequently change, i was working perfectly in morning, On Sat, Aug 3, 2013 at 5:55 PM, Nitin Pawar wrote: > datanucleus.fixedDataStore=true *Thanks & Regards* ∞ Shashwat Shriparv
Re: Error Accessing Mysql metastore
can you try setting this datanucleus.fixedDataStore=true and see if it solves the issues? On Sat, Aug 3, 2013 at 5:28 PM, shashwat shriparv wrote: > Hi Friends, > > We have configured mysql as a metastore for hive, its just throwing > following error, > > FAILED: Error in metadata: MetaException(message:Got exception: > javax.jdo.JDODataStoreException Exception thrown obtaining schema column > information from datastore > > > on what ever query i am trying, even show tables. i was working find > lately but suddenly it has started throwing this error, can any put some > light on this what may the problem. > > i am able to connect to mysql meta store and can see all the tables for > hive database. using the same user name and password i am providing to hive > for jdbc connection. > > i am able to to connect to the sql machine and db from the machine where i > am running hive. > > > *Thanks & Regards* > > ∞ > Shashwat Shriparv > > -- Nitin Pawar