Using Presto query to export download results bug.

[q127981]

Is the issue already present in https://github.com/cloudera/hue/issues or discussed in the forum https://discourse.gethue.com?

https://discourse.gethue.com/t/saved-results-with-presto/86

Describe the bug:

I use Presto to initiate an SQL query, click the Export button, and try to export the query results as CSV files. Although the exported data is small, it still makes me wait a long time.

I tried to find the reason and found that Presto started the same query again after clicking the download button. How can I solve it？

hue.ini

[beeswax] download_row_limit=-1 download_cell_limit=-1 [desktop] enable_connectors=true [notebook] enable_notebook_2=true [[interpreters]] [[[presto]]] name=Presto interface=sqlalchemy options='{"url": "presto://xxxxxxx:xxxxx/hive/xxx"}'

Hue version or source? (e.g. open source 4.5, CDH 5.16, CDP 1.0...). System info (e.g. OS, Browser...).

CDH version: CDH-6.2.0-1.cdh6.2.0.p0.967373 Hue version: Hue | 4.2.0+cdh6.2.0 Browser version: firefox 92.0.1 and Google Chrome 93.0.4577.82

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity and is not "roadmap" labeled or part of any milestone. Remove stale label or comment or this will be closed in 5 days.

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity and is not "roadmap" labeled or part of any milestone. Remove stale label or comment or this will be closed in 5 days.

[StrongZhao]

Have you solved this problem？