Hive table 操作

最新推荐文章于 2024-01-26 12:44:14 发布

原创最新推荐文章于 2024-01-26 12:44:14 发布 · 197 阅读

0 ·

CC 4.0 BY-SA版权

分布计算专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了如何使用Hive的CREATE EXTERNAL TABLE语句来创建外部表，实现数据的存储与管理。重点包括外部表的创建语法、参数解释、以及分区和排序的设置。此外，还阐述了不同格式文件的存储方式，如DELIMITED、TEXTFILE等，为大数据处理提供了高效的数据组织解决方案。

http://www.cnblogs.com/ggjucheng/archive/2013/01/04/2844393.html

Create [EXTERNAL] TABLE [IF NOT EXISTS] table_name
[(col_name data_type [COMMENT col_comment], …)]
[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]
[ROW FORMAT row_format]
[STORED AS file_format]
[LOCATION hdfs_path]

CREATE TABLE page_view(
viewTime INT,
userid BIGINT,
page_url STRING,
referrer_url STRING,
ip STRING COMMENT ‘IP Address of the User’)
COMMENT ‘This is the page view table’
PARTITIONED BY(dt STRING, country STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\001’
COLLECTION ITEMS TERMINATED BY ‘\002’
MAP KEYS TERMINATED BY ‘\003’
STORED AS TEXTFILE;