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 <t...@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.subraman...@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 <t...@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
