Can we re-open this issue ?

[satvik1992]

Can we re-open this issue ?

Could you please inform which interfaces support caching the query results from presto in hue?

Also, can hue's task server be used for caching the query results ? If yes then could please provide a resource for configuring this?

Can cached results be stored to S3? If yes could you please provide the resources for this

Originally posted by @satvik1992 in #3420 (comment)

Hue version - 4.11 and
presto version - 0.289
below is the configuration in hue.ini

interpreters: |
[[[hive]]]
name = Hive
interface=hiveserver2

[[[mysql]]]
name = Mariadb
interface=sqlalchemy
options='{"url": "mysql://hue:hue@xxx-xxxxx-mariadb:3306/hue"}'

[[[presto]]]
name = Presto
interface=sqlalchemy
options='{"url": "presto://xxx-xxxxx-coordinator:80/hive/default"}'

@bjornalm , @Harshg999 , @romainr could you please provide your inputs .