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 58C4B61BC for ; Tue, 28 Jun 2011 06:10:52 +0000 (UTC) Received: (qmail 56759 invoked by uid 500); 28 Jun 2011 06:10:50 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 55547 invoked by uid 500); 28 Jun 2011 06:10:25 -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 55539 invoked by uid 99); 28 Jun 2011 06:10:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Jun 2011 06:10:21 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.139.91.192] (HELO nm7-vm0.bullet.mail.sp2.yahoo.com) (98.139.91.192) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 28 Jun 2011 06:10:12 +0000 Received: from [98.139.91.66] by nm7.bullet.mail.sp2.yahoo.com with NNFMP; 28 Jun 2011 06:09:52 -0000 Received: from [98.139.91.14] by tm6.bullet.mail.sp2.yahoo.com with NNFMP; 28 Jun 2011 06:09:52 -0000 Received: from [127.0.0.1] by omp1014.mail.sp2.yahoo.com with NNFMP; 28 Jun 2011 06:09:52 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 144601.2963.bm@omp1014.mail.sp2.yahoo.com Received: (qmail 73682 invoked by uid 60001); 28 Jun 2011 06:09:51 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1309241391; bh=NGW2vgI1qIEt4IpCptDulOXcbFcCgy+qpxVARYRO+Wc=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=jKD9BYCYkUyPu653Wftmk/OCPQ2q8ESAvqkVNFajd1/NOx1QgohuTN/eJ5xXD/bgfSPgxIEc5fpMubfsJYH5Xs6xnRcs+Z47UUj3Kn2c9poXyk+jyrYlPBZ/NFhmRuLftDMdNRzTgk2C11B9ERucUd1P6663sVO7xnoVPYhpDCA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=mpRCqWVuUsE5TxGvRCcZomVgPpamS87lXmEcN/JhZD2ihZ7mrVf7UJWG4b17q5IAeGdgL7/D9jfEgvOQHw8BubSuU4uMx8YpdVqL/rolV3wsGE0H3LgHkR2Bb4KcZX9/PigxJBxaeIbPyjbo9Nymn3aA19qSp37M0PC9oTTm1NA=; X-YMail-OSG: J6MchI8VM1m.XnKzcosMkEH0nCRut0NLr5X8TpWv5YYeA6E JjZ9wET4rjN9LYwx8ePEM6QqwuhIWtJbNEMtrmp_Eq8MsoUZFAv3PxJlMBo9 YlnFVapQCvSLrt6esRrZhFNcawJxlJwiJtlXh99UaKkhhhv_v4vLpA9KPfIt wmV5qcPgoZRl25msusoA9JTwKpZkBSmsSONfxXt8hnOYsiN6dQxnYyEG601V 2Wf9pOMHrNG1iVc6ktVfqX2.KBj0AzccPql3_sDGoP70.db5VHHuv.dDZZ9w _AbuUfL2ESnxh9_BxmH_nMA7s9lMYARRijmPxO6lPwdpSj4EOHRPBzmgpfdC 9KNX.CgjSJj6bU5GIzmVpQXHJfI7WTmPHZYZ4TB31Fp.xBOxsF4.vM3SVyXa L6A2uzsULwhaxPJgb1fPJ.G1rHd9uwDote9C0qwSssNILokUz1GzBXeRnS0v SlXYbC.8C3hzMuGJ2g10gAHNM5V5lbEaAyQNkBv93I55yW7pRHXtzeMel395 jqv6DQbxNUAZQ.FgLcoMVHWNwTjWTfkvYQDp1wNUsFMo1sW16CWaTzquS2QR 1bnr10NGjh0r.4QoiSlBU Received: from [107.3.143.80] by web110515.mail.gq1.yahoo.com via HTTP; Mon, 27 Jun 2011 23:09:46 PDT X-Mailer: YahooMailWebService/0.8.112.307740 Message-ID: <1309241386.73287.YahooMailNeo@web110515.mail.gq1.yahoo.com> Date: Mon, 27 Jun 2011 23:09:46 -0700 (PDT) From: Ayon Sinha Reply-To: Ayon Sinha Subject: Using Hive Thrift SerDe To: Hive Mailinglist MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1823072112-1309241386=:73287" --0-1823072112-1309241386=:73287 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=0AI can't seem to make Hive find the Thrift SerDe. What do I need to= do?=0A=0Ahive> add jar /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar; =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0=0AAdded /usr/li= b/hive/lib/hive-serde-0.7.0-cdh3u0.jar to class path=0AAdded resource: /usr= /lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar=0Ahive> CREATE external TABLE scr= atch.sk_logs (user_id bigint, request_type int) =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0= =0A=A0 =A0 > =A0 =A0ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.thrift.= ThriftByteStreamTypedSerDe" LOCATION '/user/ayon/hiveserdetest' ;=0AFAILED:= Error in metadata: Cannot validate serde: org.apache.hadoop.hive.serde2.th= rift.ThriftByteStreamTypedSerDe=0AFAILED: Execution Error, return code 1 fr= om org.apache.hadoop.hive.ql.exec.DDLTask=0Ahive>=A0=0A=0A=0A=A0=0A-Ayon=0A= See My Photos on Flickr=0AAlso check out my Blog for answers to commonly as= ked questions.=0A --0-1823072112-1309241386=:73287 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
I can't seem to make Hive find the Thrift SerDe. What do I need to do?

hive> add jar /= usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar;         &= nbsp;                    =                     &nbs= p;                 
Added /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar to class pa= th
Added resource: /usr/lib/hive/lib/hive-serde-0.7= .0-cdh3u0.jar
hive> CREATE external TABLE scratc= h.sk_logs (user_id bigint, request_type int)         &n= bsp;                     =                     =
    >    ROW FORMAT SERDE "= org.apache.hadoop.hive.serde2.thrift.ThriftByteStreamTypedSerDe" LOCATION '= /user/ayon/hiveserdetest' ;
FAILED: Error in metada= ta: Cannot validate serde: org.apache.hadoop.hive.serde2.thrift.ThriftByteStreamTypedSerDe
FAILED: Execution Error, return code 1 from org.apache= .hadoop.hive.ql.exec.DDLTask
hive> <= /div>


 
--0-1823072112-1309241386=:73287--