I am trying the SQL ³NVL(city, U¹) city² in pig I am using the bincond
operator, ³(city is null?'U': city) AS city², which is of chararray type,
the result file shows \N¹ instead of U. Any ideas ?
Hi,
I have a very simple script and seeing a very strange behavior, getting
wrong results when running this script from a file, while running the same
statements on the pig grunt shell I get accurate results.
table = LOAD ' sample' USING PigStorage('\t')
AS(a: long, b: in
:411)
at org.apache.pig.Main.main(Main.java:103)
On 8/24/10 1:12 PM, "Wasti, Syed" wrote:
> Hi,
> I have a very simple script and seeing a very strange behavior, getting
> wrong results when running this script from a file, while running the same
> statements on the
when you
see the output data.
Please let me know of your findings.
On 8/24/10 11:33 PM, "Dmitriy Ryaboy" wrote:
> Could you send sample data that would allow us to reproduce this error?
>
> -Dmitriy
>
> On Tue, Aug 24, 2010 at 1:12 PM, Wasti, Syed wrote:
>
>
9th ?
> (I haven't tried running query against the sample yet).
> -Thejas
>
>
>
> On 8/25/10 11:21 AM, "Wasti, Syed" wrote:
>
> Hi Dmitriy,
> Thanks for offering help, attached is the sample data file. From my
> observation it looks like it has to
st_t_date,
>(chararray)(a == 3?max_creation_date:null) AS
> last_t_date ;
>
> see whether that works.
>
>
> On Wed, Aug 25, 2010 at 2:42 PM, Wasti, Syed wrote:
>> It is older then Aug 9th. I updated the trunk version of pig, but have no
>> luck.
>&