Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive skipping first line


+
Tim Bittersohl 2013-05-22, 16:57
+
Sanjay Subramanian 2013-05-22, 17:16
Copy link to this message
-
Re: Hive skipping first line
Dean Wampler 2013-05-23, 12:01
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 <[EMAIL PROTECTED]> wrote:

> Excuting "hive -e select * from tablename" gives me back all my sample
> rows without skipping one****
>
> ** **
>
> Thanks****
>
> Tim****
>
> ** **
>
> *Von:* Sanjay Subramanian [mailto:[EMAIL PROTECTED]]
> *Gesendet:* Mittwoch, 22. Mai 2013 19:16
> *An:* [EMAIL PROTECTED]
> *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 <[EMAIL PROTECTED]>
> *Reply-To: *"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> *Date: *Wednesday, May 22, 2013 9:57 AM
> *To: *"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> *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