The None parser lets you pull in a single column of data. To use it, set PARSER to NONE and create a foreign stream with a single column.
The single column should be of type VARBINARY or VARCHAR.
You can optionally specify CHARACTER_ENCODING and ROW_SEPARATOR.
CHARACTER_ENCODING only applies with VARCHAR and defaults to UTF_8.
If ROW_SEPARATOR is not specified (or is empty) then one file or message will be read for each row. If ROW_SEPARATOR is specified, it should either be a string of HEX digit pairs when going to VARBINARY or a string that encodes properly in the character encoding being used.
Example
CREATE OR REPLACE FOREIGN STREAM none_parser ( PAYLOAD VARCHAR(100000)--single column to be read)SERVER "FileReaderServer"OPTIONS( DIRECTORY 'unitsql/ecda', filename_pattern '(animals|plants)\.csv', PARSER 'NONE', character_encoding 'UTF-8');
Option Name | Description |
---|---|
PARSER | Must be set to NONE to use the None parser. |
CHARACTER_ENCODING | Only applies with VARCHAR. Defaults to UTF_8. Defaults to UTF-8. See https://docs.oracle.com/javase/8/docs/api/java/nio/charset/StandardCharsets.html |
ROW_SEPARATOR | If ROW_SEPARATOR is specified, it should either be a string of HEX digit pairs when going to VARBINARY or a string that encodes properly in the character encoding being used. |