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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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