本帖最后由 牵网线的 于 2022-5-10 15:33 编辑
1.创建数据库
- hive> create database DATABASES;
复制代码
2.查看数据库
- hive> show databases;
- OK
- default
- DATABASES
- Time taken: 0.019 seconds, Fetched: 2 row(s)
复制代码
3.切换数据库
切换数据库的时候可以输入:use database_name;
- hive> use DATABASES;
- OK
- Time taken: 0.012 seconds
复制代码
4.删除数据库
- hive> drop database if exists DATABASES;
复制代码
5.创建表
创建一个外部表,表有字段name,sex,age。comment后面内容为字段描述信息。- hive> create external table if not exists studenttable(
- > name string comment 'name value',
- > sex string comment 'sex value',
- > age string comment 'age value')
- > row format delimited
- > fields terminated by '\t'
- > lines terminated by '\n'
- > stored as textfile;
复制代码
6.查看所有表
- hive> show tables;
- OK
- testtable
- Time taken: 0.023 seconds, Fetched: 1 row(s)
复制代码
7.查看表信息
- hive> desc studenttable;
- OK
- name string name value
- sex string sex value
- age string age value
复制代码这里面有一个字段data,是string类型的,描述信息comment是“d comment”。
8.查看拓展描述信息
- hive> describe formatted studenttable;
- OK
- # col_name data_type comment
- name string name value
- sex string sex value
- age string age value
- # Detailed Table Information
- Database: zwctest
- Owner: root
- CreateTime: Sun Oct 23 17:52:38 CST 2016
- LastAccessTime: UNKNOWN
- Protect Mode: None
- Retention: 0
- Location: hdfs://test1:8020/user/hive/warehouse/zwctest.db/studenttable
- Table Type: EXTERNAL_TABLE
- Table Parameters:
- EXTERNAL TRUE
- transient_lastDdlTime 1477216358
- # Storage Information
- SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- InputFormat: org.apache.hadoop.mapred.TextInputFormat
- OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Compressed: No
- Num Buckets: -1
- Bucket Columns: []
- Sort Columns: []
- Storage Desc Params:
- field.delim \t
- line.delim \n
- serialization.format \t
- Time taken: 0.055 seconds, Fetched: 31 row(s)
- 注:desc为简写,可写全拼describe
复制代码
9.删除表
- hive> drop table testtable;
- OK
- Time taken: 0.198 seconds
复制代码
10.表加载数据
将/data/apps/test/zhangwenchao/data/data.txt里面的内容加载入table中
- hive> load data local inpath '/data/apps/test/zhangwenchao/data/data.txt' into table studenttable;
- Loading data to table zwctest.studenttable
- Table zwctest.studenttable: [numFiles=1, totalSize=2117]
复制代码
11.查看数据
|