@dalongrong/opendistro-driver v1.0.2

Cube.js opendistro elasticsearch database driver

Some notes

better use opendistro-for-elasticsearch:1.13.0

• unixTimestampSql

with fix unixtimestamp （1617184163）

• query format

only support with jdbc (for better data process)

Usage

.env

CUBEJS_DB_URL=http://<username>:<password>@localhost:9200
CUBEJS_DB_ELASTIC_QUERY_FORMAT=jdbc // must user jdbc 
CUBEJS_DB_ELASTIC_OPENDISTRO=true
CUBEJS_DEV_MODE=true
CUBEJS_SCHEDULED_REFRESH_TIMER=false
CUBEJS_API_SECRET=<key>

• cube.js

// Cube.js configuration options: https://cube.dev/docs/config
const {OpendistroDriver,OpendistroQuery} = require("@dalongrong/opendistro-driver")
module.exports = {
    dialectFactory: (dataSource) => {
        // need config  datasource  for multitenant env
        return OpendistroQuery
    },
    dbType: ({ dataSource } = {}) => {
        return "opendistro"
    },
    driverFactory: ({ dataSource } = {}) => {
        return new OpendistroDriver({})
    }
};