Hive can use JDBC to connect, does that mean, and can be used in the project by means of multiple source switching mybatis to connect the hive, I feel feasible, but online look like didn't do it, do it what are the pros and cons,

CodePudding user response:

The key problem is not mybatis, but in the JDBC connection pool
Hive SQL execution time can't estimate, short a few seconds, a few days to have long, generally according to the minutes, the business is calculated on ms SQL
Mybatis is with + spring JDBC connection pool - the template combination to have an advantage, and the hive after don't need both, so use mybatis difference is not very big