POM
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.facebook.presto</groupId>
<artifactId>presto-jdbc</artifactId>
<version>0.203</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
</dependency>
配置文件
@Configuration
public class GlobalDataSourceConfiguration {
@Bean(name = "prestoDataSource")
@ConfigurationProperties(prefix = "spring.datasource.presto")
public DataSource prestoDataSource() {
return new DruidDataSource();
}
@Autowired
@Qualifier("prestoDataSource")
DataSource dataSource;
@Bean(name = "prestoTemplate")
public JdbcTemplate prestoJdbcTemplate() {
return new JdbcTemplate(dataSource);
}
}
测试类
@RestController
public class PrestoDemo {
@Autowired
@Qualifier("prestoTemplate")
JdbcTemplate jt;
@RequestMapping("/cassandra")
public Map<String, Object> cassandra(){
return jt.queryForMap("select count(*) from cassandra.data_store.facedata");
}
}
测试结果
1048
本文含有隐藏内容,请 开通VIP 后查看