[ https://issues.apache.org/jira/browse/DRILL-6847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6847: ------------------------------------ Fix Version/s: 1.15.0 > Add Query Metadata to RESTful Interface > --------------------------------------- > > Key: DRILL-6847 > URL: https://issues.apache.org/jira/browse/DRILL-6847 > Project: Apache Drill > Issue Type: Improvement > Components: Metadata > Reporter: Charles Givre > Assignee: Arina Ielchiieva > Priority: Minor > Fix For: 1.15.0 > > > 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: > {code:sql} > 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 > {code} > {code} > { > "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" > } > ] > } > {code} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)