Re: Hive 0.13/Hadoop 0.20 ORC probleme

2014-12-11 Thread Jander g
y, > I think it is more about hadoop CLASSPATH problem, because the same built > Hive 0.13 worked well with Hadoop 2.6 > I ll try to find a way to change hadoop classpath so it will use the new > protobu instead of 2.4 > > > > > On Thu, Dec 11, 2014 at 11:48 AM, Jander g

Re: Hive 0.13/Hadoop 0.20 ORC probleme

2014-12-11 Thread Jander g
hi,Amjad protobuf 2.4 isn't compatible with protobuf 2.5, so you should regen OrcProto.java using protobuf 2.4.0, and then rebuild hive. I hope it helps. On Wed, Dec 10, 2014 at 6:28 PM, Amjad ALSHABANI wrote: > > Hello everybody. > > I have a problem when using ORC file format in Hive 0.13.

hive server2 error upgrade hive from 0.10.0 to 0.13.1

2014-11-26 Thread Jander g
Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using protobuf 2.4.0a, then it is ok to run hive query and metastore. when i use hive server2 using bee

upgrade hive-0.10.0-cdh4.6.0 to hive-0.13.1-cdh5.2.0

2014-11-26 Thread Jander g
Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using protobuf 2.4.0a, then it is ok to run hive query and metastore. when i use hive server2 using bee

Re: Hive 0.12.0 mysql metastore exception

2014-01-22 Thread Jander g
(Hive.java:1143) at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128) at org.apache.hadoop.hive.ql.exec.DDLTask.switchDatabase (DDLTask.java:3479) Best Regards, On Thu, Jan 23, 2014 at 1:27 PM, Jov wrote: > > 2014/1/23 Jander g > >> Caused by:

Hive 0.12.0 mysql metastore exception

2014-01-22 Thread Jander g
Hi, guys I upgrade hive 0.70 to hive 0.12.0 recently. We resolve some problems, but the one as follows puzzles me. We have thousands jobs every day and that will have about 40 this errors. I increase mysql max connections from 2000 to 4000 and I found the history max connection less than 2000. A

Re: Handling hyphens in table/database/usernames

2011-11-01 Thread Jander g
riram > > ps: Not a huge deal, but is there a reason why Hive won't support hyphens > in database/table names? > > From: Jander g > Reply-To: "user@hive.apache.org" > Date: Mon, 31 Oct 2011 23:05:13 -0700 > To: "user@hive.apache.org" > Subject: Re:

Re: Handling hyphens in table/database/usernames

2011-10-31 Thread Jander g
Hive does not support '-' as a database name, which pattern is "[\\w_]+", so you can use '_' instead On Tue, Nov 1, 2011 at 9:29 AM, Sriram Krishnan wrote: > Hi, > > Does anyone know how to handle hyphens in any of the following? > Specifically, we have a user with a hyphenated username – and I c

Re: Copying a Hive metastore

2011-10-10 Thread Jander g
We develop a little tool which can hack to get create table HQL and insert data HQL from hive metastore. Thus the hive metastore can be restored. On 10/11/11, Steven Wong wrote: > How do you generate an HQL file from a metastore? > > > -Original Message----- > From: Jander

Why set mapred.reduce.tasks does not work in hive-0.70-rc1 edition

2011-10-10 Thread Jander g
Hi, all Why set mapred.reduce.tasks does not work in hive-0.70-rc1 edition? The source code follows: private void setNumberOfReducers() throws IOException { // this is a temporary hack to fix things that are not fixed in the compiler Integer numReducersFromWork = work.getNumReduceTasks()

Re: Copying a Hive metastore

2011-10-08 Thread Jander g
Yes, you are right. I had merged two hive metastore several months ago. I restored one metastore to HQL and run this hql file to finish the task. Just as Edward says, I interact with HQL directly. Hope this helps. On 10/1/11, Steven Wong wrote: > I think going to MySQL directly will have the prob

Re: Setting up stats database

2011-08-17 Thread Jander g
Hi,wd You should configure "hive.stats.dbconnectionstring" as follows. hive.stats.dbconnectionstring jdbc:postgresql://localhost/hive_statsdb?createDatabaseIfNotExist=true&user=hive&password=pwd The default connection string for the database that stores temporary hive statistics. Regards,

hadoop conf "fs.default.name" can't be setted ip:port format directly?

2011-08-10 Thread Jander g
Hi, all In order to use hive, Hadoop conf "fs.default.name" must be setted hostname:port otherwise Hive will throw Wrong FS exception. In my opinion, ip and hostname is equivalent. Is there something wrong in my Hive conf? *Any Help Will* *be greatly appreciated.*-- Thanks, Jander