Skip to content

Latest commit

Β 

History

History
45 lines (34 loc) Β· 2.55 KB

File metadata and controls

45 lines (34 loc) Β· 2.55 KB
redirect_from
/config/databases/hive-sparksql

Hive / SparkSQL

Prerequisites

  • The hostname for the Hive database server
  • The username/password for the Hive database server

Setup

Manual

Add the following to a .env file in your Cube project:

CUBEJS_DB_TYPE=hive
CUBEJS_DB_HOST=my.hive.host
CUBEJS_DB_NAME=my_hive_database
CUBEJS_DB_USER=hive_user
CUBEJS_DB_PASS=**********

Environment Variables

Environment Variable Description Possible Values Required
CUBEJS_DB_HOST The host URL for a database A valid database host URL βœ…
CUBEJS_DB_PORT The port for the database connection A valid port number ❌
CUBEJS_DB_NAME The name of the database to connect to A valid database name βœ…
CUBEJS_DB_USER The username used to connect to the database A valid database username βœ…
CUBEJS_DB_PASS The password used to connect to the database A valid database password βœ…
CUBEJS_DB_HIVE_TYPE ❌
CUBEJS_DB_HIVE_VER ❌
CUBEJS_DB_HIVE_THRIFT_VER ❌
CUBEJS_DB_HIVE_CDH_VER ❌
CUBEJS_CONCURRENCY The number of concurrent connections each queue has to the database. Default is 2 A valid number ❌
CUBEJS_DB_MAX_POOL The maximum number of concurrent database connections to pool. Default is 8 A valid number ❌