Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-9491

[dashboard] Backquotes in Presto queries

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 4.8.0
    • Fix Version/s: None
    • Component/s: app.dashboard
    • Labels:
      None
    • Environment:

      Presto 0.240 (SQLAlchemy connector)

      Image Docker gethue 4.8.0 

    • Easy:
      Easy

      Description

      In the dashbord, Hue creates SQL queries including backquotes that are not supported by Presto. Did I miss something in the configuration?

      *

      { "message": "global name 'self' is not defined", "traceback": [ " File \"/usr/share/hue/desktop/libs/dashboard/src/dashboard/api.py\", line 74, in search\n response = get_engine(request.user, collection, facet, cluster=cluster).query(collection, query, facet)\n", " File \"/usr/share/hue/desktop/libs/notebook/src/notebook/dashboard_api.py\", line 159, in query\n 'fields': self._get_aggregate_function(facet['properties']['facets'][0]),\n", " File \"/usr/share/hue/desktop/libs/notebook/src/notebook/dashboard_api.py\", line 526, in _get_aggregate_function\n facet['backticks'] = self.backticks\n" ], "detail": null, "is_embeddable": false, "title": "Error while accessing Solr" }

      *

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tledieu Thibault L.
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: