beeline 命令行客户端连接hive

来源：互联网发布：sap软件实施编辑：程序博客网时间：2024/05/14 05:41

[hadoop@mina0 bin]$ ll总用量 888-rwxr-xr-x. 1 hadoop hadoop   1031 4月  30 2015 beelinedrwxrwxr-x. 3 hadoop hadoop   4096 10月 15 23:41 ext-rwxr-xr-x. 1 hadoop hadoop   7844 5月   8 2015 hive-rwxr-xr-x. 1 hadoop hadoop   1900 4月  30 2015 hive-config.sh-rwxr-xr-x. 1 hadoop hadoop    885 4月  30 2015 hiveserver2-rwxr-xr-x. 1 hadoop hadoop    832 4月  30 2015 metatool-rw-r--r--. 1 hadoop hadoop 875336 10月 15 15:56 mysql-connector-java-5.1.28.jar-rwxr-xr-x. 1 hadoop hadoop    884 4月  30 2015 schematool[hadoop@mina0 bin]$ cd ..[hadoop@mina0 hive]$ cd bin[hadoop@mina0 bin]$ ./beelineBeeline version 1.2.1 by Apache Hive

beeline> !connect jdbc:hive2://localhost:10000Connecting to jdbc:hive2://localhost:10000Enter username for jdbc:hive2://localhost:10000: hadoopEnter password for jdbc:hive2://localhost:10000: Connected to: Apache Hive (version 1.2.1)Driver: Hive JDBC (version 1.2.1)Transaction isolation: TRANSACTION_REPEATABLE_READ0: jdbc:hive2://localhost:10000> show databases0: jdbc:hive2://localhost:10000> ;+----------------+--+| database_name  |+----------------+--+| default        || shizhan03      |+----------------+--+2 rows selected (1.801 seconds)0: jdbc:hive2://localhost:10000> show databases;+----------------+--+| database_name  |+----------------+--+| default        || shizhan03      |+----------------+--+2 rows selected (0.055 seconds)0: jdbc:hive2://localhost:10000> use shizhan03;No rows affected (0.083 seconds)0: jdbc:hive2://localhost:10000> show tables;+-----------+--+| tab_name  |+-----------+--+| t_sz01    |+-----------+--+1 row selected (0.062 seconds)0: jdbc:hive2://localhost:10000>

阅读全文

0 0