Drill

cherkavi · cherkavi · commit e8965d7faba8 · 2021-02-17T21:22:55.000+01:00
diff --git a/drill/drill.md b/drill/drill.md
@@ -0,0 +1,9 @@
+execute on cluster
+```sh
+java -classpath drill-test-1.0.jar drill.DrillCollaboration 
+```
+
+```
+class not found: Failure in connecting to Drill: org.apache.drill.exec.rpc.NonTransientRpcException: javax.security.sasl.SaslException: Unknown mechanism: MAPRSASL
+# -Ddrill.customAuthFactories=org.apache.drill.exec.rpc.security.maprsasl.MapRSaslFactory
+```
diff --git a/drill/pom.xml b/drill/pom.xml
@@ -12,8 +12,22 @@
         <dependency>
             <groupId>org.apache.drill.exec</groupId>
             <artifactId>drill-jdbc-all</artifactId>
-            <version>1.14.0</version>
+            <version>1.16.0</version>
         </dependency>
     </dependencies>
 
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-compiler-plugin</artifactId>
+                <version>3.1</version>
+                <configuration>
+                    <source>1.6</source>
+                    <target>1.6</target>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+
 </project>
diff --git a/drill/src/main/java/drill/DrillCollaboration.java b/drill/src/main/java/drill/DrillCollaboration.java
@@ -1,3 +1,5 @@
+package drill;
+
 import java.sql.*;
 import java.lang.ClassNotFoundException;
 
@@ -7,14 +9,14 @@ public class DrillCollaboration {
     // private static final String JDBC_DRIVER = "oadd.org.apache.calcite.avatica.remote.Driver";
     private static final String JDBC_DRIVER = "org.apache.drill.jdbc.Driver";
 
-    private static final String CONNECTION_URL = "jdbc:drill:drillbit=ubsdpdesp000103.vantagedp.org:31010;auth=MAPRSASL";
-    // private static final String QUERY = "select sessionId, isReprocessable from dfs.`/mapr/dp.prod.zurich/vantage/data/store/v6/BM67/2020/*/*/part*.parquet`";
+    // private static final String CONNECTION_URL = "jdbc:drill:drillbit=127.0.0.1:41010;auth=MAPRSASL";
+    private static final String CONNECTION_URL = "jdbc:drill:drillbit=127.0.0.1:41010;auth=MAPRSASL";
     private static final String QUERY = "select * from sys.version";
 
     private static Connection getConnection() throws ClassNotFoundException, SQLException {
-        System.out.println("get class by name: "+JDBC_DRIVER);
+        System.out.println(">>> get class by name: "+JDBC_DRIVER);
         Class.forName(JDBC_DRIVER);
-        System.out.println("obtaining connection");
+        System.out.println(">>> obtaining connection");
         return DriverManager.getConnection(CONNECTION_URL);
     }
 
@@ -23,17 +25,17 @@ public static void main(String[] args) throws SQLException {
         try {
             connection = getConnection();
         } catch (ClassNotFoundException e) {
-            System.err.println("class not found: "+e.getMessage());
+            System.err.println("!!! class not found: "+e.getMessage());
             System.exit(1);
         } catch (SQLException e) {
-            System.err.println("class not found: "+e.getMessage());
+            System.err.println("!!! class not found: "+e.getMessage());
             System.exit(2);
         }
-        System.out.println("connection established");
+        System.out.println(">>> connection established");
         Statement statement = connection.createStatement();
-        System.out.println("statement created");
+        System.out.println(">>> statement created");
         ResultSet resultSet = statement.executeQuery(QUERY);
-        System.out.println("attempt to retrieve results");
+        System.out.println(">>> attempt to retrieve results");
         while (resultSet.next()) {
             System.out.println(resultSet.getString(1));
         }
