hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject RE: hive 1.1.0 Error while Metastore starting
Date Tue, 10 Mar 2015 08:23:45 GMT
>From the sql code do you know which table and primary key it is complaining?

I have used the script for Oracle 11g and modified one work with SAP Sybase ASE 15.7 and they
both worked fine.


HTH


Mich Talebzadeh

http://talebzadehmich.wordpress.com

Publications due shortly:
Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Ltd,
its subsidiaries or their employees, unless expressly so 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:amithsha92@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,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.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)



Thanks & Regards
Amithsha


On Tue, Mar 10, 2015 at 1:02 PM, Amith sha <amithsha92@gmail.com> wrote:
> ok thank you Srinivas wil try it and reply now Thanks & Regards 
> Amithsha
>
>
> On Tue, Mar 10, 2015 at 12:59 PM, Srinivas Thunga 
> <srinivas.thunga@gmail.com> 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 <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> 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 
>>> >> hive in .bashrc But the same mysql  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.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.<init>(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.<init>(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.<init>(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
>>> >
>>> >
>>
>>


Mime
View raw message