数仓里面出现Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7] was not registered for synchronization because synchronization is not active JDBC Connection [ProxyConnection[PooledConnection[org.postgresql.jdbc.PgConnection@3eecce5d]]] will not be managed by Spring ==> Preparing: select updateTime, seat, price, tax, currency, cabin from price_fligth_detail_flow_w6 where flightNum = ? and dep_city = ? and arr_city = ? and dep_date = ? and updateTime > ? and updateTime < ? order by updateTime ==> Parameters: W94002(String), LON(String), BEG(String), 2022-12-18(String), 2022-10-23 00:00:00.0(Timestamp), 2022-10-25 23:59:59.999(Timestamp) <== Columns: updatetime, seat, price, tax, currency, cabin <== Row: 2022-10-25 01:37:06.27+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 01:37:11.754+08, 9, 192.49, 7.50, GBP, F <== Row: 2022-10-25 06:11:10.536+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:05.744+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:07.873+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:09.348+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:11.855+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 07:32:53.937+08, 9, 192.49, 7.50, GBP, F <== Row: 2022-10-25 10:34:32.514+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 13:06:18.073+08, 3, 175.49, 7.50, GBP, GF <== Row: 2022-10-25 13:06:22.847+08, 9, 192.49, 7.50, GBP, F <== Total: 11 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7]这个是mybatis的执行结果和数仓里面执行sql的结果不一样
看着是什么jdbc连接有点问题。这个应该是应用端的问题。Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@581034b7] was not registered for synchronization because synchronization is not active JDBC Connection MySQL到Hologres可以看下这个文档 https://help.aliyun.com/document_detail/290024.html(此答案整理自实时数仓Hologres交流群)
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
本技术圈将为大家分析有关阿里云产品Hologres的最新产品动态、技术解读等,也欢迎大家加入钉钉群--实时数仓Hologres交流群32314975