Datax mysql 8.x elasticsearch 7.x 测试成功json样例
2023-09-27 14:23:15 时间
{ "job": { "setting": { "speed": { "channel": 1, "batchSize":1000 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "root", "password": "root", "connection": [ { "querySql": [ "select id as _id,id,name,content,createdate from t_user_info " ], "jdbcUrl": [ "jdbc:mysql://192.168.8.248:3306/sourcedb?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai" ] } ] } }, "writer": { "name": "elasticsearchwriter", "parameter": { "endpoint": "http://192.168.8.202:9200", "accessId": "elastic", "accessKey": "123456", "index": "test-1", "type": "_doc", "cleanup": true, "dynamic": false, "settings": {"index" :{"number_of_shards": 1, "number_of_replicas": 0}}, "discovery": false, "batchSize": 1000, "splitter": ",", "column": [ {"name":"pk","type":"id"}, { "name": "id","type": "keyword" }, { "name": "name","type": "keyword" }, { "name": "content", "type": "text", "analyzer": "ik_max_word"}, { "name": "createdate","type": "text", "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"} ] } } } ] } }
相关文章
- 关于MySQL的SLEEP(N)函数
- MySql不同版本安装
- 【MySQL高级】MySql中常用工具及Mysql 日志
- 在idea中SpringBoot2.4.1项目下,会默认使用mysql-connector-java-8.0.22驱动的错误原因
- [转]我的MYSQL学习心得(六) 函数
- ElasticSearch索引 和MySQL索引那个更高效实用那个更合适
- MySQL修改视图(ALTER VIEW)
- Mysql 操作命令 详解
- 记录一下MySql的一些查询语句使用案例
- mysql更新字段值提示You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode
- MySQL信息提示不是英文问题
- mysql性能优化-慢查询分析、优化索引和配置
- MySQL数据库获取多个汉字拼音的首字母函数
- MySQL第五个学习笔记 该数据表的操作
- MySQL子查询结果集是否有记录
- MySQL LIMIT OFFSET
- mysql 表的timestamp为自动添加
- Mysql经典45道题(详解31-45)
- MySQL 分组查询
- MySQL - 日志系统