問題描述
我想在鉆頭中為 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 存儲插件的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！