DDL之表操作
操作 DDL
2023-09-14 09:06:09 时间
Create Table
CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name -- (Note: TEMPORARY available in Hive 0.14.0 and later)
[(col_name data_type [column_constraint_specification] [COMMENT col_comment], ... [constraint_specification])]
[COMMENT table_comment]
[PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
[CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]
[SKEWED BY (col_name, col_name, ...) -- (Note: Available in Hive 0.10.0 and later)]
ON ((col_value, col_value, ...), (col_value, col_value, ...), ...)
[STORED AS DIRECTORIES]
[
[ROW FORMAT row_format]
[STORED AS file_format]
| STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)] -- (Note: Available in Hive 0.6.0 and later)
]
[LOCATION hdfs_path]
[TBLPROPERTIES (property_name=property_value, ...)] -- (Note: Available in Hive 0.6.0 and later)
[AS select_statement]; -- (Note: Available in Hive 0.5.0 and later; not supported for external tables)
列的名称,列的类型
CREATE TABLE emp(
empno int,
ename string,
job string,
mgr int,
hiredate string,
sal double,
comm double,
deptno int
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’;
Describe Table/View/Materialized View/Column
DESCRIBE [EXTENDED|FORMATTED]
table_name[.col_name ( [.field_name] | [.'$elem$'] | [.'$key$'] | [.'$value$'] )* ];
-- (Note: Hive 1.x.x and 0.x.x only. See "Hive 2.0+: New Syntax" below)
hive (default2)> desc formatted emp;在工作中FORMATTED比EXTENDED用的多因为这样可以更加清晰的看出来表的结构
Rename Table
ALTER TABLE table_name RENAME TO new_table_name;
hive (default2)> ALTER TABLE emp rename to emp2;
相关文章
- DDL,DML操作对结果缓存的影响
- 关于laravel5.4.12新增集合操作when方法详解
- Quartz2.x任务计划调度操作工具类
- Yii2.0 对数据库 查询的简单操作
- Python操作rabbitmq消息队列持久化
- Docker 基础操作 容器自启动 删除镜像和删除容器
- Hadoop Hive创建外部表及多表join操作
- [转]php 操作数组 (合并,拆分,追加,查找,删除等)
- littlevgl之obj简单操作
- 什么是Java中的原子操作( atomic operations)
- 操作Ubuntu系统编写C程序的【写、读、删】操作
- Python文件操作之批量生成已标注好的.xml、.json
- Hive DDL数据定义、DML数据操作
- 适合小白入手,超级详细的Jmeter系列之数据库操作