SpringBoot整合presto

发布于:2023-07-27 ⋅ 阅读:(78) ⋅ 点赞:(0)

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 后查看

网站公告

今日签到

点亮在社区的每一天
去签到