I have a simple data covering the salary in USD like "$36200" as chararray. I am trying to remove the leading $ symbol through the SUBSTRING function as below: D = FOREACH C GENERATE SUBSTRING(wage, 1, SIZE(wage)) as wage_new; I am getting an error like this: ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1045: Could not infer the matching function for org.apache.pig.builtin.SUBSTRING as multiple or none of them fit. Please use an explicit cast. However, if I am using the StopIndex of the SUBSTRING function explicitly, then the code compiles. But I would like to get to the end of the string dynamically. Can somebody help me ? ... View more

I have a file like: id,name,deg,salary,dept 1201,gopal, manager, 50000, TP 1202,manisha, proof reader, 50000, TP I am trying to load this in PIG using tuple as below: A = LOAD '/mydir/emp.txt' USING PigStorage(',') AS (t:tuple(a:chararray, b:chararray, c:chararray, d:chararray, e:chararray)); X = FOREACH A GENERATE t.$0, t.$1, t.$2, t.$3, t.$4; DUMP X; I am getting a result like : (,,,,) (,,,,) Can somebody help me in understanding the reason behind this issue ? ... View more

I have installed HDP Sandbox 2.4 on oracle Virtualbox. However, can't access the local host 127.0.0.1:8888 from the chrome browser. I am getting a connection refused error. Please, can anybody help ? ... View more