使用mybatis操作hbase phoenix

一 环境

• 使用Spring Boot微服务
• hbase上部署了phoenix-server查询服务或者使用阿里云的hbase的phoenix查询服务

  二 用mybatis访问phonix的正确姿势

  其他配置与连mysql一样配置， 仅如下两个地方需要注意

  package com.mafgwo.phoenixmybatisdemo.config;
  
  import com.alibaba.druid.pool.DruidDataSource;
  import org.apache.phoenix.queryserver.client.Driver;
  import org.mybatis.spring.annotation.MapperScan;
  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
  import org.springframework.context.annotation.Bean;
  import org.springframework.context.annotation.Configuration;
  
  import javax.sql.DataSource;
  
  /**
   * hbase phoenix 扫描配置
   *
   * @author mafgwo
   * @since 2019/12/19
   */
  @Configuration
  @MapperScan(basePackages = "com.mafgwo.phoenixmybatisdemo.mapper")
  public class PhoenixForMybatisConfiguration {
  
      @Autowired
      private DataSourceProperties dataSourceProperties;
  
      @Bean
      public DataSource phoenixDataSource() {
          DruidDataSource druidDataSource = new DruidDataSource();
          druidDataSource.setDriverClassName(Driver.class.getName());
          druidDataSource.setUrl(dataSourceProperties.getUrl());
          return druidDataSource;
      }
  }

spring:
  datasource:
    url: jdbc:phoenix:thin:url=http://172.24.30.35:8765;serialization=PROTOBUF

三 具体参考demo

https://github.com/mafgwo/phoenix-mybatis-demo