Hi All ,

How to load it using PigStorage
Please find the attachment, if I do copy paste of row here then it shows blank boxes between columns. but if I open that file these boxes having

00
01

kind of some numbering inside the the boxes.
7#1;timesascent.in#1;2008-08-27#1;true#1;false#1;false#1;1
8#1;google.co.in#1;2008-08-27#1;false#1;false#1;false#1;1
9#1;search.live.com#1;2008-08-27#1;false#1;false#1;false#1;1
10#1;ipnetor.com#1;2008-08-27#1;false#1;false#1;false#1;1
11#1;ads.indiatimes.com#1;2008-08-27#1;false#1;false#1;false#1;1
12#1;google.com#1;2008-08-27#1;false#1;false#1;false#1;1
13#1;ms.timesofindia.com#1;2008-08-27#1;false#1;false#1;false#1;1
14#1;google.com.my#1;2008-08-27#1;false#1;false#1;false#1;1
15#1;timesascent.co.in#1;2008-08-27#1;false#1;false#1;false#1;1

these boxes are blanks from inside here.
Thanks & Regards
Yogesh Kumar
         

Sounds like however you wrote the data, it has some sort of a binary
delimiter. Figure out what that delimiter is, and tell PigStorage to
use it. For example:

my_data = load 'path/to/data' using PigStorage('\\u001');

D

On Thu, Oct 11, 2012 at 10:23 AM, yogesh dhari <[EMAIL PROTECTED]> wrote:
>
> Hi All ,
>
> How to load it using PigStorage
> Please find the attachment, if I do copy paste of row here then it shows
> blank boxes between columns. but if I open that file these boxes having
>
> 00
> 01
>
> kind of some numbering inside the the boxes.
>
>
> 7 timesascent.in 2008-08-27 true false false 1
> 8 google.co.in 2008-08-27 false false false 1
> 9 search.live.com 2008-08-27 false false false 1
> 10 ipnetor.com 2008-08-27 false false false 1
> 11 ads.indiatimes.com 2008-08-27 false false false 1
> 12 google.com 2008-08-27 false false false 1
> 13 ms.timesofindia.com 2008-08-27 false false false 1
> 14 google.com.my 2008-08-27 false false false 1
> 15 timesascent.co.in 2008-08-27 false false false 1
>
> these boxes are blanks from inside here.
>
>
>
> Thanks & Regards
> Yogesh Kumar
>
>

Hello all,

Please help me how to store this kind of file using PigStorage,

Please find the attachment of the file format, this file is generated by using

insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from NYSE_LOCAL;  
Thanks & Regards
Yogesh Kumar
     

Hi Yogesh,

Attachments don't come through. You would need to use pastebin or something
like that to show your example file.

On Thu, Oct 11, 2012 at 9:56 AM, yogesh dhari <[EMAIL PROTECTED]> wrote:

>  Hello all,
>
> Please help me how to* store this kind of file using PigStorage,*
>
> *Please find the attachment of the file format*, this file is generated
> by using
>
> *insert overwrite local directory* '/home/yogesh/Downloads/demoyy'*select * from NYSE_LOCAL;
> *
>
>
> Thanks & Regards
> Yogesh Kumar
>
>
>
>
>
>
>