Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 398E2971D for ; Tue, 11 Oct 2011 11:48:29 +0000 (UTC) Received: (qmail 10370 invoked by uid 500); 11 Oct 2011 11:48:28 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 10318 invoked by uid 500); 11 Oct 2011 11:48:28 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 10309 invoked by uid 99); 11 Oct 2011 11:48:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Oct 2011 11:48:28 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of vikas.srivastava@one97.net designates 209.85.215.176 as permitted sender) Received: from [209.85.215.176] (HELO mail-ey0-f176.google.com) (209.85.215.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Oct 2011 11:48:21 +0000 Received: by eyh5 with SMTP id 5so2889403eyh.35 for ; Tue, 11 Oct 2011 04:48:01 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.65.76 with SMTP id h12mr39039670fai.7.1318333680804; Tue, 11 Oct 2011 04:48:00 -0700 (PDT) Received: by 10.152.22.194 with HTTP; Tue, 11 Oct 2011 04:48:00 -0700 (PDT) X-Originating-IP: [125.63.68.99] In-Reply-To: <4e94163c.021d440a.5860.0d90SMTPIN_ADDED@mx.google.com> References: <4F6B25AFFFCAFE44B6259A412D5F9B10395A67CF@ExchMBX104.netflix.com> <4F6B25AFFFCAFE44B6259A412D5F9B10395A67E4@ExchMBX104.netflix.com> <4F6B25AFFFCAFE44B6259A412D5F9B10395A6B0B@ExchMBX104.netflix.com> <4e93f076.6539440a.33e5.ffffe7a0@mx.google.com> <4e94163c.021d440a.5860.0d90SMTPIN_ADDED@mx.google.com> Date: Tue, 11 Oct 2011 17:18:00 +0530 Message-ID: Subject: Re: problem in hive From: Vikas Srivastava To: user@hive.apache.org Content-Type: multipart/alternative; boundary=0015174753e0bd63e404af047ae6 X-Virus-Checked: Checked by ClamAV on apache.org --0015174753e0bd63e404af047ae6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable hey thanks for replay but already have at that place.. 2011/10/11 Harold(=E9=99=B3=E6=98=A5=E5=AE=8F) > > > You have to add jar file like this > add jar ../hive-0.6.0/lib/hive_contrib.jar; > > > > Best Regard > Mail: Harold.Chen@sunplus-technology.com > MSN: chen0727@hotmail.com > SKYPE: chen0727 > Mobil: 886-937545215 > Tel: 886-2-8798-2988 #222 > Fax:886-2-8751-5499 > > -----Original Message----- > From: vikas srivastava [mailto:vikas.srivastava@one97.net] > Sent: Tuesday, October 11, 2011 3:29 PM > To: user@hive.apache.org > Subject: problem in hive > > 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 fired > Desc table or select table is throwing an error > > hive> desc aircel_obd; > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > The hive.log are :- > > 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > 2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365= )) > - FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > 2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365= )) > - FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > Please help I m stuck here.... > > > With Regards > Vikas Srivastava > > DWH & Analytics Team > M: +91 9560885900 > P: + 91 120 4770102 > Email: vikas.srivastava@one97.net > W: www.one97world.com > > One97 | Let's get talking ! > > > > --=20 With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking ! --0015174753e0bd63e404af047ae6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable hey thanks for replay but already have at that place..

2011/10/11 Harold(=E9=99=B3=E6= =98=A5=E5=AE=8F) <harold.chen@sunplus-technology.com>


You have to add jar file like this
add jar ../hive-0.6.0/lib/hive_contrib.jar;



Best Regard
Mail: =C2=A0 Harold.C= hen@sunplus-technology.com
MSN: =C2=A0 chen0727@hotmail.com
SKYPE: =C2=A0chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499

-----Original Message-----
From: vikas srivastava [mailto:vikas.srivastava@one97.net]
Sent: Tuesday, October 11, 2011 3:29 PM
To: user@hive.apache.org
Subject: problem in hive

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 fired
Desc table or select table is throwing an error

hive> desc aircel_obd;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask


The hive.log are :-

2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))=
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" req= uires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))=
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

Please help I m stuck here....


With Regards
Vikas Srivastava

DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97= .net
W: www.one97world.c= om

One97 | Let's get talking !






--
With Regards
Vikas Srivastava

DWH & Ana= lytics Team
Mob:+91 9560885900
One97 | Let's get talking= !

--0015174753e0bd63e404af047ae6--