【文件属性】:
文件名称:Hive的数据模型-外部表语法-hive基础ppt
文件大小:741KB
文件格式:PPT
更新时间:2021-04-25 17:33:33
hive
Hive的数据模型-外部表语法
CREATE EXTERNAL TABLE page_view
( viewTime INT,
userid BIGINT,
page_url STRING,
referrer_url STRING,
ip STRING COMMENT 'IP Address of the User',
country STRING COMMENT 'country of origination‘
)
COMMENT 'This is the staging page view table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION 'hdfs://centos:9000/user/data/staging/page_view';