You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Luca Morandini (JIRA)" <ji...@apache.org> on 2014/08/12 04:19:11 UTC
[jira] [Created] (DRILL-1285) Use of URLs to retrieve JSON data
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)
Re: [jira] [Created] (DRILL-1285) Use of URLs to retrieve JSON data
Posted by Neeraja Rentachintala <nr...@maprtech.com>.
This is great.
thanks Luca for the detailed JIRA.
-Neeraja
On Mon, Aug 11, 2014 at 7:19 PM, Luca Morandini (JIRA) <ji...@apache.org>
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)
>