Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22508

mariadb/CONNECT - no suitable driver found for apache drill jdbc

    XMLWordPrintable

    Details

      Description

      in relation to MDEV-10936

      Hi All!

      i am trying to set up Mariadb/CONNECT to federate towards Apache Drill

      a working JDBC connector towards drill works via the following connection string

      Database Driver:  org.apache.drill.jdbc.impl.DriverImpl  
      Database URL: jdbc:drill:drillbit=127.0.0.1:31010  
      Database Type:  drill
      

      i'm using the apache drill jdbc driver
      ../apache-drill-1.17.0/jars/jdbc-driver/drill-jdbc-all-1.17.0.jar

      however, when i want to create a table

      create table jt1 engine=connect table_type=JDBC connection='jdbc:drill:drillbit=127.0.0.1:31010';

      i get the following error

      ERROR 1105 (HY000): Connecting: java.sql.SQLException: No suitable driver found for jdbc:drill:drillbit=127.0.0.1:31010 rc=-2

      is there a way to specify the driver as "org.apache.drill.jdbc.impl.DriverImpl" as you would in a regular jdbc connection?

            // load the JDBC driver
            Class.forName("org.apache.drill.jdbc.impl.DriverImpl");
      

      Thx in advance!

      Herman

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            hermy herman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration