drill 数据源配置

1. mongodb

1. {
2. "type":"mongo",
3. "connection":"mongodb://user:password@host:port",
4. "enabled":true
5. }

对于没有密码的

1. {
2. "type":"mongo",
3. "connection":"mongodb://localhost:27017/",
4. "enabled":false
5. }

2. jdbc

1. {
2. "type":"jdbc",
3. "driver":"com.mysql.jdbc.Driver",
4. "url":"jdbc:mysql://localhost:3306",
5. "username":"root",
6. "password":"mypassword",
7. "enabled":true
8. }

1. {
2. "type":"jdbc",
3. "driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
4. "url":"jdbc:sqlserver://XXXXXX:1433;databaseName=XXXX",
5. "username":"XXXX",
6. "password":"XXXXX",
7. "enabled":true
8. }

1. {
2. "type":"jdbc",
3. "driver":"oracle.jdbc.OracleDriver",
4. "url":"jdbc:oracle:thin:username/userpassword@host:port:orcl",
5. "username":null,
6. "password":null,
7. "enabled":true
8. }

 

3. 文件系统

1. {
2. "type":"file",
3. "enabled":true,
4. "connection":"file:///",
5. "workspaces":{
6. "root":{
7. "location":"/user/max/donuts",
8. "writable":false,
9. "defaultInputFormat":null
10. }
11. },
12. "formats":{
13. "json":{
14. "type":"json"
15. }
16. }
17. }

4. hbase

1. {
2. "type":"hbase",
3. "config":{
4. "hbase.zookeeper.quorum":"10.10.100.62,10.10.10.52,10.10.10.53",
5. "hbase.zookeeper.property.clientPort":"2181"
6. },
7. "size.calculator.enabled":false,
8. "enabled":true
9. }

5. hive

1. {
2. "type":"hive",
3. "enabled":false,
4. "configProps":{
5. "hive.metastore.uris":"",
6. "javax.jdo.option.ConnectionURL":"jdbc:derby:;databaseName=../sample-data/drill_hive_db;create=true",
7. "hive.metastore.warehouse.dir":"/tmp/drill_hive_wh",
8. "fs.default.name":"file:///",
9. "hive.metastore.sasl.enabled":"false"
10. }
11. }