LineAsString

Input	Output	Alias
✔	✔

Description

The LineAsString format interprets every line of input data as a single string value. This format can only be parsed for a table with a single field of type String. The remaining columns must be set to DEFAULT, MATERIALIZED, or omitted.

Example usage

Query

DROP TABLE IF EXISTS line_as_string;
CREATE TABLE line_as_string (field String) ENGINE = Memory;
INSERT INTO line_as_string FORMAT LineAsString "I love apple", "I love banana", "I love orange";
SELECT * FROM line_as_string;

Response

┌─field─────────────────────────────────────────────┐
│ "I love apple", "I love banana", "I love orange"; │
└───────────────────────────────────────────────────┘

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes

Description

Example usage

Format settings

​Description

​Example usage

​Format settings

Description

Example usage

Format settings