Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6847

Add Query Metadata to RESTful Interface

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.15.0
    • Component/s: Metadata
    • Labels:

      Description

      The Drill RESTful interface does not return the structure of the query results.   This makes integrating Drill with other BI tools difficult because they do not know what kind of data to expect.  

      This PR adds a new section to the results called Metadata which contains a list of the minor types of all the columns returned.

      The query below will now return the following in the RESTful interface:

      SELECT CAST( employee_id AS INT) AS employee_id,
      full_name,
      first_name, 
      last_name, 
      CAST( position_id AS BIGINT) AS position_id, 
      position_title 
      FROM cp.`employee.json` LIMIT 2
      
      {
        "queryId": "2414bf3f-b4f4-d4df-825f-73dfb3a56681",
        "columns": [
          "employee_id",
          "full_name",
          "first_name",
          "last_name",
          "position_id",
          "position_title"
        ],
        "metadata": [
          "INT",
          "VARCHAR",
          "VARCHAR",
          "VARCHAR",
          "BIGINT",
          "VARCHAR"
        ],
        "rows": [
          {
            "full_name": "Sheri Nowmer",
            "employee_id": "1",
            "last_name": "Nowmer",
            "position_title": "President",
            "first_name": "Sheri",
            "position_id": "1"
          },
          {
            "full_name": "Derrick Whelply",
            "employee_id": "2",
            "last_name": "Whelply",
            "position_title": "VP Country Manager",
            "first_name": "Derrick",
            "position_id": "2"
          }
        ]
      }
      
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                cgivre Charles Givre
                Reporter:
                cgivre Charles Givre
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: