hive 建表语句（外部表）

最新推荐文章于 2023-11-04 14:02:30 发布

原创最新推荐文章于 2023-11-04 14:02:30 发布 · 3.4k 阅读

1 ·

CC 4.0 BY-SA版权

2018年7月专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个具体的外部表创建示例，详细列出了表结构、字段类型、存储格式及位置等信息，适用于大数据处理环境。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE EXTERNAL TABLE `ias.tbl_ex_pengpai_topic_data_origin_orc`(
  `record_time` string,
  `trace_id` string,
  `template_version` string,
  `template_type` string,
  `client_time` string,
  `protocol_version` string,
  `app_version` string,
  `app_package_name` string,
  `ias_client_version` string,
  `ias_client_hsn_id` string,
  `job_id` string,
  `task_id` string,
  `location` string,
  `mobile` string,
  `ias_client_ip` string,
  `topic_id` string,
  `topic_title` string,
  `topic_pic_url` string,
  `topic_description` string,
  `topic_publish_time` string,
  `author_name` string,
  `author_fans_count` string,
  `author_description` string,
  `page_name` string COMMENT 'page_name')
  PARTITIONED BY (`dt` string,`hour` string)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\t'
  LINES TERMINATED BY '\n'
STORED AS ORC
LOCATION '/data/ias/snapshot/tbl_ex_pengpai_topic_data_origin_orc'