Re: Extract Date part from ISO datetime format

2013-03-19 Thread Mason
There might be an easier way, but I bet you could whip up a solution with the helpers in Piggybank: http://svn.apache.org/viewvc/pig/trunk/contrib/piggybank/java/src/main/java/org/apache/pig/piggybank/evaluation/datetime/ . On Mon, Mar 18, 2013 at 1:24 PM, Mix Nin wrote: > How to get only Date p

Re: possible to infer schema from TSV header?

2013-01-15 Thread Mason
me in the write direction. -Mason On Tue, Jan 15, 2013 at 2:23 PM, Mason wrote: > I have TSVs with a lot of columns, and I would like to address them by > name, as specified in the header line (first row), within Pig. > > The best I can come up with a.t.m is to write a script that st

possible to infer schema from TSV header?

2013-01-15 Thread Mason
plug that schema string into the AS portion of my LOAD statement. Then I'll project columns I want and manually typecast them. Is there a better, simple way? -Mason