无法为Oracle创建Drill存储插件 [英] Can't create Drill storage plugin for oracle

问题描述

我想在钻探中为oracle jdbc创建存储插件.我将ojdbc7.jar复制到apache-drill-1.3.0/jars/3rdparty路径，并将drill.exec.sys.store.provider.local.path = "/mypath"添加到dill.override.conf. 当我想使用以下配置创建新的存储插件时:

I want to create storage plugin in drill for oracle jdbc. I copy ojdbc7.jar to apache-drill-1.3.0/jars/3rdparty path and add drill.exec.sys.store.provider.local.path = "/mypath" to dill.override.conf. when I want to create a new storage plugin with below configuration:

 {
  "type": "jdbc",
  "enabled": true,
  "driver": "oracle.jdbc.OracleDriver",
  "url":"jdbc:oracle:thin:user/pass@x.x.x.x:1521/orcll"
}

我收到无法创建/更新存储空间错误.

我正在使用Redhat 7&钻版本-1.3.在分布式模式下.

I am using Redhat 7 & Drill version - 1.3. in distributed mode.

推荐答案

我猜问题出在默认架构名称上.它应该是 orcl ，而不是 orcll .

I guess the problem is with default schema name. It should be orcl instead of orcll.

插件:

{
  "type": "jdbc",
  "enabled": true
  "driver": "oracle.jdbc.OracleDriver",
  "url": "jdbc:oracle:thin:user/pass@x.x.x.x:1521:orcl"   
}

这篇关于无法为Oracle创建Drill存储插件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！