在原始数据层创建表格并导入数据

    科技2025-11-15  6

    ODS层设计了三个表格,分别是ods_weblog_origin(原始日志表),ods_click_pageviews(点击模型表),ods_click_stream_visit(点击流模型表),建表语句如下:

    create table ods_weblog_origin( valid string, remote_addr string, remote_user string, time_local string, request string, status string, body_bytes_sent string, http_referer string, http_user_agent string) partitioned by (datestr string) row format delimited fields terminated by '\001'; create table ods_click_pageviews( session string, remote_addr string, remote_user string, time_local string, request string, visit_step string, page_staylong string, http_referer string, http_user_agent string, body_bytes_sent string, status string) partitioned by (datestr string) row format delimited fields terminated by '\001'; create table ods_click_stream_visit( session string, remote_addr string, inTime string, outTime string, inPage string, outPage string, referal string, pageVisits int) partitioned by (datestr string) row format delimited fields terminated by '\001';

    创建好表格后,向表格中导入数据,如下: ods_weblog_origin ods_click_stream_visit ods_click_pageviews

    Processed: 0.010, SQL: 8