如何在Pig中的csv文件中读取下一行(how to read next line in csv file in Pig)

 如果每个<person>每<codes>需要1行，则需要遍历<person>的<codes> <person> 。 要获取<person> id使用->getAttribute('id') - 
 
<?php
$dom = new DOMDocument();
$dom->load('person.xml');
$xpath = new DOMXpath($dom);

echo <<<EOF
<table border="1" cellspacing="2" cellpadding="2">   <tr>
    <th>Person ID</th>
    <th>Person Name</th>
    <th>Person LastName </th>
    <th>Code Numbers</th>
    </tr>
EOF;

$persons = $xpath->evaluate('//person');
foreach ($persons as $person) {
    //loop through each <code_number>
    foreach ($xpath->evaluate('./codes/code_number', $person) as $code_number) {
        echo '<tr>', "\n";
        echo '<td>', htmlspecialchars($person->getAttribute('id')), '</td>', "\n";
        echo '<td>', htmlspecialchars($xpath->evaluate('string(./person_name)', $person)), '</td>', "\n";
        echo '<td>', htmlspecialchars($xpath->evaluate('string(./person_lastname)', $person)), '</td>', "\n";
        echo '<td>'.htmlspecialchars($code_number->nodeValue).'</td>', "\n";
        echo '</tr>', "\n"; 
    }
}
echo '</table>';
?>
 
 这导致了 
 

If you want 1 row per <codes> per <person>, then you need to loop through the <codes> inside the <person>. To get the <person> id use ->getAttribute('id') -
 
<?php
$dom = new DOMDocument();
$dom->load('person.xml');
$xpath = new DOMXpath($dom);

echo <<<EOF
<table border="1" cellspacing="2" cellpadding="2">   <tr>
    <th>Person ID</th>
    <th>Person Name</th>
    <th>Person LastName </th>
    <th>Code Numbers</th>
    </tr>
EOF;

$persons = $xpath->evaluate('//person');
foreach ($persons as $person) {
    //loop through each <code_number>
    foreach ($xpath->evaluate('./codes/code_number', $person) as $code_number) {
        echo '<tr>', "\n";
        echo '<td>', htmlspecialchars($person->getAttribute('id')), '</td>', "\n";
        echo '<td>', htmlspecialchars($xpath->evaluate('string(./person_name)', $person)), '</td>', "\n";
        echo '<td>', htmlspecialchars($xpath->evaluate('string(./person_lastname)', $person)), '</td>', "\n";
        echo '<td>'.htmlspecialchars($code_number->nodeValue).'</td>', "\n";
        echo '</tr>', "\n"; 
    }
}
echo '</table>';
?>
 
This results in