Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D46E117B1B for ; Tue, 10 Mar 2015 07:31:15 +0000 (UTC) Received: (qmail 7735 invoked by uid 500); 10 Mar 2015 07:31:07 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 7664 invoked by uid 500); 10 Mar 2015 07:31:07 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 7654 invoked by uid 99); 10 Mar 2015 07:31:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Mar 2015 07:31:07 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of srinivas.thunga@gmail.com designates 209.85.223.182 as permitted sender) Received: from [209.85.223.182] (HELO mail-ie0-f182.google.com) (209.85.223.182) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Mar 2015 07:31:02 +0000 Received: by iecsl2 with SMTP id sl2so2970954iec.1 for ; Tue, 10 Mar 2015 00:29:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=EwOhd22ZOKRk9Zgv0OVsbB1akGMYlvS6BEZLdI38go8=; b=Av/PZUucneswR4GnWIiKHvphio1loLl002cJNoMA/QC6r8TXn9w73M+t2CLGOvLtPl 0pPmm+Ho8fsDMcmdJ8PU9hqeiNpY+PZ5LSww4MCM+M1fM49zRhj3zlYh7xXm6rwigvds mag3Tz8/0T0sR8DBHM+VaEMV0L5Jg49MkCxyxMwEKjvyNUBfxsTnVZyVNlQ0M6wqd0FW hNKF07DObFKj1iLRfOGRcUgNIV7Q4N7FgIW/p8TlcOq1mso36TZLUKv5yNgVBE/7QtLJ szPk9RXx6u8vLgC1jfJlSzed/haM77hBSEm6PkBWPGmObk8J8luUobvjYcmOYRvQVfbq JDEg== MIME-Version: 1.0 X-Received: by 10.42.82.199 with SMTP id e7mr26447233icl.18.1425972596870; Tue, 10 Mar 2015 00:29:56 -0700 (PDT) Received: by 10.50.148.2 with HTTP; Tue, 10 Mar 2015 00:29:56 -0700 (PDT) In-Reply-To: References: Date: Tue, 10 Mar 2015 12:59:56 +0530 Message-ID: Subject: Re: hive 1.1.0 Error while Metastore starting From: Srinivas Thunga To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=20cf303346571898e80510ea1e77 X-Virus-Checked: Checked by ClamAV on apache.org --20cf303346571898e80510ea1e77 Content-Type: text/plain; charset=UTF-8 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, > > > > 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 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 [ hive --service metastore -p 7099 ] > >> > > >> > and got the log as > >> > > >> > 2015-03-10 11:32:42,649 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.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified > >> > key was too long; max key length is 767 bytes > >> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >> > Method) > >> > at > >> > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > >> > at > >> > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > >> > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > >> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > >> > at com.mysql.jdbc.Util.getInstance(Util.java:386) > >> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > >> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) > >> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) > >> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) > >> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) > >> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) > >> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) > >> > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949) > >> > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795) > >> > at > >> > com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:254) > >> > at > >> > > org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:760) > >> > at > >> > > org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:648) > >> > at > >> > > org.datanucleus.store.rdbms.table.TableImpl.validateIndices(TableImpl.java:593) > >> > at > >> > > org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:390) > >> > at > >> > > org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3463) > >> > at > >> > > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3464) > >> > at > >> > > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190) > >> > at > >> > > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841) > >> > at > >> > > org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122) > >> > at > >> > > org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605) > >> > at > >> > > org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954) > >> > at > >> > > org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679) > >> > at > >> > > org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:408) > >> > at > >> > > org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:947) > >> > at > >> > > org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:370) > >> > at org.datanucleus.store.query.Query.executeQuery(Query.java:1744) > >> > at > >> > org.datanucleus.store.query.Query.executeWithArray(Query.java:1672) > >> > at org.datanucleus.store.query.Query.execute(Query.java:1654) > >> > at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:221) > >> > at > >> > > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.ensureDbInit(MetaStoreDirectSql.java:172) > >> > at > >> > > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.(MetaStoreDirectSql.java:130) > >> > at > >> > > org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:275) > >> > at > >> > > org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:238) > >> > at > >> > > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73) > >> > at > >> > > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133) > >> > at > >> > > org.apache.hadoop.hive.metastore.RawStoreProxy.(RawStoreProxy.java:56) > >> > at > >> > > org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:579) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:557) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:606) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:448) > >> > at > >> > > org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66) > >> > at > >> > > org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5570) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5565) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5798) > >> > at > >> > > org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5723) > >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > >> > at > >> > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > >> > at > >> > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > >> > at java.lang.reflect.Method.invoke(Method.java:606) > >> > at org.apache.hadoop.util.RunJar.main(RunJar.java:212) > >> > > >> > > >> > > >> > *Changed the metastore DB name but the db is not created in MYSQL > >> > > >> > Can anyone suggest it > >> > > >> > > >> > > >> > > >> > > >> > > >> > Thanks & Regards > >> > Amithsha > > > > > --20cf303346571898e80510ea1e77 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
i am thinking to run=C2=A0hive-schema-0.14.0.mysql.sql. it= will have 54 tables.

Thanks & Regards,<= /i>

Srinivas T

On Tue, Mar 10, 2015 at 12:55 PM, Amith sha = <amithsha92@gmail.com> wrote:
so can u suggest the solution
Thanks & Regards
Amithsha


On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga
<srinivas.thunga@gmail.com<= /a>> 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
>
> Thanks & Regards,
>
> Srinivas T
>
> On Tue, Mar 10, 2015 at 12:46 PM, Amith sha <amithsha92@gmail.com> wrote:
>>
>> Now i am able to create a metastore database after exporting the h= ive
>> in .bashrc But the same mysql=C2=A0 error is found
>> Thanks & Regards
>> Amithsha
>>
>>
>> On Tue, Mar 10, 2015 at 12:03 PM, Amith sha <amithsha92@gmail.com> wrote:
>> > Hi all,
>> >
>> > I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Hav= e started
>> > the metastore by [ hive --service metastore -p 7099 ]
>> >
>> > and got the log as
>> >
>> > 2015-03-10 11:32:42,649 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.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Sp= ecified
>> > key was too long; max key length is 767 bytes
>> >=C2=A0 =C2=A0 =C2=A0at sun.reflect.NativeConstructorAccessorIm= pl.newInstance0(Native
>> > Method)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC= onstructorAccessorImpl.java:57)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del= egatingConstructorAccessorImpl.java:45)
>> >=C2=A0 =C2=A0 =C2=A0at java.lang.reflect.Constructor.newInstan= ce(Constructor.java:526)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.Util.handleNewInstance(U= til.java:411)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.Util.getInstance(Util.ja= va:386)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.SQLError.createSQLExcept= ion(SQLError.java:1054)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.MysqlIO.checkErrorPacket= (MysqlIO.java:4237)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.MysqlIO.checkErrorPacket= (MysqlIO.java:4169)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.MysqlIO.sendCommand(Mysq= lIO.java:2617)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.MysqlIO.sqlQueryDirect(M= ysqlIO.java:2778)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.ConnectionImpl.execSQL(C= onnectionImpl.java:2819)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.ConnectionImpl.execSQL(C= onnectionImpl.java:2768)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.StatementImpl.execute(St= atementImpl.java:949)
>> >=C2=A0 =C2=A0 =C2=A0at com.mysql.jdbc.StatementImpl.execute(St= atementImpl.java:795)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > com.jolbox.bonecp.StatementHandle.execute(StatementHandle.jav= a:254)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.table.AbstractTable.executeDdlSta= tement(AbstractTable.java:760)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.table.TableImpl.createIndices(Tab= leImpl.java:648)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.table.TableImpl.validateIndices(T= ableImpl.java:593)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.table.TableImpl.validateConstrain= ts(TableImpl.java:390)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.table.ClassTable.validateConstrai= nts(ClassTable.java:3463)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.perf= ormTablesValidation(RDBMSStoreManager.java:3464)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addC= lassTablesAndValidate(RDBMSStoreManager.java:3190)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(= RDBMSStoreManager.java:2841)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute= (AbstractSchemaTransaction.java:122)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBM= SStoreManager.java:1605)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.AbstractStoreManager.addClass(AbstractS= toreManager.java:954)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreCla= ss(RDBMSStoreManager.java:679)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatemen= tForCandidates(RDBMSQueryUtils.java:408)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull= (JDOQLQuery.java:947)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(= JDOQLQuery.java:370)
>> >=C2=A0 =C2=A0 =C2=A0at org.datanucleus.store.query.Query.execu= teQuery(Query.java:1744)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.datanucleus.store.query.Query.executeWithArray(Query.java= :1672)
>> >=C2=A0 =C2=A0 =C2=A0at org.datanucleus.store.query.Query.execu= te(Query.java:1654)
>> >=C2=A0 =C2=A0 =C2=A0at org.datanucleus.api.jdo.JDOQuery.execut= e(JDOQuery.java:221)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.ensureDbI= nit(MetaStoreDirectSql.java:172)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init&= gt;(MetaStoreDirectSql.java:130)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.ObjectStore.initialize(Objec= tStore.java:275)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectSt= ore.java:238)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtil= s.java:73)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.util.ReflectionUtils.newInstance(Reflection= Utils.java:133)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(R= awStoreProxy.java:56)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawSt= oreProxy.java:65)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.new= RawStore(HiveMetaStore.java:579)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get= MS(HiveMetaStore.java:557)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.cre= ateDefaultDB(HiveMetaStore.java:606)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.ini= t(HiveMetaStore.java:448)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init&= gt;(RetryingHMSHandler.java:66)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(= RetryingHMSHandler.java:72)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMS= Handler(HiveMetaStore.java:5570)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMS= Handler(HiveMetaStore.java:5565)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore= (HiveMetaStore.java:5798)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaS= tore.java:5723)
>> >=C2=A0 =C2=A0 =C2=A0at sun.reflect.NativeMethodAccessorImpl.in= voke0(Native Method)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces= sorImpl.java:57)
>> >=C2=A0 =C2=A0 =C2=A0at
>> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet= hodAccessorImpl.java:43)
>> >=C2=A0 =C2=A0 =C2=A0at java.lang.reflect.Method.invoke(Method.= java:606)
>> >=C2=A0 =C2=A0 =C2=A0at org.apache.hadoop.util.RunJar.main(RunJ= ar.java:212)
>> >
>> >
>> >
>> > *Changed the metastore DB name but the db is not created in M= YSQL
>> >
>> > Can anyone suggest it
>> >
>> >
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> > Amithsha
>
>

--20cf303346571898e80510ea1e77--