Not able to download/ export query results

satvik · November 30, 2022, 5:48pm

I am not able to find export/download results option for query results

We are currently using presto with hive meta-store and Mariadb on a Kubernetes Environment . With hue UI to access the presto . Any anyone please let me know what can be the issue ? I suspect there is misconfiguration with how hue is configured . Below is the hue configuration . Can anyone please let me know if anything more needs to be configured

hue:
database:
  create: false
  persist: true
  engine: "mysql"
  host: "sip-presto-mariadb"
  port: 3306
  user: "hue"
  password: "hue"
  name: "hue"
interpreters: |
  [[[mysql]]]
  name = Mariadb
  interface=sqlalchemy
  options='{"url": "mysql://hue:hue@sip-presto-mariadb:3306/hue"}'

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

  # Set a particular S3 bucket as the default
  [filebrowser]
  remote_storage_home=s3a://bucket_name

ini: |
  [desktop]
  secret_key=hue123
  app_blacklist=search,hbase,security,jobbrowser,oozie,zookeeper,sqoop,pig,impala
  django_debug_mode=false
  gunicorn_work_class=sync
  enable_prometheus=true
  [[task_server]]
  enabled=false
  [[session]]
  trusted_origins=.synchronoss.net
  
  [notebook]
  enable_notebook_2=true

bjorn_alm · December 6, 2022, 11:23am

Hi satvik,

it looks like you are using the latest and still experimental version of the query editor. This version is enabled on our demo page but is not intended for production yet. In your config you should set:

enable_notebook_2=false

Hope that helps

satvik · December 6, 2022, 2:08pm

Hi Björn ,

That completely worked, thank you for your inputs.

Thanks and Regards,
Satvik

susv0001 · December 12, 2022, 2:13pm

Hi @bjorn_alm

The suggestion given by you totally worked. Thank you so much.
Could we know the purpose behind marking " enable_notebook_2=false" ?

Thanks & Regards,
Sushmitha V

bjorn_alm · December 13, 2022, 8:26am

Hi @susv0001, “enable_notebook_2” is a feature flag that enables the new experimental second version of our query editor. The new version will in many aspects be a great improvement, but it is to be considered work in progress and is still lacking som basic functionality like download/export etc. The value of “enable_notebook_2” is true for our demo site so that our community has the chance to test the new version and provide feedback, but the flag should be set to false in any production environment.

susv0001 · December 15, 2022, 1:13pm

@bjorn_alm Okay. Thank you for the information.
Could u please suggest a consistent stable version of query editor apart from which we are using (20220308-140101) which consists of download option so where we do not have a need of disabling enable_notebook_2=false ?

bjorn_alm · December 16, 2022, 9:21am

@susv0001 Here is the list of the latest official releases, I would suggest to use 4.10

We are in the process of releasing 4.11 which will be out soon, but at this point the latest release is from 2021.

susv0001 · January 4, 2023, 6:31pm

Thank you this was really helpful We tried 4.7.1 since it was supporting all the functionality required by the team…
But we are facing an issue while downloading through excel format.
@bjorn_alm We are getting 504 Gateway Time-out while exporting huge data in excel format.
could u please help us out what might be the solution for the exact cause…

After 60 sec of clicking on the export button, It throws this timeout error.

Thanks & Regards,
sushmitha

bjorn_alm · January 5, 2023, 8:24am

@ayush.goyal any thought on this?

ayush.goyal · January 5, 2023, 4:01pm

@bjorn_alm not sure at this moment, need to look for the specific version as we are using the Hue 4.10 and it is working perfectly there.

@susv0001 so are you also facing this issue when you are downloading the through CSV format?

susv0001 · January 5, 2023, 4:21pm

@ayush.goyal We are using 4.7.1 version.
The 504 gateway timeout error is occurred when we try to download through “excel” format after 60sec of clicking on download option…

ayush.goyal · January 5, 2023, 5:44pm

I got it @susv0001, but I am asking that is it happening only for excel format or for all formats like CSV?
I checked the code and we haven’t changed anything in that particular section.
If possible can you attach the logs to check where it is failing?

susv0001 · January 6, 2023, 2:01pm

Its happening only for excel format actually.Not for csv…

susv0001 · February 3, 2023, 9:40am

@bjorn_alm In The version 4.7.1 which we are using, We are able to install presto…But not able to upgrade.We dont get to see the login page…Instead we are facing this error in the login page :

Any thoughts about this issue ?
Previously when we were using the tag 20220308-140101 , Install as well as upgrade was working as expected and could access the UI…

susv0001 · February 3, 2023, 9:40am

@bjorn_alm @ayush.goyal
We are not able to login if we upgrade presto in this particular version 4.7.1.
Installation is working fine. But , when we are trying to upgrade , we are facing this error in the login page.
I can share you the logs of the hue pod… Please let us know if there are any solutions…

We were able to login with our previous version 20220308-140101.for both installation as well as upgrade.

bjorn_alm · February 9, 2023, 2:03pm

Hi @susv0001,

can you try the latest 4.11 version that we just released?

susv0001 · July 18, 2023, 2:07pm

Hello @bjorn_alm @ayush.goyal
We had a conversation related to the download option in presto…
We are now using the hue version 4.7.1 and disabled notebook according to your suggestion and we are able to download the query results in csv or excel format…
Our concern now is that when we try to download query results through csv or excel , We see the re-execution of queries while downloading which itself is becoming a major glitch when it comes to performance point of view…
So can u provide us any configuration to stop this re-execution which happens while downloading the query through csv or excel ?