Re: Problem starting Hive

teswhite.com] > Sent: 17 October 2013 18:53 > To: 'user@hive.apache.org'; 'nimar...@pssd.com' > Cc: 'Eric Mizell'; Rommel Garcia; Yi Zhang > Subject: RE: Problem starting Hive > > It looks good to me… > > >

RE: Problem starting Hive

0:03 AM To: user@hive.apache.org; 'nimar...@pssd.com' Cc: 'Eric Mizell'; Rommel Garcia; Yi Zhang Subject: RE: Problem starting Hive Hi, Try this also in hive-site javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver Driver class name for a JDBC metastore Tha

RE: Problem starting Hive

'; 'nimar...@pssd.com' Cc: 'Eric Mizell'; Rommel Garcia; Yi Zhang Subject: RE: Problem starting Hive It looks good to me... javax.jdo.option.ConnectionURL jdbc:mysql://bigdata5.bateswhite.com:3306/hadoop JDBC connect string for a JDBC metastore javax.jdo.opti

RE: Problem starting Hive

Remove this file /tmp/hive/hive.log and try again using hdfs user. Thanks & Regards, Rinku Garg From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: 17 October 2013 19:09 To: Garg, Rinku Cc: user@hive.apache.org Subject: RE: Problem starting Hive Hi Rinku, I tried running hiv

RE: Problem starting Hive

@hive.apache.org Subject: RE: Problem starting Hive Hi, Are you logged in using hive specific user or as root user. /tmp/hive/hive.log file may be created once root user and it can’t be updated by any other user so it says permission denied. Thanks & Regards, Rinku Garg From: Clay McDo

RE: Problem starting Hive

: 17 October 2013 18:41 To: 'Eric Mizell'; user@hive.apache.org Cc: Rommel Garcia; Yi Zhang; Chris Hackett; Steve Puckett; Terry Padgett Subject: RE: Problem starting Hive Thanks Eric! My Hive log is attached. From: Eric Mizell [mailto:emiz...@hortonworks.com] Sent: Thursday, October 17, 2

RE: Problem starting Hive

Mizell; user@hive.apache.org; Yi Zhang; Chris Hackett; Steve Puckett; Terry Padgett Subject: Re: Problem starting Hive Do you have the MySQL connector jar on you hive lib? Rommel Garcia Big Data Solutions Engineer - Southeast Hortonworks, Inc. Email: rgar...@hortonworks.com<mailto:r

RE: Problem starting Hive

: 'nimar...@pssd.com' Cc: 'user@hive.apache.org'; 'Eric Mizell'; Rommel Garcia; Yi Zhang Subject: RE: Problem starting Hive Nick, let me check... From: Martin, Nick [mailto:] Sent: Thursday, October 17, 2013 9:00 AM To: user@hive.apache.org<mailto:user@hive.apache.o

RE: Problem starting Hive

Nick, let me check... From: Martin, Nick [mailto:] Sent: Thursday, October 17, 2013 9:00 AM To: user@hive.apache.org Subject: RE: Problem starting Hive Hi Clay, Quick housekeeping/config check...is the URI in /etc/hive/conf/hive-site.xml pointing to the right place? From: Clay McDonald

RE: Problem starting Hive

Thanks Eric! My Hive log is attached. From: Eric Mizell [mailto:emiz...@hortonworks.com] Sent: Thursday, October 17, 2013 8:59 AM To: Clay McDonald Cc: Rommel Garcia; Yi Zhang; user@hive.apache.org; Chris Hackett; Steve Puckett; Clay McDonald; Terry Padgett Subject: Re: Problem starting Hive

RE: Problem starting Hive

Hi Clay, Quick housekeeping/config check...is the URI in /etc/hive/conf/hive-site.xml pointing to the right place? From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: Thursday, October 17, 2013 8:54 AM To: 'Eric Mizell'; Rommel Garcia; Yi Zhang; 'user@hive.apache.org' Cc: Chris Hac

Re: Problem starting Hive with local metastore on mysql

Yup. Thanks for you help J-D, much appreciated! On Wed, Jan 19, 2011 at 4:41 PM, Jean-Daniel Cryans wrote: > Have a looksee here http://wiki.apache.org/hadoop/Hive/FAQ > > J-D > > On Wed, Jan 19, 2011 at 4:38 PM, vipul sharma > wrote: > > Thanks! > > > > Now I am hitting mysql bug of max key len

Re: Problem starting Hive with local metastore on mysql

Have a looksee here http://wiki.apache.org/hadoop/Hive/FAQ J-D On Wed, Jan 19, 2011 at 4:38 PM, vipul sharma wrote: > Thanks! > > Now I am hitting mysql bug of max key length: Specified key was too long; > max key length is 767 bytes > > 11/01/19 16:34:47 ERROR DataNucleus.Datastore: Error throw

Re: Problem starting Hive with local metastore on mysql

Thanks! Now I am hitting mysql bug of max key length: Specified key was too long; max key length is 767 bytes 11/01/19 16:34:47 ERROR DataNucleus.Datastore: Error thrown executing CREATE TABLE `SD_PARAMS` ( `SD_ID` BIGINT NOT NULL, `PARAM_KEY` VARCHAR(256) BINARY NOT NULL, `PARAM_VALU

Re: Problem starting Hive with local metastore on mysql

Try setting this in your hive-site: datanucleus.transactionIsolation repeatable-read datanucleus.valuegeneration.transactionIsolation repeatable-read J-D On Wed, Jan 19, 2011 at 4:05 PM, vipul sharma wrote: > Hi, > > we had been running cloudera distribution of hadoop. We installed