Execute tPigLoad,tpigCode component to read xml data from HDFS

Anonymous — Sat, 16 Nov 2024 12:09:29 GMT

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

topic Execute tPigLoad,tpigCode component to read xml data from HDFS in Talend Studio

Execute tPigLoad,tpigCode component to read xml data from HDFS