Cast relation to scala ClassCastException: java.lang.Integer cannot be cast to java.lang.String

Hi, I tried to cast relation (one row) to scala. It works well when the cast field is Integer. But if the cast field is FLOAT, i got ClassCastException: java.lang.Integer cannot be cast to java.lang.String. coordinate_cossin_xy = FOREACH join_coordinate_cossin_xy GENERATE coordinate_xy::xlo

Re: datetime data type

On 5/22/15, 1:26 PM, "Michael Howard" wrote: >I would like to have a discussion about a number of issues/questions >related to support for the datetime datatype in pig. > >main topics: > > * ToDate(chararray) accepts ISO-8601 'T' timestamps, but not JDBC space ' >' timestamps ... thereby make i

filter by query result

Hi, I am new to pig. First I queried a hive table (x = LOAD 'x' USING org.apache.hive.hcatalog.pig.HCatLoader();) and got a single record/value. How can I used this single value to filter in another query? I hope to get a better performance by filter as soon as possible. BR, Patcharee