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 94FB4D21C for ; Wed, 22 May 2013 17:17:57 +0000 (UTC) Received: (qmail 23587 invoked by uid 500); 22 May 2013 17:17:56 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 23238 invoked by uid 500); 22 May 2013 17:17:56 -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 23208 invoked by uid 99); 22 May 2013 17:17:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 May 2013 17:17:55 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Sanjay.Subramanian@wizecommerce.com designates 65.55.88.13 as permitted sender) Received: from [65.55.88.13] (HELO tx2outboundpool.messaging.microsoft.com) (65.55.88.13) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 May 2013 17:17:50 +0000 Received: from mail163-tx2-R.bigfish.com (10.9.14.239) by TX2EHSOBE008.bigfish.com (10.9.40.28) with Microsoft SMTP Server id 14.1.225.23; Wed, 22 May 2013 17:17:27 +0000 Received: from mail163-tx2 (localhost [127.0.0.1]) by mail163-tx2-R.bigfish.com (Postfix) with ESMTP id 34D0E1E06DD for ; Wed, 22 May 2013 17:17:27 +0000 (UTC) X-Forefront-Antispam-Report: CIP:157.56.232.197;KIP:(null);UIP:(null);IPV:NLI;H:BLUPRD0411HT005.namprd04.prod.outlook.com;RD:none;EFVD:NLI X-SpamScore: 0 X-BigFish: PS0(zz9371I181fMc85ehdd85k9a6kzz1f42h1ee6h1de0h1fdah1202h1e76h1d1ah1d2ah1fc6hzz18c673h8275bh8275dhz2fh2a8h668h839hbe3he5bhf0ah1288h12a5h12bdh137ah1441h1504h1537h153bh162dh1631h1758h18e1h1946h19b5h1ad9h1b0ah1bceh1d0ch1d2eh1d3fh1dc1h1155h) Received-SPF: pass (mail163-tx2: domain of wizecommerce.com designates 157.56.232.197 as permitted sender) client-ip=157.56.232.197; envelope-from=Sanjay.Subramanian@wizecommerce.com; helo=BLUPRD0411HT005.namprd04.prod.outlook.com ;.outlook.com ; Received: from mail163-tx2 (localhost.localdomain [127.0.0.1]) by mail163-tx2 (MessageSwitch) id 1369242989986149_22338; Wed, 22 May 2013 17:16:29 +0000 (UTC) Received: from TX2EHSMHS028.bigfish.com (unknown [10.9.14.230]) by mail163-tx2.bigfish.com (Postfix) with ESMTP id E20AC220136 for ; Wed, 22 May 2013 17:16:29 +0000 (UTC) Received: from BLUPRD0411HT005.namprd04.prod.outlook.com (157.56.232.197) by TX2EHSMHS028.bigfish.com (10.9.99.128) with Microsoft SMTP Server (TLS) id 14.1.225.23; Wed, 22 May 2013 17:16:28 +0000 Received: from BLUPRD0411MB426.namprd04.prod.outlook.com ([169.254.10.213]) by BLUPRD0411HT005.namprd04.prod.outlook.com ([10.255.127.40]) with mapi id 14.16.0311.000; Wed, 22 May 2013 17:16:26 +0000 From: Sanjay Subramanian To: "user@hive.apache.org" Subject: Re: Hive skipping first line Thread-Topic: Hive skipping first line Thread-Index: Ac5XDWvRcwo89wJ6SQCqkOqBx/sMof//j/qA Date: Wed, 22 May 2013 17:16:25 +0000 Message-ID: In-Reply-To: <000901ce570d$7f286c30$7d794490$@innoplexia.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.255.127.4] Content-Type: multipart/alternative; boundary="_000_CDC24B4B7A57sanjaysubramanianwizecommercecom_" MIME-Version: 1.0 X-OriginatorOrg: wizecommerce.com X-Virus-Checked: Checked by ClamAV on apache.org --_000_CDC24B4B7A57sanjaysubramanianwizecommercecom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Can u try doing a Hive -e "select * from tablename" See how many rows this gets u Thanks sanjay From: Tim Bittersohl > Reply-To: "user@hive.apache.org" > Date: Wednesday, May 22, 2013 9:57 AM To: "user@hive.apache.org" > Subject: Hive skipping first line Hi, I got some little problem with the content of hive tables. These table=92s contents are generated by pig and do so have no header line= , they are accessed as =93TextFile=94 with an external hive table. When I f= etch records through the java hive library (Version: 0.10.0-cdh4.2.0) with = the =93hiveClient.fetchN(rowncount)=94 command, it seems like he always ski= p the first line of data. (perhaps he=92s expecting a header row?) How can I avoid this? Greetings, Tim Bittersohl CONFIDENTIALITY NOTICE =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This email message and any attachments are for the exclusive use of the int= ended recipient(s) and may contain confidential and privileged information.= Any unauthorized review, use, disclosure or distribution is prohibited. If= you are not the intended recipient, please contact the sender by reply ema= il and destroy all copies of the original message along with any attachment= s, from your computer system. If you are the intended recipient, please be = advised that the content of this message is subject to access, review and d= isclosure by the sender's Email System Administrator. --_000_CDC24B4B7A57sanjaysubramanianwizecommercecom_ Content-Type: text/html; charset="Windows-1252" Content-ID: <0B28E117892E834D8ED0EC9159763310@namprd04.prod.outlook.com> Content-Transfer-Encoding: quoted-printable
Can u try doing a 
Hive -e "select * from tablename"
See how many rows this gets u 
Thanks

sanjay

From: Tim Bittersohl <tim@innoplexia.com>
Reply-To: "user@hive.apache.org" <user@hive.apache.org>
Date: Wednesday, May 22, 2013 9:57 = AM
To: "user@hive.apache.org" <user@hive.apache.org>
Subject: Hive skipping first line

Hi,

 

I got some little problem with = the content of hive tables.

These table=92s contents are ge= nerated by pig and do so have no header line, they are accessed as =93TextF= ile=94 with an external hive table. When I fetch records through the java h= ive library (Version: 0.10.0-cdh4.2.0) with the =93hiveClient.fetchN(rowncount)=94 command, it seems like he always sk= ip the first line of data. (perhaps he=92s expecting a header row?)<= /p>

How can I avoid this?

 

Greetings,

Tim Bittersohl


CONFIDENTIALITY NOTICE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This email message and any attachments are for the exclusive use of the int= ended recipient(s) and may contain confidential and privileged information.= Any unauthorized review, use, disclosure or distribution is prohibited. If= you are not the intended recipient, please contact the sender by reply email and destroy all copies of the ori= ginal message along with any attachments, from your computer system. If you= are the intended recipient, please be advised that the content of this mes= sage is subject to access, review and disclosure by the sender's Email System Administrator.
--_000_CDC24B4B7A57sanjaysubramanianwizecommercecom_--