Hive的数据模型-外部表语法-hive基础ppt

【文件属性】：

文件名称：Hive的数据模型-外部表语法-hive基础ppt

文件大小：741KB

文件格式：PPT

更新时间：2024-05-15 11:20:13

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';