Using the None Parser

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');

Foreign Stream Options for the None Parser

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.