Hi, I have my JSON file like mentioned below: The flow for conversion for json to csv : 1. Get the file 2. Split json 3. Evaluate json path 4. Replace text I want to see values in csv format of memberid and loanamnt and 'm getting blank for the two columns like ""."" Can someone help me in this?? Attached are the Screenshots of the processor properties. ... View more

Hi , I have given 4gb dedicated ram to Virtual box but still the screen is stuck as shown below. Any suggestions, i have total of 8 gb ram i3 2nd genration laptop ... View more

Hi All, I have my table structure and in hive like below . Create table hv (x int,y int,z int ,w int ) PIGLATIN used to load the table A = LOAD 'XYZ.CSV.GZ' using pigstorage AS (x,y,w) this time Z col is missing from the file so i wan to keep the value of z as null in PIGLATIN and i donot want to change my hive table structure .How to generate the values as null for this column in pig?? ... View more

Hi All, While trying to process my data in pig which is a csv dataset from here Link I'm getting the below error .There is some delimitter problem here in the file.If i create the same file manually i'm able to see the data is getting loaded properly. Pig Script: A = LOAD 's3a://byr-heor-test/dev1/BJsales.csv' using PigStorage(',') as (Num:Int,time:int,BJsales:int) Output: .. .. (149,149,262) (150,150,262) 2016-12-27 09:31:35,632 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1000: Error during parsing. Encountered " <PATH> "2 "" at line 3, column 8. Was expecting one of: ... View more