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 A9DB917D18 for ; Tue, 10 Mar 2015 08:29:40 +0000 (UTC) Received: (qmail 6028 invoked by uid 500); 10 Mar 2015 08:29:33 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 5963 invoked by uid 500); 10 Mar 2015 08:29:33 -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 5953 invoked by uid 99); 10 Mar 2015 08:29:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Mar 2015 08:29:33 +0000 X-ASF-Spam-Status: No, hits=-0.5 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of amithsha92@gmail.com designates 209.85.220.170 as permitted sender) Received: from [209.85.220.170] (HELO mail-vc0-f170.google.com) (209.85.220.170) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Mar 2015 08:29:07 +0000 Received: by mail-vc0-f170.google.com with SMTP id hq11so17990vcb.1 for ; Tue, 10 Mar 2015 01:29:06 -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:content-transfer-encoding; bh=ws43JZFYD8lXDrmtN70IK0h0pyQaey+V8KyKW242FI8=; b=zQfWKVwxwzcMHtfc/8Y+Pdkpq0OV4yGx/y0BPNAE59Cq+ntzPOMPQSo4mNo/Jx0+ae 49WcCrlcKEwMwC4GTkozl2RqknHOJySi2iCS/sjYU23S4u4H3kDuE7gP9s3bN6zIr/hT 6TlWi/6Ww2y6Duyi7EcL9upzs6XzngaXu8GJQ5NGCVW/EHd8OFkzsnyJ80fF2OGaSE3h T8bFeo28di0b5IPstVZl8EswZa6s8cIDs56HXzzcm1BVrQOh+AJPyFYedSRKDl46qozQ vRnIddc6rh32ZvgYBJgP6STjeyvFwNo175Lw3K3+R5QzNzDlv9dBnSvmfUFbfOynMXBg Ejtg== MIME-Version: 1.0 X-Received: by 10.52.138.107 with SMTP id qp11mr38208713vdb.24.1425976146024; Tue, 10 Mar 2015 01:29:06 -0700 (PDT) Received: by 10.52.96.5 with HTTP; Tue, 10 Mar 2015 01:29:05 -0700 (PDT) In-Reply-To: <018a01d05b0b$86d0e7b0$9472b710$@co.uk> References: <018a01d05b0b$86d0e7b0$9472b710$@co.uk> Date: Tue, 10 Mar 2015 13:59:05 +0530 Message-ID: Subject: Re: hive 1.1.0 Error while Metastore starting From: Amith sha To: user@hive.apache.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org after executing this command mysql>use metastoreDB mysql>source hive-schema--0.14.0.mysql.sql i am getting this ERROR 1061 (42000): Duplicate key name 'PCS_STATS_IDX' Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) ERROR 1050 (42S01): Table 'TXNS' already exists ERROR 1050 (42S01): Table 'TXN_COMPONENTS' already exists ERROR 1050 (42S01): Table 'COMPLETED_TXN_COMPONENTS' already exists ERROR 1050 (42S01): Table 'NEXT_TXN_ID' already exists Query OK, 1 row affected (0.17 sec) ERROR 1050 (42S01): Table 'HIVE_LOCKS' already exists ERROR 1061 (42000): Duplicate key name 'HL_TXNID_IDX' ERROR 1050 (42S01): Table 'NEXT_LOCK_ID' already exists Query OK, 1 row affected (0.14 sec) ERROR 1050 (42S01): Table 'COMPACTION_QUEUE' already exists ERROR 1050 (42S01): Table 'NEXT_COMPACTION_QUEUE_ID' already exists Query OK, 1 row affected (0.13 sec) ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Thanks & Regards Amithsha On Tue, Mar 10, 2015 at 1:53 PM, Mich Talebzadeh wrot= e: > From the sql code do you know which table and primary key it is complaini= ng? > > I have used the script for Oracle 11g and modified one work with SAP Syba= se 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 messa= ge shall not be understood as given or endorsed by Peridale Ltd, its subsid= iaries or their employees, unless expressly so stated. It is the responsibi= lity of the recipient to ensure that this email is virus free, therefore ne= ither Peridale Ltd, its subsidiaries nor their employees accept any respons= ibility. > > > -----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/vali= dating 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 Meth= od) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstr= uctorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delegati= ngConstructorAccessorImpl.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 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 >> wrote: >>> i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tabl= es. >>> >>> Thanks & Regards, >>> >>> Srinivas T >>> >>> On Tue, Mar 10, 2015 at 12:55 PM, Amith sha wrot= e: >>>> >>>> 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 the= re. >>>> > >>>> > 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(NativeConst= ructorAccessorImpl.java:57) >>>> >> > at >>>> >> > >>>> >> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delegat= ingConstructorAccessorImpl.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:1= 054) >>>> >> > 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:94= 9) >>>> >> > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:79= 5) >>>> >> > at >>>> >> > com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:25= 4) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStateme= nt(AbstractTable.java:760) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableIm= pl.java:648) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.table.TableImpl.validateIndices(Table= Impl.java:593) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(T= ableImpl.java:390) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(= ClassTable.java:3463) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performT= ablesValidation(RDBMSStoreManager.java:3464) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClass= TablesAndValidate(RDBMSStoreManager.java:3190) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBM= SStoreManager.java:2841) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(Abs= tractSchemaTransaction.java:122) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSSto= reManager.java:1605) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.AbstractStoreManager.addClass(AbstractStore= Manager.java:954) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(R= DBMSStoreManager.java:679) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementFor= Candidates(RDBMSQueryUtils.java:408) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDO= QLQuery.java:947) >>>> >> > at >>>> >> > >>>> >> > org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQ= LQuery.java:370) >>>> >> > at >>>> >> > org.datanucleus.store.query.Query.executeQuery(Query.java:1744) >>>> >> > at >>>> >> > org.datanucleus.store.query.Query.executeWithArray(Query.java:167= 2) >>>> >> > 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.(MetaSt= oreDirectSql.java:130) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectSto= re.java:275) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.= java:238) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.ja= va:73) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtil= s.java:133) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.RawStoreProxy.(RawStorePro= xy.java:56) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreP= roxy.java:65) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawS= tore(HiveMetaStore.java:579) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(H= iveMetaStore.java:557) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createD= efaultDB(HiveMetaStore.java:606) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(Hi= veMetaStore.java:448) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.RetryingHMSHandler.(Retryi= ngHMSHandler.java:66) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(Retr= yingHMSHandler.java:72) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHand= ler(HiveMetaStore.java:5570) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHand= ler(HiveMetaStore.java:5565) >>>> >> > at >>>> >> > >>>> >> > org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(Hiv= eMetaStore.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(NativeMethodAccessorI= mpl.java:57) >>>> >> > at >>>> >> > >>>> >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodA= ccessorImpl.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 >>>> > >>>> > >>> >>> >