Not able to download/ export query results

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

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

1 Like

Hi Björn ,

That completely worked, thank you for your inputs.

Thanks and Regards,
Satvik

1 Like

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

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.

1 Like

@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 ?

@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.

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

@ayush.goyal any thought on this?

@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?

@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…

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?

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