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

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

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

Re: problem in hive

2011-10-11 Thread Vikas Srivastava
hey thanks for replay but already have at that place.. 2011/10/11 Harold(陳春宏) harold.c...@sunplus-technology.com 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:

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(陳春宏) harold.c...@sunplus-technology.com

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 ankitjainc...@gmail.com 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

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 ankitjainc...@gmail.comwrote: Hello Vikas, I think you have to

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:

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

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 anh...@vtc.vn 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