Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
Ltd, its subsidiaries nor their employees accept >> any responsibility. >> >> >> -Original Message- >> From: Amith sha [mailto:amithsh...@gmail.com] >> Sent: 10 March 2015 08:29 >> To: user@hive.apache.org >> Subject: Re: hive 1.1.0 Error wh

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
ployees accept > any responsibility. > > > -Original Message- > From: Amith sha [mailto:amithsh...@gmail.com] > Sent: 10 March 2015 08:29 > To: user@hive.apache.org > Subject: Re: hive 1.1.0 Error while Metastore starting > > after executing this command > >

RE: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Mich Talebzadeh
nor their employees accept any responsibility. -Original Message- From: Amith sha [mailto:amithsh...@gmail.com] Sent: 10 March 2015 08:29 To: user@hive.apache.org Subject: Re: hive 1.1.0 Error while Metastore starting after executing this command mysql>use metastoreDB mysql>

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
o stated. It is the > responsibility of the recipient to ensure that this email is virus free, > therefore neither Peridale Ltd, its subsidiaries nor their employees accept > any responsibility. > > > -Original Message- > From: Amith sha [mailto:amithsh...@gmail.com]

RE: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Mich Talebzadeh
any responsibility. -Original Message- From: Amith sha [mailto:amithsh...@gmail.com] Sent: 10 March 2015 07:36 To: user@hive.apache.org Subject: Re: hive 1.1.0 Error while Metastore starting Hi Srinivas Have used hive-schema-0.14.0 but same error found 2015-03-10 13:04:03,

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
Hi Srinivas Have used hive-schema-0.14.0 but same error found 2015-03-10 13:04:03,829 ERROR [main]: DataNucleus.Datastore (Log4JLogger.java:error(115)) - An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytes com.mysql.jdb

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
ok thank you Srinivas wil try it and reply now Thanks & Regards Amithsha On Tue, Mar 10, 2015 at 12:59 PM, Srinivas Thunga wrote: > i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables. > > Thanks & Regards, > > Srinivas T > > On Tue, Mar 10, 2015 at 12:55 PM, Amith sha wro

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Srinivas Thunga
i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables. *Thanks & Regards,* *Srinivas T* On Tue, Mar 10, 2015 at 12:55 PM, Amith sha wrote: > so can u suggest the solution > Thanks & Regards > Amithsha > > > On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga > wrote: > > Hi,

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
so can u suggest the solution Thanks & Regards Amithsha On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga wrote: > Hi, > > I guess you have the sql as > > hive-schema-1.1.0.mysql.sql > > for this you will get only 45 tables only as Nucleus will not be there. > > I am also faced the same problem

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Srinivas Thunga
Hi, I guess you have the sql as hive-schema-1.1.0.mysql.sql for this you will get only 45 tables only as Nucleus will not be there. I am also faced the same problem *Thanks & Regards,* *Srinivas T* On Tue, Mar 10, 2015 at 12:46 PM, Amith sha wrote: > Now i am able to create a metastore dat

Re: hive 1.1.0 Error while Metastore starting

2015-03-10 Thread Amith sha
Now i am able to create a metastore database after exporting the hive in .bashrc But the same mysql error is found Thanks & Regards Amithsha On Tue, Mar 10, 2015 at 12:03 PM, Amith sha wrote: > Hi all, > > I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Have started > the metastore by