Skip to content

Cube Trino Run Slow #7049

Open
Open
@zongkx

Description

@zongkx

Problem

docker logs:
2023-08-19 17:19:37 Performing query completed: ce333754-7ab0-4719-932d-3a161b1dab1d-span-1 (3419ms)
2023-08-19 17:19:37 Load Request Success: ce333754-7ab0-4719-932d-3a161b1dab1d-span-1 (3459ms)

This simple sql executes very fast in the database client.
my cubejs docker env is

CUBEJS_DATASOURCES=default
CUBEJS_DEV_MODE=true
CUBEJS_WEB_SOCKETS=false
CUBEJS_DB_TYPE=trino
CUBEJS_DB_HOST=****
CUBEJS_DB_PORT=28443
CUBEJS_DB_USER=test
CUBEJS_DB_CATALOG=memory
CUBEJS_DEV_MODE=true
CUBEJS_DB_SSL=true
CUBEJS_DB_PASS=****

Related Cube.js schema

cubes:
  - name: memory_default_mysql_vte_deals
    sql_table: memory.default.mysql_vte_deals
    data_source: default
    joins: []
    dimensions:
      - name: id
        sql: id
        type: number
        primary_key: true
      - name: type
        sql: type
        type: string

Related Cube.js generated SQL

SELECT
  "memory_default_mysql_vte_deals".id "memory_default_mysql_vte_deals__id"
FROM
  memory.default.mysql_vte_deals AS "memory_default_mysql_vte_deals"
GROUP BY
  1
ORDER BY
  1 ASC
LIMIT
  10000

Metadata

Metadata

Assignees

No one assigned

    Labels

    driver:trinoIssues relating to the Trino driverquestionThe issue is a question. Please use Stack Overflow for questions.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions