Skip to main content
Version: Next

ClickHouse

ClickHouse is Open-source OLAP database for real-time apps and analytics, used for NewSQL Database Data Warehouse and Lake . ClickHouse supports all the data sources you need to power your apps and use cases that require exceptional performance.

Dashboard

Prepare​

When referring to this document to use ClickHouse, please read and ensure the following points:

  • Login to Websoft9 Console and find or install ClickHouse:

    • Go to My Apps listing applications
    • Go to App Store installing target application

  • This application is installed by Websoft9 console.

  • The purpose of this application complies with the apache2 open source license agreement.

  • Configure the domain name or server security group opens external network ports for application access.

Getting started​

Initial setup​

  1. After completing the installation of ClickHouse in the Websoft9 Console, get the applicaiton's Overview and Access information from the My Apps section.

  2. Once you have entered the username and password, execute the following command in the ClickHouse Console:

    show users
    show databases
    create user websoft9
    drop user websoft9

Configuration options​

Administer​

Troubleshooting​