Apache Hive(二) 基本使用

ゞ浴缸里的玫瑰 2023-03-13 03:37 10阅读 0赞

## 命令交互 ##

### 交互式命令 ###

#### hive ####

`bin/hive`

##### `-e` 语句 #####

hive -e "select * from student"

##### `-f` sql 文件 #####

hive -f xx.sql

#### beeline ####

启动 hiveserver2

bin/hiveserver2
    
    nohup bin/hiveserver2 > > /dev/null 2>&1 &

> 不考虑鉴权

> bin/beeline -u jdbc:hive2://  
> bin/beeline -u jdbc:hive2://localhost:10000
> 
> bin/beeline -u jdbc:hive2://localhost:10000 -n user -p password

\-u : 指定元数据库的链接信息  
\-n : 指定用户名  
\-p : 指定密码

[root@flinkhadoop apache-hive-3.1.2-bin]# bin/beeline -u jdbc:hive2://localhost:10000
    Connecting to jdbc:hive2://localhost:10000
    Connected to: Apache Hive (version 3.1.2)
    Driver: Hive JDBC (version 3.1.2)
    Transaction isolation: TRANSACTION_REPEATABLE_READ
    Beeline version 3.1.2 by Apache Hive
    -----------------------------------------------------------------------------------------
    0: jdbc:hive2://localhost:10000> show databases;
    INFO  : Compiling command(queryId=root_20200505160643_f1b21663-6cec-47aa-95c9-908257f726e8): show databases
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Semantic Analysis Completed (retrial = false)
    INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from deserializer)], properties:null)
    INFO  : Completed compiling command(queryId=root_20200505160643_f1b21663-6cec-47aa-95c9-908257f726e8); Time taken: 0.633 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=root_20200505160643_f1b21663-6cec-47aa-95c9-908257f726e8): show databases
    INFO  : Starting task [Stage-0:DDL] in serial mode
    INFO  : Completed executing command(queryId=root_20200505160643_f1b21663-6cec-47aa-95c9-908257f726e8); Time taken: 0.05 seconds
    INFO  : OK
    INFO  : Concurrency mode is disabled, not creating a lock manager
    +----------------+
    | database_name  |
    +----------------+
    | default        |
    +----------------+
    1 row selected (1.09 seconds)
    -----------------------------------------------------------------------------------------
    0: jdbc:hive2://localhost:10000> use default;
    INFO  : Compiling command(queryId=root_20200505160657_5226fdd4-7eda-4d95-8982-5d365a0ddc32): use default
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Semantic Analysis Completed (retrial = false)
    INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
    INFO  : Completed compiling command(queryId=root_20200505160657_5226fdd4-7eda-4d95-8982-5d365a0ddc32); Time taken: 0.013 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=root_20200505160657_5226fdd4-7eda-4d95-8982-5d365a0ddc32): use default
    INFO  : Starting task [Stage-0:DDL] in serial mode
    INFO  : Completed executing command(queryId=root_20200505160657_5226fdd4-7eda-4d95-8982-5d365a0ddc32); Time taken: 0.042 seconds
    INFO  : OK
    INFO  : Concurrency mode is disabled, not creating a lock manager
    No rows affected (0.067 seconds)
    -----------------------------------------------------------------------------------------
    0: jdbc:hive2://localhost:10000> show tables;
    INFO  : Compiling command(queryId=root_20200505160708_df7dcccf-69c4-4409-8612-3b09371ae42b): show tables
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Semantic Analysis Completed (retrial = false)
    INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
    INFO  : Completed compiling command(queryId=root_20200505160708_df7dcccf-69c4-4409-8612-3b09371ae42b); Time taken: 0.01 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=root_20200505160708_df7dcccf-69c4-4409-8612-3b09371ae42b): show tables
    INFO  : Starting task [Stage-0:DDL] in serial mode
    INFO  : Completed executing command(queryId=root_20200505160708_df7dcccf-69c4-4409-8612-3b09371ae42b); Time taken: 0.038 seconds
    INFO  : OK
    INFO  : Concurrency mode is disabled, not creating a lock manager
    +-----------+
    | tab_name  |
    +-----------+
    | student   |
    +-----------+
    1 row selected (0.067 seconds)
    -----------------------------------------------------------------------------------------
    0: jdbc:hive2://localhost:10000> select * from student;
    INFO  : Compiling command(queryId=root_20200505160716_97324e8a-1b5f-41a2-9315-ff846b54afaa): select * from student
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Semantic Analysis Completed (retrial = false)
    INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:student.id, type:int, comment:null), FieldSchema(name:student.name, type:string, comment:null)], properties:null)
    INFO  : Completed compiling command(queryId=root_20200505160716_97324e8a-1b5f-41a2-9315-ff846b54afaa); Time taken: 1.06 seconds
    INFO  : Concurrency mode is disabled, not creating a lock manager
    INFO  : Executing command(queryId=root_20200505160716_97324e8a-1b5f-41a2-9315-ff846b54afaa): select * from student
    INFO  : Completed executing command(queryId=root_20200505160716_97324e8a-1b5f-41a2-9315-ff846b54afaa); Time taken: 0.0 seconds
    INFO  : OK
    INFO  : Concurrency mode is disabled, not creating a lock manager
    +-------------+---------------+
    | student.id  | student.name  |
    +-------------+---------------+
    | 1000        | ss            |
    +-------------+---------------+
    1 row selected (1.213 seconds)

### Hue ###

#### 配置 ####

`vi /opt/hue/hue-release-4.6.0/desktop/conf/hue.ini`

# Host where HiveServer2 is running.
      # If Kerberos security is enabled, use fully-qualified domain name (FQDN).
      hive_server_host=192.168.1.102
    
      # Binary thrift port for HiveServer2.
      hive_server_port=10000
    
      # Http thrift port for HiveServer2.
      hive_server_http_port=10001
    
      # Host where LLAP is running
      ## llap_server_host = localhost
    
      # LLAP binary thrift port
      ## llap_server_port = 10500
    
      # LLAP HTTP Thrift port
      ## llap_server_thrift_port = 10501

#### 创建用户 ####

因为默认的hue是admin用户

为了和hive保持一致，创建一个root账户，不然会报权限问题

![image-20200505161057579][]

#### 写sql ####

![image-20200505161130825][]

[image-20200505161057579]: /images/20230312/8149946679fe48b18160503b633e7169.png
[image-20200505161130825]: /images/20230312/758ac29ef5f0460186edcd8ff428da45.png