Created 09-20-2018 01:15 PM
i m having the below data:
"event_header":{"version":"1.0","app_id":null,"app_name":null,"event_id=001","event_timestamp":null,"offering_id":null,"server_timestamp":1534219019523,"accept_language":null,"server_ip_address":"10.87.43.239","topic_name":"stream","client_ip_address":"52.11.100.197"},"eventmessage1":"CompanyGUID=\"99f5b\" EventTypeName=\"TrackingEvent\" EventTypeId=\"42\" EventTypeOwner=\"ments\" EventTypeDescription=\"Generic Tracking string event .\" EventCode= \"0\" EventName=\"\" EventDescription=\"\" EventCatagory=\"\" EventOwner=\"\" EventString=\"Feature=IdentitySetup, payments_auth_id=2679, action_type=TokenTypeToUse, action_message=SABI: SignIn: determiod: er=Gedr-ShTok-Fail. Using_method=METHOD_SHARED_TOKENS, Flow_marker=21, Feature_enabled=False\"","appcontext":"tracking","engineuid":"17930","appname":"bd","CLSServerTimeStamp":"1534219019","scenario":"EventUploader","messagetype":"Info","qbver":"US Release R1","message":"Tracking","tid":"7d"}
i tried loading using JsonLoader as below:
A = LOAD 'event.json' USING JsonLoader (' header:(version:chararray,app_id:chararray,app_name:chararray,e_id:chararray,e_timestamp:chararray,offg_id:chararray, s_timestamp:chararray,acc:chararray,p_address:chararray,topic_name:chararray, c_address:chararray),message1:(appcontext:chararray,engineuid:chararray,appname:chararray, CLSServerTimeStamp:chararray,scenario:chararray,messagetype:chararray,qbversion:chararray,message:chararray,tid:chararray) ');
after doing dump A;
i am getting a file which is been created in tmp folder with unreadable format as below.
EUȀ8?=??&
Created 09-21-2018 04:18 AM
@Bala Vignesh N V @aditya singh can i get some help from u ppl pls...
Created 09-21-2018 04:21 AM
@Geoffrey Shelton Okot can i get some help for this
Created 09-21-2018 04:26 AM
Whats the error here. ? can anyone help mw in getting the correct outcome.