[
https://issues.apache.org/jira/browse/DRILL-1285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luca Morandini updated DRILL-1285:
----------------------------------
Description:
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}
was:
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}
> 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)
