Skip to content

README.md

Latest commit

 

History

History
105 lines (70 loc) · 2.54 KB

README.md

File metadata and controls

105 lines (70 loc) · 2.54 KB
Raw

Connecting JavaScript and Apache Doris with ADBC

Instructions

This example uses Apache Doris, a high-performance, real-time analytical database.

Tip

If you already have an Apache Doris instance running, skip the steps to set up Apache Doris.

Prerequisites

  1. Install Node.js (version 22 or later)

    • Alternatively, you can use Bun or Deno

  2. Install dbc

Set up Apache Doris

Warning

This setup process has not been tested on Windows and might not work without modification. Windows users should run it under WSL.

  1. Install Docker

  2. Download the Apache Doris quick-start script:

    curl -O https://doris.apache.org/files/start-doris.sh

  3. Add Flight SQL ports and configure the backend to advertise localhost:

    sed -i.bak -f patch-doris.sed start-doris.sh

  4. Start an Apache Doris cluster:

    chmod 755 start-doris.sh
./start-doris.sh

Connect to Apache Doris

  1. Install the Flight SQL ADBC driver:

    dbc install flightsql

  2. Install dependencies:

    npm --prefix ../.. install

  3. Customize the script main.js as needed

    • Change the connection arguments in databaseOptions
      • uri is the URI of your Apache Doris instance. The host and FE Arrow Flight SQL port will depend on your installation.
      • username and password are the username and password of your Apache Doris user.
    • Change the SQL SELECT statement in conn.query() if desired.

  4. Run the script:

    Node.js:

    node main.js

    Bun:

    bun run main.js

    Deno:

    deno run --allow-ffi --allow-env main.js

Clean up

Stop the Docker project running Apache Doris:

docker compose -f docker-compose-doris.yaml down