Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Execute tPigLoad,tpigCode component to read xml data from HDFS

Hi,
I am new to Talend Big Data and working on Hadoop using Talend Big data.
I have stored xml file into HDFS using tHdfsPut component successfully and Now i want to search xml element or attribute data from
that xml, but not able to do that.
I have used tPigLoad ,tPigCode and tPigStoreResult component but they are not working.. May be due to some mistakes.
Could you please help me out from this task?

xml Format is:--
<?xml version="1.0" encoding="UTF-8"?>
<CustomerDetails>
<CustomerName name="shikha" id="12"/>
</CustomerDetails>
I have created two columns "name" and "id" in schema.
My tPigQuery is:-
tPigCode_1_RESULT = foreach tPigLoad_1_RESULT generate $0 as name, $1 as id;

Please tell me each component basic settings and also TPigCode query.
Thanks
Shikha Tyagi
Labels (3)
0 Replies