SQLite

    Engine Parameters

    • db_path — Path to a file with SQLite database.

    Database in ClickHouse, connected to the SQLite:

    1. CREATE DATABASE sqlite_db ENGINE = SQLite('sqlite.db');
    2. SHOW TABLES FROM sqlite_db;

      Inserting data into SQLite table from ClickHouse table:

      1. CREATE TABLE clickhouse_table(`col1` String,`col2` Int16) ENGINE = MergeTree() ORDER BY col2;
      2. INSERT INTO clickhouse_table VALUES ('text',10);