Thanks for the inputs.For now I have just got rid of quotes using REGEX and
then casting it to int. Regards,
Amit
On Tuesday, February 3, 2015 12:41 AM, Arvind S
wrote:
If you have quoted CSV .. Try using CSVExcelStorage() loader
Cheers !!!
Arvind
On 03-Feb-2015 2:18 am, "Amit" w
If you have quoted CSV .. Try using CSVExcelStorage() loader
Cheers !!!
Arvind
On 03-Feb-2015 2:18 am, "Amit" wrote:
> HelloIt looks like this is expected behavior. I presumed that whether the
> data comes in double quotes or does not make any difference.
> Please Refer Convert "3" to 3 with Pi
HelloIt looks like this is expected behavior. I presumed that whether the data
comes in double quotes or does not make any difference.
Please Refer Convert "3" to 3 with PigLatin
| |
| | | | | | | |
| Convert "3" to 3 with PigLatinI read in a csv-file that contains fields with
numb
Thanks again for responses.I have indeed tried with explicit casting and using
schema.
I am now thinking that it has something to do with the integer value coming
within double quotes in CSV format. ("10","Amit" ...)
With double quotes -1) Tried below and PigStorage could not load f1
A = LOAD '
Explicit casting will work, though you shouldn't need to use it. You should
specify an input schema using the AS keyword. This will ensure that
PigStorage will load your data using the appropriate types.
On Mon, Feb 2, 2015 at 7:22 AM, Arvind S wrote:
> Use explicit casting during comparison
>
>
Use explicit casting during comparison
Cheers !!!
Arvind
On 02-Feb-2015 8:39 pm, "Amit" wrote:
> Thanks for the response.The Pig script as such does not fail, it runs
> successfully ( trying in local mode), however when the run is finished it
> does not dump any tuples.Has it something to do wit
Thanks for the response.The Pig script as such does not fail, it runs
successfully ( trying in local mode), however when the run is finished it does
not dump any tuples.Has it something to do with the CSV where the f1 is stored
as a string ?The CSV data would look like this -
**
Just to clarify, do you have a semicolon after f1 > 20?
A = LOAD 'data' USING PigStorage(',');
B = FOREACH A GENERATE f1;
C = FILTER B BY f1 > 20;
DUMP C;
This should be correct.
On Sun, Feb 1, 2015 at 4:50 PM, Amit wrote:
> Hello,I am trying to run a Ad-hoc pig script on IBM Bluemix platfor
Hello,I am trying to run a Ad-hoc pig script on IBM Bluemix platform that has a
arithmetic comparison.Suppose the data is f1-10203040..
Let us say I would like to select the records where f1 > 20 . It is pretty easy
operation, however I am not sure why I cannot see expected results in the