文件最后提交记录最后更新时间
1 年前
10 个月前
11 个月前
11 个月前
10 个月前
README.md

Quick reference

Apache Drill | openEuler

Current Apache Drill docker images are built on the openEuler. This repository is free to use and exempted from per-user rate limits.

Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel.

Learn more on Apache Drill Documentation.

Supported tags and respective Dockerfile links

The tag of each drill docker image is consist of the version of drill and the version of basic image. The details are as follows

Tag Currently Architectures
1.21.2-oe2403sp1 Apache Drill 1.21.2 on openEuler 24.03-LTS-SP1 amd64, arm64

Usage

In this usage, users can select the corresponding {Tag} based on their requirements.

  • Pull the openeuler/drill image from docker

    docker pull openeuler/drill:{Tag}
    
  • Run with an interactive shell

    Run the following command to launch an interactive Apache Drill container and expose the Web UI port 8047 to you host:

    docker run -it --rm -p 8047:8047 openeuler/drill
    

    When the container starts, you'll see the sqlline shell prompt like:

    apache drill>
    

    You can immediately sun SQL queries inside the shell, for example:

    apache drill> SELECT * FROM cp.`employee.json` LIMIT 5;
    +-------------+-----------------+------------+-----------+-------------+------------------------+----------+---------------+------------+-----------------------+---------+---------------+------------------+----------------+--------+-------------------+----------+
    | employee_id |    full_name    | first_name | last_name | position_id |     position_title     | store_id | department_id | birth_date |       hire_date       | salary  | supervisor_id | education_level  | marital_status | gender |  management_role  | end_date |
    +-------------+-----------------+------------+-----------+-------------+------------------------+----------+---------------+------------+-----------------------+---------+---------------+------------------+----------------+--------+-------------------+----------+
    | 1           | Sheri Nowmer    | Sheri      | Nowmer    | 1           | President              | 0        | 1             | 1961-08-26 | 1994-12-01 00:00:00.0 | 80000.0 | 0             | Graduate Degree  | S              | F      | Senior Management | null     |
    | 2           | Derrick Whelply | Derrick    | Whelply   | 2           | VP Country Manager     | 0        | 1             | 1915-07-03 | 1994-12-01 00:00:00.0 | 40000.0 | 1             | Graduate Degree  | M              | M      | Senior Management | null     |
    | 4           | Michael Spence  | Michael    | Spence    | 2           | VP Country Manager     | 0        | 1             | 1969-06-20 | 1998-01-01 00:00:00.0 | 40000.0 | 1             | Graduate Degree  | S              | M      | Senior Management | null     |
    | 5           | Maya Gutierrez  | Maya       | Gutierrez | 2           | VP Country Manager     | 0        | 1             | 1951-05-10 | 1998-01-01 00:00:00.0 | 35000.0 | 1             | Bachelors Degree | M              | F      | Senior Management | null     |
    | 6           | Roberta Damstra | Roberta    | Damstra   | 3           | VP Information Systems | 0        | 2             | 1942-10-08 | 1994-12-01 00:00:00.0 | 25000.0 | 1             | Bachelors Degree | M              | F      | Senior Management | null     |
    +-------------+-----------------+------------+-----------+-------------+------------------------+----------+---------------+------------+-----------------------+---------+---------------+------------------+----------------+--------+-------------------+----------+
    5 rows selected (3.456 seconds)
    

    This will return sample rows from the emploee.json example file.

  • Access the Drill Web Console

    By default, Apache Drill's Web Console runs at:

    http://localhost:8047
    

Question and answering

If you have any questions or want to use some special features, please submit an issue or a pull request on openeuler-docker-images.