Re: exception when using Hive 0.12 with MySQL metastore

2013-10-23 Thread SF Hadoop
Never mind. Figured out where that was. Thanks. On Wed, Oct 23, 2013 at 2:27 PM, SF Hadoop wrote: > Where is package.jdo located? The one that you changed? > > Thanks. > > > > On Wed, Oct 23, 2013 at 1:22 PM, Timothy Potter wrote: > >> I updated package.jdo to use COMMENT instead of FCOMMEN

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-23 Thread SF Hadoop
Where is package.jdo located? The one that you changed? Thanks. On Wed, Oct 23, 2013 at 1:22 PM, Timothy Potter wrote: > I updated package.jdo to use COMMENT instead of FCOMMENT (which is > something I had to do for HCatalog a long while back) ... may not be the > "right" solution but worked

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-23 Thread Timothy Potter
I updated package.jdo to use COMMENT instead of FCOMMENT (which is something I had to do for HCatalog a long while back) ... may not be the "right" solution but worked for me. Cheers, Tim On Wed, Oct 23, 2013 at 2:09 PM, SF Hadoop wrote: > Has anyone come up with further information on this is

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-23 Thread SF Hadoop
Has anyone come up with further information on this issue? I am experiencing the same thing. Hive is set to auto-create if not exist yet it still fails. I cannot create *any* table at all. Any help is appreciated. On Sat, Oct 19, 2013 at 11:56 PM, Jov wrote: > can you confirm the script c

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-19 Thread Jov
can you confirm the script content?there may be bug,you can open a issue. jov On Oct 20, 2013 1:11 PM, "Zhang Xiaoyu" wrote: > > Hi, Jov, > Thanks. I understand turn on those two properties resolve the problems. But I run the hive 0.12 scheme script. I assume it should create all required tables.

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-19 Thread Zhang Xiaoyu
Hi, Jov, Thanks. I understand turn on those two properties resolve the problems. But I run the hive 0.12 scheme script. I assume it should create all required tables. Johnny On Sat, Oct 19, 2013 at 7:44 PM, Jov wrote: > jov > > On Oct 20, 2013 8:07 AM, "Zhang Xiaoyu" wrote: > > > > Hi, all, >

Re: exception when using Hive 0.12 with MySQL metastore

2013-10-19 Thread Jov
jov On Oct 20, 2013 8:07 AM, "Zhang Xiaoyu" wrote: > > Hi, all, > When I using Hive 0.12 with MySQL metastore. I set those properties in hive-site.xml. > datanucleus.autoCreateSchema = false > datanucleus.autoCreateTables= false you should set these properties to true,then hive will auto add new c

exception when using Hive 0.12 with MySQL metastore

2013-10-19 Thread Zhang Xiaoyu
Hi, all, When I using Hive 0.12 with MySQL metastore. I set those properties in hive-site.xml. datanucleus.autoCreateSchema = false datanucleus.autoCreateTables= false In beeline, "show tables" is fine, but create a new table got below exception, any idea? Since I create the metastore table by the