kylin-jdbc-pool

better performance for kylin query with spring boot project

spring boot version

• 1.5.4.RELEASE

versions

• 1.0.0 —— jdbc pool & RowMapper
• 1.1.0 —— support muti data sources
• 1.1.1 —— support gson SerializedName annotation
• 2.0.0 —— refactor project architecture

how to use ?

first configure settings

kylin:
  project1:
    userName: admin
    password: KYLIN
    decrypt: true
    connectionUrl: jdbc:kylin://host:7070/project1
    maxWaitTime: 10000 #ms
  project2:
    userName: admin
    password: KYLIN
    decrypt: true
    connectionUrl: jdbc:kylin://host:7070/project2
    maxWaitTime: 10000 #ms

then try your business

@RunWith(SpringRunner.class)
@SpringBootTest
public class KylinJdbcPoolApplicationTests {

  @Resource(name = "project1JdbcTemplate")
  JdbcTemplate project1JdbcTemplate;
  @Resource(name = "project2JdbcTemplate")
  JdbcTemplate project2JdbcTemplate;

  @Test
  public void test() {
    int countResult = project1JdbcTemplate
        .queryForObject("select count(*) from SCHEMA.table",
            (resultSet, i) -> {
              return resultSet.getInt(1);
            });

    System.out.println("testResult: " + countResult);
  }

  @Test
  public void testRowMapper() {
    List<Demo> demoList = project1JdbcTemplate
        .query("select * from from SCHEMA.table limit 10",
            KylinRowMapper.getDefault(
                Demo.class));

    System.out.println(JSON.toJSONString(demoList));
  }

}