drill 数据源配置

2023-01-02 10:58:32

1. mongodb

{
"type":"mongo",
"connection":"mongodb://user:password@host:port",
"enabled":true
}

对于没有密码的

{
"type":"mongo",
"connection":"mongodb://localhost:27017/",
"enabled":false
}

2. jdbc

{
"type":"jdbc",
"driver":"com.mysql.jdbc.Driver",
"url":"jdbc:mysql://localhost:3306",
"username":"root",
"password":"mypassword",
"enabled":true
}

{
"type":"jdbc",
"driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
"url":"jdbc:sqlserver://XXXXXX:1433;databaseName=XXXX",
"username":"XXXX",
"password":"XXXXX",
"enabled":true
}

{
"type":"jdbc",
"driver":"oracle.jdbc.OracleDriver",
"url":"jdbc:oracle:thin:username/userpassword@host:port:orcl",
"username":null,
"password":null,
"enabled":true
}

3. 文件系统

{
"type":"file",
"enabled":true,
"connection":"file:///",
"workspaces":{
"root":{
"location":"/user/max/donuts",
"writable":false,
"defaultInputFormat":null
}
},
"formats":{
"json":{
"type":"json"
}
}
}

4. hbase

{
"type":"hbase",
"config":{
"hbase.zookeeper.quorum":"10.10.100.62,10.10.10.52,10.10.10.53",
"hbase.zookeeper.property.clientPort":"2181"
},
"size.calculator.enabled":false,
"enabled":true
}

5. hive

{
"type":"hive",
"enabled":false,
"configProps":{
"hive.metastore.uris":"",
"javax.jdo.option.ConnectionURL":"jdbc:derby:;databaseName=../sample-data/drill_hive_db;create=true",
"hive.metastore.warehouse.dir":"/tmp/drill_hive_wh",
"fs.default.name":"file:///",
"hive.metastore.sasl.enabled":"false"
}
}