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
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
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
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:
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
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
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
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:
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
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
10 matches
Mail list logo