YTsaurus table engine

The YTsaurus table engine allows you to import data from a YTsaurus cluster.

Creating a table

    CREATE TABLE [IF NOT EXISTS] [db.]table_name
    (
        name1 [type1],
        name2 [type2], ...
    ) ENGINE = YTsaurus('http_proxy_url', 'cypress_path', 'oauth_token')

Engine parameters

• http_proxy_url — URL to the YTsaurus http proxy.
• cypress_path — Cypress path to the data source.
• oauth_token — OAuth token.

Usage example

Shows a query creating the YTsaurus table:

SHOW CREATE TABLE yt_saurus;

CREATE TABLE yt_saurus
(
    `a` UInt32,
    `b` String
)
ENGINE = YTsaurus('http://localhost:8000', '//tmp/table', 'password')

To return the data from the table, run:

SELECT * FROM yt_saurus;

┌──a─┬─b──┐
│ 10 │ 20 │
└────┴────┘

Data types

Primitive data types

Composite types

See Also

• ytsaurus table function
• ytsaurus data schema
• ytsaurus data types