beeline采用jdbc方式连接数据库,连得最多的就是hive数据库,但实际上只要有jdbc driver,beeline都可以连。下面以oracle连接为例
#将oracle jdbc driver 拷贝到hive所在目录下的lib目录中,这一点很重要。beeline会把这个目录下的所有jar包统一纳入classpath
cp oracle-connector-java.jar /opt/cloudera/parcesl/CDH/lib/hive/lib
#启动beeline
beeline
#执行scan命令,列出所有支持的jdbc driver
beeline> !scan
scan complete in 1434ms
11 driver classes found
Compliant Version Driver Class
yes 12.2 oracle.jdbc.OracleDriver
yes 12.2 oracle.jdbc.driver.OracleDriver
yes 1.0 org.apache.calcite.avatica.remote.Driver
yes 1.0 org.apache.calcite.jdbc.Driver
yes 1.0 org.apache.commons.dbcp.PoolingDriver
yes 10.11 org.apache.derby.jdbc.AutoloadedDriver
yes 10.11 org.apache.derby.jdbc.Driver42
yes 10.11 org.apache.derby.jdbc.EmbeddedDriver
yes 10.11 org.apache.derby.jdbc.InternalDriver
no 1.1 org.apache.hive.jdbc.HiveDriver
yes 1.0 org.datanucleus.store.rdbms.datasource.dbcp.PoolingDriver
beelie>!connect 'jdbc:oracle:thin:@oracle_server:1521/devdb_s'
输入用户名,密码,连接成功。