[jira] [Commented] (DRILL-7437) Storage Plugin for Generic HTTP REST API

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-7437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17043508#comment-17043508 ] 

ASF GitHub Bot commented on DRILL-7437:
---------------------------------------

cgivre commented on pull request #1892: DRILL-7437: Storage Plugin for Generic HTTP REST API
URL: https://github.com/apache/drill/pull/1892#discussion_r383266742
 
 

 ##########
 File path: contrib/storage-http/src/main/java/org/apache/drill/exec/store/http/util/SimpleHttp.java
 ##########
 @@ -0,0 +1,235 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.drill.exec.store.http.util;
+
+import okhttp3.Cache;
+import okhttp3.Credentials;
+import okhttp3.FormBody;
+import okhttp3.Interceptor;
+import okhttp3.OkHttpClient;
+import okhttp3.OkHttpClient.Builder;
+import okhttp3.Request;
+import okhttp3.Response;
+
+import org.apache.drill.common.exceptions.UserException;
+import org.apache.drill.exec.ExecConstants;
+import org.apache.drill.exec.ops.FragmentContext;
+import org.apache.drill.exec.store.http.HttpAPIConfig;
+import org.apache.drill.exec.store.http.HttpStoragePluginConfig;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import java.io.File;
+import java.io.IOException;
+import java.io.InputStream;
+import java.util.Map;
+import java.util.concurrent.TimeUnit;
+import java.util.regex.Pattern;
+
+
+/**
+ * This class performs the actual HTTP requests for the HTTP Storage Plugin. The core method is the getInputStream()
+ * method which accepts a url and opens an InputStream with that URL's contents.
+ */
+public class SimpleHttp {
+  private static final Logger logger = LoggerFactory.getLogger(SimpleHttp.class);
+
+  private final OkHttpClient client;
+
+  private final HttpStoragePluginConfig config;
+
+  private final FragmentContext context;
+
+  private final HttpAPIConfig apiConfig;
+
+  public SimpleHttp(HttpStoragePluginConfig config, FragmentContext context, String connectionName) {
+    this.config = config;
+    this.context = context;
+    this.apiConfig = config.connections().get(connectionName);
+    client = setupServer();
+  }
+
+
+
+  public InputStream getInputStream(String urlStr) {
+    Request.Builder requestBuilder;
+
+    // The configuration does not allow for any other request types other than POST and GET.
+    if (apiConfig.method().equals("get")) {
+      // Handle GET requests
+      requestBuilder = new Request.Builder().url(urlStr);
+    } else {
+      // Handle POST requests
+      FormBody.Builder formBodyBuilder = buildPostBody();
+      requestBuilder = new Request.Builder()
+        .url(urlStr)
+        .post(formBodyBuilder.build());
+    }
+
+    // Add headers to request
+    if (apiConfig.headers() != null) {
+      for (Map.Entry<String, String> entry : apiConfig.headers().entrySet()) {
+        String key = entry.getKey();
+        String value = entry.getValue();
+        requestBuilder.addHeader(key, value);
+      }
+    }
+
+    // Build the request object
+    Request request = requestBuilder.build();
+    logger.debug("Headers: {}", request.headers());
+
+    try {
+      // Execute the request
+      Response response = client
+        .newCall(request)
+        .execute();
+      logger.debug(response.toString());
+
+      // If the request is unsuccessful, throw a UserException
+      if (!response.isSuccessful()) {
+        throw UserException.dataReadError()
+          .message("Error retrieving data: " + response.code() + " " + response.message())
+          .addContext("Response code: ", response.code())
+          .build(logger);
+      }
+      logger.debug("HTTP Request for {} successful.", urlStr);
+      logger.debug("Response Headers: {} ", response.headers().toString());
+
+      // Return the InputStream of the response
+      return response.body().byteStream();
+    } catch (IOException e) {
+      throw UserException.functionError()
+        .message("Error retrieving data")
+        .addContext(e.getMessage())
+        .build(logger);
+    }
+  }
+
+  /**
+   * Function configures the OkHTTP3 server object with configuration info from the user.
+   *
+   * @return OkHttpClient configured server
+   */
+  private OkHttpClient setupServer() {
 
 Review comment:
   Renamed this `setupHttpClient`
 
----------------------------------------------------------------
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:
users@infra.apache.org


> Storage Plugin for Generic HTTP REST API
> ----------------------------------------
>
>                 Key: DRILL-7437
>                 URL: https://issues.apache.org/jira/browse/DRILL-7437
>             Project: Apache Drill
>          Issue Type: New Feature
>            Reporter: Charles Givre
>            Assignee: Charles Givre
>            Priority: Minor
>             Fix For: Future
>
>
> 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]
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)