Execution Time Discrepancy Between Hue Editor and Trino Dashboard

[aliraee]

Is there an existing issue for this?

• I have searched the existing issues

Description

There is a discrepancy between the execution time shown in the Hue editor and the execution time displayed in the Trino dashboard. The execution time reported by Hue is significantly lower than the actual execution time recorded in Trino.

Steps to Reproduce

1. Run a query in the Hue editor (e.g., SELECT * FROM hive_example;).
2. Observe the execution time displayed in the Hue editor.
3. Check the same query's execution time in the Trino dashboard.
4. Compare the two execution times.

Expected Behavior

The execution time shown in the Hue editor should match the execution time recorded in the Trino dashboard.

Actual Behavior

The execution time in the Hue editor is much lower than the execution time in the Trino dashboard. For example:

• Hue editor shows: 1.18 seconds
• Trino dashboard shows: 2.13 seconds
  Additionally, as the volume and complexity of the query increases, the difference between the two execution times also increases.

Screenshots

Hue Editor Execution Time:

Trino Dashboard Execution Time:

Environment

• Hue Version: [4.11.0]
• Trino Version: [Trino CLI 468]

Additional Context

• This issue occurs consistently across different queries.
• The discrepancy makes it difficult to accurately measure query performance using Hue.

Possible Causes

• Hue might not be accounting for the time taken to fetch and render the results.
• There could be a mismatch in how Hue and Trino calculate execution time.

Suggested Fix

• Update Hue to accurately reflect the execution time recorded by Trino.
• Include additional metrics (e.g., fetch time, render time) in the Hue editor.

Could you please investigate and address this issue? Accurate execution time reporting is critical for performance monitoring and optimization.

Thank you for your attention and support!

Steps To Reproduce

hue.ini

[notebook]
[[interpreters]]
[[[presto]]]
name = Trino
interface=sqlalchemy
options='{"url": "trino://localhost:8080/hive/default"}'



### Logs

_No response_

### Hue version

4.11.0

[agl29]

Hi @aliraee,

We are now supporting Trino using the trino-pythonclient. Could you please follow the instructions in this document to apply the configurations: https://gethue.com/blog/2024-06-26-integrating-trino-editor-in-hue-supporting-data-mesh-and-sql-federation/?
If you encounter any issues, please let us know.

[2416210017]

Hi @aliraee,

We are now supporting Trino using the trino-pythonclient. Could you please follow the instructions in this document to apply the configurations: https://gethue.com/blog/2024-06-26-integrating-trino-editor-in-hue-supporting-data-mesh-and-sql-federation/? If you encounter any issues, please let us know.

Does it support user simulation?

[agl29]

@aliraee
Could you please share an official document or reference that outlines the functionality you are looking for?

[2416210017]

Why can I only specify a default account password separately in the configuration? And cannot achieve user authentication trino using hue login?

[[[trino]]]
name=Trino
interface=trino
options='{"url": "https://trino-ddl.org:443/spark_catalog/default",  "auth_username": "200001", "auth_password":"VmopyDShp3BtRbJM"}'