XML Input Format Parameters
The XML input format supports the following parameters:
| rootXPath | ||
| Values: | XPath query | |
| Default: | not specified | |
| Description: | XPath query of document node(s) to be considered root node(s). | |
| Details: | The node(s) selected by the specified XPath replace the
document root node as the starting node(s) from which all the document nodes are
visited.
|
|
| Example: | -rootXPath:/World/Continent/Country | |
| fMode | ||
| Values: | Branch | Tree | Node | Auto | |
| Default: | Auto | |
| Description: | Algorithm to use when visiting the document nodes. | |
| Details: | For information on the "Branch", "Tree",
and "Node" visit algorithms see
XML Input Format Fields. The "Auto" value instructs the XML input format to determine automatically the best algorithm after inspecting the structure of the input document(s). |
|
| Example: | -fMode:Tree | |
| iTsFormat | ||
| Values: | timestamp format | |
| Default: | yyyy-MM-dd?hh:mm:ss | |
| Description: | Format of timestamp values in the document. | |
| Details: | This parameter specifies the date and/or time format used in the document being parsed. Values of nodes or attributes matching the specified format are returned as values of the TIMESTAMP data type. For more information on date and time formats, see Timestamp Format Specifiers. | |
| Example: | -iTsFormat:"MMM dd, yyyy" | |
| dtNodes | ||
| Values: | number of leaf nodes (number) | |
| Default: | -1 | |
| Description: | Number of leaf nodes to be examined when determining the document structure. | |
| Details: | In order to determine the input document structure, the XML
input format initially examines the nodes found along the paths from the root node or from
the node(s) selected by the user-supplied root XPath to the first n leaf nodes,
where n is the value specified for this parameter. Specifying -1 causes the XML input format to examine all the nodes in the input document. |
|
| Example: | -dtNodes:50 | |
| fNames | ||
| Values: | Compact | XPath | |
| Default: | Compact | |
| Description: | Field naming schema. | |
| Details: | Specifying "Compact" causes the XML input format
to create field names using the names of the corresponding nodes or attributes.
If a field name is not unique, a sequential number is appended to the name to render
it unique. Example field names in the "Compact" mode are: ContinentName CountryName City PopulationSpecifying "XPath" causes the XML input format to create field names using the XPath queries for the corresponding nodes or attributes. Example field names in the "XPath" mode are: /World/Continent/@ContinentName /World/Continent/Country/@CountryName /World/Continent/Country/City /World/Continent/Country/City/@Population |
|
| Example: | -fNames:XPath | |
Note: This parameter is ignored for XML documents whose filename or URL has been specified
together with an optional XPath in the