Delimiter Formatter

UpdatedNovember 9, 2024

The DELIMITER formatter plugin is optionally invoked in a SELECT statement and arranges the selected values into a character-delimited record.
For example, it can send the query results comma-delimited, or tab-delimited.

Parameters

delimiter: A character to be used as the field delimiter.

Syntax

formatter DELIMITER (
    delimiter '<a character to separate fields>'
    enclosed_by '<a character for enclosing fields. OPTIONAL>'
)

Example

Selecting 2 columns and formatting them as a comma-delimited string:

select symbol, bid 
from my_bench_stream
output stdout
formatter delimited(
    delimiter ','
);

Selecting 2 columns and formatting them as a comma-delimited string, enclosed by double-quotes:

select symbol, bid 
from my_bench_stream
output stdout
formatter delimited(
    delimiter ','
    enclosed_by '"'
);