Re: Problem build hive index table

2011-10-11 Thread wd
You can look at your hadoop jobtracker log for the detail of the error. On Tue, Oct 11, 2011 at 5:04 PM, trang van anh wrote: > Dear Experts, > > I have problem with building index table in hive, step by step : > > 1. i created table  named pv_users (pageid int, age int ) that has around 31 > mi

RE: problem in hive

2011-10-11 Thread 陳春宏
Maybe you have check config file again Or put your hive config file on mail Best Regard Mail: harold.c...@sunplus-technology.com MSN: chen0...@hotmail.com SKYPE: chen0727 Mobil: 886-937545215 Tel: 886-2-8798-2988 #222 Fax:886-2-8751-5499 From: vikas srivastava [mailto:v

Tables not accessible after restarting Amazon EC2 instances

2011-10-11 Thread Agarwal, Ravindra (ASG)
Setup: I have setup a Hadoop cluster of 3 machines on Amazon EC2. Hive is running on top of it. Problem: Tables created on Hive are not accessible after Amazon EC2 instances are restarted (in other words - after the hosts in the cluster get renamed). Details: A table is created on the a

RE: problem in hive

2011-10-11 Thread vikas srivastava
Yup!!! With Regards Vikas Srivastava DWH & Analytics Team M: +91 9560885900 P: + 91 120 4770102 Email: vikas.srivast...@one97.net W: www.one97world.com One97 | Let's get talking ! From: Ankit Jain [mailto:ankitjainc...@gmail.com] Sent: Tuesday, October 11, 2011 6:22 PM To: user@hive

Re: problem in hive

2011-10-11 Thread Ankit Jain
Is it hive database created in MySQL ?? On Tue, Oct 11, 2011 at 5:55 PM, Vikas Srivastava < vikas.srivast...@one97.net> wrote: > that also i have dine.. i put msql connector in that lib > > On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain wrote: > >> Hello Vikas, >> >> I think you have to put the mysq

Re: problem in hive

2011-10-11 Thread Vikas Srivastava
that also i have dine.. i put msql connector in that lib On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain wrote: > Hello Vikas, > > I think you have to put the mysql Driver in lib dir of hive. > > Thanks, > Ankit > > On Tue, Oct 11, 2011 at 5:18 PM, Vikas Srivastava < > vikas.srivast...@one97.net> wr

Re: problem in hive

2011-10-11 Thread Ankit Jain
Hello Vikas, I think you have to put the mysql Driver in lib dir of hive. Thanks, Ankit On Tue, Oct 11, 2011 at 5:18 PM, Vikas Srivastava < vikas.srivast...@one97.net> wrote: > hey thanks for replay but already have at that place.. > > 2011/10/11 Harold(陳春宏) > >> >> >> You have to add jar file

Re: problem in hive

2011-10-11 Thread Vikas Srivastava
hey thanks for replay but already have at that place.. 2011/10/11 Harold(陳春宏) > > > You have to add jar file like this > add jar ../hive-0.6.0/lib/hive_contrib.jar; > > > > Best Regard > Mail: harold.c...@sunplus-technology.com > MSN: chen0...@hotmail.com > SKYPE: chen0727 > Mobil: 886-9375

RE: problem in hive

2011-10-11 Thread 陳春宏
You have to add jar file like this add jar ../hive-0.6.0/lib/hive_contrib.jar; Best Regard Mail: harold.c...@sunplus-technology.com MSN: chen0...@hotmail.com SKYPE: chen0727 Mobil: 886-937545215 Tel: 886-2-8798-2988 #222 Fax:886-2-8751-5499 -Original Message- From: vikas srivasta

Problem build hive index table

2011-10-11 Thread trang van anh
Dear Experts, I have problem with building index table in hive, step by step : 1. i created table named pv_users (pageid int, age int ) that has around 31 minion rows. 2 create index table create index pv_users_index on table pv_users(age) as 'compact' with deferred rebuild stored as RCFile.

problem in hive

2011-10-11 Thread vikas srivastava
Hi All, I facing a problem like I have installed hive on a new server and provide the connectivity with the namenode, Create a user in mysql and give the proper privileges to that user, Put that user in hive-site.xml and now when I fired a query like Show tables; Not showing any table when I