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 869B8DEF5 for ; Thu, 23 May 2013 12:02:02 +0000 (UTC) Received: (qmail 47444 invoked by uid 500); 23 May 2013 12:02:01 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 47106 invoked by uid 500); 23 May 2013 12:02:00 -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 47097 invoked by uid 99); 23 May 2013 12:02:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 May 2013 12:02:00 +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 deanwampler@gmail.com designates 209.85.216.46 as permitted sender) Received: from [209.85.216.46] (HELO mail-qa0-f46.google.com) (209.85.216.46) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 May 2013 12:01:54 +0000 Received: by mail-qa0-f46.google.com with SMTP id bv4so3366615qab.19 for ; Thu, 23 May 2013 05:01:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=ZjknPiEzP+n0TakoKSfpmMQr5GDldANJ06psxSYX1g0=; b=TRnC8RjkofW/QwWk54x+piJ5HQAQRFWmmNPfn1xYbOXn5aaRH1UAsiXU8nU7wATWKF yYXeOpamgWvRcmB1IbdjffclguQvmbPhhCfhhwMu4QEizGfVdPxAS9ESzb6iYMS5Wlkr jcQlHXdQVjnm/9Mz7P8nRHDdwZb+bSJPRdaNQgbHZQqUXS0rQ+GM41A+1H0qNRnjbCzR 0oz9ji/yAlAreijmPwalQp3NuMXn934OPI3mMnZVW5sdlcmgMFwVpKjeHmwqfl3UeMl0 Dm8NZ853wyFRQX5EMcRRU2RyN+zREcRlXf71YEpG8gmsYG8B0N/zhcOPLz4Va6Mr3Ywn +Qsg== MIME-Version: 1.0 X-Received: by 10.224.184.78 with SMTP id cj14mr1734965qab.69.1369310493944; Thu, 23 May 2013 05:01:33 -0700 (PDT) Received: by 10.49.99.68 with HTTP; Thu, 23 May 2013 05:01:33 -0700 (PDT) In-Reply-To: <00b001ce5791$903463b0$b09d2b10$@innoplexia.com> References: <000901ce570d$7f286c30$7d794490$@innoplexia.com> <00b001ce5791$903463b0$b09d2b10$@innoplexia.com> Date: Thu, 23 May 2013 07:01:33 -0500 Message-ID: Subject: Re: Hive skipping first line From: Dean Wampler To: user@hive.apache.org Content-Type: multipart/alternative; boundary=20cf303b42a59431d404dd617196 X-Virus-Checked: Checked by ClamAV on apache.org --20cf303b42a59431d404dd617196 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Since you have a text file, have you visually inspected the first few lines to make sure there's nothing unusual, like a missing line feed, field separator, or anything like that? The missing line feed would be my first suspicion. Just because you're paranoid doesn't mean Pig isn't out to get you! ;) dean On Thu, May 23, 2013 at 3:43 AM, Tim Bittersohl wrote: > Excuting "hive -e select * from tablename" gives me back all my sample > rows without skipping one**** > > ** ** > > Thanks**** > > Tim**** > > ** ** > > *Von:* Sanjay Subramanian [mailto:Sanjay.Subramanian@wizecommerce.com] > *Gesendet:* Mittwoch, 22. Mai 2013 19:16 > *An:* user@hive.apache.org > *Betreff:* Re: Hive skipping first line**** > > ** ** > > 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 li= ne, > 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 skip = 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 > intended 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 original message alon= g > with any attachments, 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 disclosure by the sender's Email System Administrator.= * > *** > --=20 Dean Wampler, Ph.D. @deanwampler http://polyglotprogramming.com --20cf303b42a59431d404dd617196 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Since you have a text file, have you visually inspected the first few= lines to make sure there's nothing unusual, like a missing line feed, = field separator, or anything like that? The missing line feed would be my f= irst suspicion.=A0

Just because you're paranoid doesn= 9;t mean Pig isn't out to get you! ;)

dean

On Thu, May= 23, 2013 at 3:43 AM, Tim Bittersohl <tim@innoplexia.com> w= rote:

Excuting "hive -e select * from tablename" gives me back all my= sample rows without skipping one

= =A0

Thanks

Tim

=A0

Von: Sanjay Subramanian [mailto:Sanjay.Subramanian@wizecommerce.com= ]
Gesendet: Mittwoch, 22. Mai 2013 19:16
An: user@hive.apache.org
B= etreff: Re: Hive skipping first line

=A0

Can u try doing a=A0

Hive -e "select * from tablename"

See how = many rows this gets u=A0

Thanks

=A0

sanjay

=A0

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

= =A0

Hi,

=A0

<= p class=3D"MsoNormal">I got some little problem = with the content of hive tables.

These table=92s contents are generated by pig an= d do so have no header line, they are accessed as =93TextFile=94 with an ex= ternal hive table. When I fetch records through the java hive library (Vers= ion: 0.10.0-cdh4.2.0) with the =93hiveClient.fetchN(rowncount)=94 command, = it seems like he always skip the first line of data. (perhaps he=92s expect= ing a header row?)

How can I avoid this?

=A0

Greetings,

Tim Bittersohl

=A0

CONFIDENTIALITY NOTIC= E
=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.




--
Dean Wampler, Ph.D.
@deanwampler
http://polyglotprogramming.com --20cf303b42a59431d404dd617196--