This is great. thanks Luca for the detailed JIRA. -Neeraja
On Mon, Aug 11, 2014 at 7:19 PM, Luca Morandini (JIRA) <[email protected]> wrote: > Luca Morandini created DRILL-1285: > ------------------------------------- > > Summary: 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.5.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) >
