序号类型地址1MySQL
2MySQL
3MySQL
4MySQL
5MySQL
6MySQL
7MySQL
8MySQL
9MySQL
10MySQL
11MySQL
12MySQL
13MySQL
14MySQL
15MyBatis
16MyBatis
17MyBatis
18MyBatis
19MyBatis-Plus
20MyBatis-Plus
21MyBatis-Plus
22MyBatis-Plus
23MyBatis-Plus
24MyBatis-Plus
25MyBatis-Plus
<dependency>
<groupId>com.baomidougroupId>
<artifactId>mybatis-plus-boot-starterartifactId>
<version>3.5.1version>
dependency>
<dependency>
<groupId>org.apache.hivegroupId>
<artifactId>hive-jdbcartifactId>
<version>2.3.8version>
dependency>
spring.datasource.dynamic.hive.driver-class-name=org.apache.hive.jdbc.HiveDriver
spring.datasource.dynamic.hive.url=jdbc:hive2://192.168.0.1:10000/user
spring.datasource.dynamic.hive.username=root
spring.datasource.dynamic.hive.password=root12345
spring.datasource.dynamic.hive.druid.filters=stat,slf4j
import lombok.Data;
import java.io.Serializable;
@Data
public class HiveSql implements Serializable {
private static final long serialVersionUID = 1L;
}
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lydms.entity.HiveSql;
@DS("hive")
public interface HiveSqlMapper extends BaseMapper<HiveSql> {
@SqlParser(filter = true)
void explainQuery(String sql);
}
DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lydms.mapper.HiveSqlMapper">
<update id="explainQuery">
${templateName,jdbcType=VARCHAR}
update>
mapper>
import com.lydms.mapper.HiveSqlMapper;
import com.lydms.entity.HiveSql;
@Autowired
private HiveSqlMapper hiveSqlMapper;
@Override
public R<String> checkSqlRule(String sql) {
hiveSqlMapper.explainQuery(sql);
}
dbType not support : sqlite
:
解决:
配置监控统计拦截的filters,去掉后监控界面sql无法统计,’wall’用于防火墙(启动sqlite时候需要关闭wall)。把filters中的 stat,wall,slf4j
改成 stat,slf4j
spring.datasource.dynamic.hive.druid.filters=stat,slf4j
http://www.zyiz.net/tech/detail-143690.html
Original: https://blog.csdn.net/weixin_44624117/article/details/124973383
Author: ha_lydms
Title: Mybatis-Plus(连接Hive)
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/817809/
转载文章受原作者版权保护。转载请注明原作者出处!