Get Started

This document provides guidance for users to quickly deploy and start the openLooKeng service on the local host. For details about the installation requirements and deployment mode, see Installation.

A demo environment is also available. Try now.

Preparing the Environment

  • Select Linux as the operating system.
  • Memory > 4 GB
  • Machines are connected to the Internet
  • The port number 8090 is not occupied.

One-Click Deployment

Run the following command to start the installation and deployment:

wget -O - https://download.openlookeng.io/install.sh|bash

This command is used to download the installation script from the openLooKeng official website and start the script. During the script running, the latest installation package and dependent components are automatically downloaded from the openLooKeng official website. After the download is complete, the deployment automatically starts. No extra operation is required.

If the following log is displayed, openLooKeng is successfully deployed.

After successful deployment, you can learn the following information to better use the openLooKeng service.

  • By default, the following built-in data sources are configured for openLooKeng for one-click deployment:

  • The installation path of openLooKeng is /opt/openlookeng. You can find the configuration file of openLooKeng here. For more information about configuration files and configuration items, see Here.

  • The new user openlkadmin will be created to perform operations related to openLooKeng, including starting/stopping the openLooKeng service and expanding/reducing the cluster scale.

  • One-click deployment also provides scripts for common management commands. You can find /opt/openlookeng/bin here.

  • openLooKeng run logs are stored in /home/openlkadmin/.openlkadmin/logs.

  • One-click deployment also provides CLI for connecting to the openLooKeng service.

Using openLooKeng

Users can use the command line tool (cli) to connect to the openLooKeng service for data search and analysis. Run the following command to start the CLI:

bash /opt/openlookeng/bin/openlk-cli

Users can enter standard SQL in the CLI to interact with the openLooKeng server.

For example, to view the configured catalog, run the following command:

show catalogs;

Run the following command to check the schema contained in the tpcds:

show schemas from tpcds;
Schema
--------------------
information_schema
sf1
sf10
sf100
sf1000
sf10000
sf100000
sf300
sf3000
sf30000
tiny
(11 rows)

tpcds divides schemas based on the data size. A larger value of sf indicates a larger data volume. Each schema contains the same table.

Check the data tables in sf1.

show tables from tpcds.sf1;

You can select a table to search for data.

select c_customer_id, c_first_name, c_last_name from tpcds.sf1.customer limit 10;

Or run more complex multi-table joint query:

SELECT
"sr_customer_sk" "ctr_customer_sk"
, "sr_store_sk" "ctr_store_sk"
, "sum"("sr_return_amt") "ctr_total_return"
FROM
store_returns
, date_dim
WHERE ("sr_returned_date_sk" = "d_date_sk")
AND ("d_year" = 2000)
GROUP BY "sr_customer_sk", "sr_store_sk"

You can read the openLooKeng syntax document to learn more syntax rules.

For more features and features of openLooKeng, please refer to the User Guide.

有奖捉虫

“有虫”文档片段

0/500

存在的问题

文档存在风险与错误

● 拼写,格式,无效链接等错误;

● 技术原理、功能、规格等描述和软件不一致,存在错误;

● 原理图、架构图等存在错误;

● 版本号不匹配:文档版本或内容描述和实际软件不一致;

● 对重要数据或系统存在风险的操作,缺少安全提示;

● 排版不美观,影响阅读;

内容描述不清晰

● 描述存在歧义;

● 图形、表格、文字等晦涩难懂;

● 逻辑不清晰,该分类、分项、分步骤的没有给出;

内容获取有困难

● 很难通过搜索引擎,openLooKeng官网,相关博客找到所需内容;

示例代码有错误

● 命令、命令参数等错误;

● 命令无法执行或无法完成对应功能;

内容有缺失

● 关键步骤错误或缺失,无法指导用户完成任务,比如安装、配置、部署等;

● 逻辑不清晰,该分类、分项、分步骤的没有给出

● 图形、表格、文字等晦涩难懂

● 缺少必要的前提条件、注意事项等;

● 描述存在歧义

0/500

您对文档的总体满意度

非常不满意
非常满意

请问是什么原因让您参与到这个问题中

您的邮箱

创Issue赢奖品
根据您的反馈,会自动生成issue模板。您只需点击按钮,创建issue即可。
有奖捉虫