cgivre opened a new pull request #1892: Drill-7437: Storage Plugin for Generic HTTP REST API URL: https://github.com/apache/drill/pull/1892 In many data analytic situations there is a need to obtain reference data which is volatile or hosted on a service with a REST API. For instance, consider the case of a financial dataset which you want to run a currency conversion. Or in the security arena, an organization might have a service that returns network information about an IT asset. The goal being to enable Drill to quickly incorporate external data that is only accessible via REST API. This plugin is not intended to be a substitute for dedicated storage plugins with systems that use a REST API, such as Apache Solr or ElasticSearch. This plugin is based on several projects that were posted on github but never completed or submitted to Drill. Posted here for attribution: - https://github.com/kevinlynx/drill-storage-http - https://github.com/mayunSaicmotor/drill-storage-http ## Usage To configure the plugin, create a new storage plugin, and add the following configuration options: ``` { "type": "http", "connection": "https://api.sunrise-sunset.org/";, "resultKey": "results", "enabled": true } ``` The options are: * `type`: This should be `http` * `connection`: This should be the root level URL for your API. * `resultKey`: The result key is the key in the results which contains a table-like structure of the data you want to retrieve. Using this will help you eliminate other data that often is transmitted in API calls. ### Sample: ``` SELECT sunrise, sunset FROM api.`/json?lat=36.7201600&lng=-4.4203400&date=today`; ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
