drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1285) Use of URLs to retrieve JSON data
Date Tue, 12 Aug 2014 05:03:13 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-1285:
----------------------------------

    Fix Version/s:     (was: 0.5.0)
                   0.6.0

> Use of URLs to retrieve JSON data
> ---------------------------------
>
>                 Key: DRILL-1285
>                 URL: https://issues.apache.org/jira/browse/DRILL-1285
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Storage - JSON
>    Affects Versions: 0.4.0
>            Reporter: Luca Morandini
>             Fix For: 0.6.0
>
>
> Since there are a few databases (MongoDB ,CouchDB) that produce JSON via ReST APIs, and
a host of other APIs too, it would be nice to have them as data sources.
> Some examples:
> # CouchDB: a request like:
> {{curl -X GET "http://127.0.0.1:5984/drinks/_design/drinks/_view/byName"}}
> may generate:
> {code}
> {"total_rows":4,"offset":0,"rows":[
> {"id":"3b510371b46c2f20cd7d72a527007e2a","key":"angler's cocktail","value":"Angler's
Cocktail"},
> {"id":"3b510371b46c2f20cd7d72a52700af45","key":"manhattan","value":"Manhattan"},
> {"id":"3b510371b46c2f20cd7d72a527008dd5","key":"martini","value":"Martini"},
> {"id":"3b510371b46c2f20cd7d72a527009c27","key":"old fashioned","value":"Old Fashioned"}
> ]}{code}
> # A WFS query like:
> {{curl -X GET "https://geosrv.aurin.org.au/geoserver/grattan/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=grattan:Grattan_Employ_Inc2011&maxFeatures=50&outputFormat=json&propertyName=SSC_NAME,SSC2011"}}
> may generate:
> {code}
> {
>     "type": "FeatureCollection",
>     "features": [
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.1",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Abbotsbury",
>                 "SSC2011": 10001
>             }
>         },
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.2",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Abbotsford (NSW)",
>                 "SSC2011": 10002
>             }
>         },
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.3",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Abercrombie",
>                 "SSC2011": 10003
>             }
>         },
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.4",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Aberdare",
>                 "SSC2011": 10004
>             }
>         },
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.5",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Aberdeen (NSW)",
>                 "SSC2011": 10005
>             }
>         },
>         {
>             "type": "Feature",
>             "id": "Grattan_Employ_Inc2011.50",
>             "geometry": null,
>             "properties": {
>                 "SSC_NAME": "Argents Hill",
>                 "SSC2011": 10050
>             }
>         }
>     ]
> }{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message