hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <deanwamp...@gmail.com>
Subject Re: Hive skipping first line
Date Thu, 23 May 2013 12:01:33 GMT
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 <tim@innoplexia.com> 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 <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’s contents are generated by pig and do so have no header line,
> they are accessed as “TextFile” with an external hive table. When I fetch
> records through the java hive library (Version: 0.10.0-cdh4.2.0) with the
> “hiveClient.fetchN(rowncount)” command, it seems like he always skip the
> first line of data. (perhaps he’s expecting a header row?)****
>
> How can I avoid this?****
>
>  ****
>
> Greetings,****
>
> Tim Bittersohl****
>
> ** **
>
> CONFIDENTIALITY NOTICE
> ======================
> 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 along
> 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.*
> ***
>



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

Mime
View raw message