drill 数据源配置
2024-10-16 01:05:42
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"
}
}
最新文章
- 操作数据库mysql
- tomcat启动指定项目
- codeforce好地方啊 Bear and Elections *
- ssdb使用
- java开发--struts2 标签库使用
- HDU 5317 RGCDQ (质数筛法,序列)
- 项目常用jquery/easyui函数小结
- HBase HTablePool
- MySql绿色版配置及使用详解
- Windows自删除程序和DLL
- ISLR系列:(4.3)模型选择 PCR &; PLS
- Page.Cache
- POJ 1456 - Supermarket - [贪心+小顶堆]
- java 3大特性
- java中String创建对象分析(转)
- sse实例
- nodejs 环境配置技巧
- my sql 只展示 前10条数据的写法
- linq to sql 中增删改查
- Linux入门基础(五):Linux管道,重定向,文本处理