drill 数据源配置补充
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"}}}
{"type":"file","enabled":true,"connection":"hdfs://XXXXX:8020","config":null,"workspaces":{"root":{"location":"/","writable":false,"defaultInputFormat":null},"userapps":{"location":"/userapps","writable":true,"defaultInputFormat":null},"tmp":{"location":"/tmp","writable":true,"defaultInputFormat":null}},"formats":{"psv":{"type":"text","extensions":["tbl"],"delimiter":"|"},"csv":{"type":"text","extensions":["csv"],"delimiter":","},"tsv":{"type":"text","extensions":["tsv"],"delimiter":"\t"},"httpd":{"type":"httpd","logFormat":"%h %t \"%r\" %>s %b \"%{Referer}i\"","timestampFormat":null},"parquet":{"type":"parquet"},"json":{"type":"json","extensions":["json"]},"avro":{"type":"avro"},"sequencefile":{"type":"sequencefile","extensions":["seq"]},"csvh":{"type":"text","extensions":["csvh"],"extractHeader":true,"delimiter":","}}}
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","":"file:///","hive.metastore.sasl.enabled":"false"}}
