birthday date,
gender string,
create_time timestamp,
operate_time timestamp)
partitioned by(etldate string) row format delimited fields terminated by ‘\001’ stored as textfile;

insert into table ods.user_info partition (etldate=“19971201”) values(6814,“89xtog”,“周杰伦”,“”,“卖片”,17777124243,“89xtong@163.net”,“”,1,“1965-04-26”,“M”,“2020-04-26 18:55:55”,“2020-04-26 5:53:55”);

CREATE TABLE ods.sku_info (
id bigint,
spu_id bigint,
price decimal(10, 0),
sku_name string,
sku_desc string,
weight decimal(10, 2),
tm_id bigint,
category3_id bigint,
sku_default_img string,
create_time timestamp
)partitioned by(etldate string)
row format delimited fields terminated by ‘\001’ stored as textfile;

insert into ods.sku_info partition(etldate=“19971201”) values(1,1,2220,“测试”,“new ssku_desc”,0.24,2,61,“http://www.baidu.com”,“1997-12-01 12:21:13”);

CREATE TABLE ods.base_province (
id bigint,
name string,
region_id string,
area_code string,
iso_code string
)partitioned by(etldate string) row format delimited fields terminated by ‘\001’ stored as textfile;

insert into table ods.base_province partition (etldate=“19971201”) values(0,“测试”,1,110000,“CN-11”);
alter table ods.base_province add columns (‘create_time’ timestamp);

CREATE TABLE ods.base_region (
id string,
region_name string
)partitioned by(etldate string) row format delimited fields terminated by ‘\001’ stored as textfile;

insert into table ods.base_region partition (etldate=“19971201”) values (0,“测试”);
alter table ods.base region add columns (‘create time’ timestamp);

CREATE TABLE ods.order_detail (
id bigint,
order_id bigint,
sku_id bigint,
sku_name string,
img_url string,
order_price decimal(10, 2),
sku_num string,
create_time timestamp,
source_type string,
source_id bigint
) partitioned by(etldate string) row format delimited fields terminated by ‘\001’ stored as textfile;

insert into table ods.order_detail partition(etldate=“19971201”) values(8621,3443,4,“测试”,“http://www.baidu.com”,1442.00,1,“1997-12-01 18:47:14”,2401,“”);

CREATE TABLE ods.order_info (
id bigint,
consignee string,
consignee_tel string,
final_total_amount decimal(16, 2),
order_status string,
user_id bigint,
delivery_address string,
order_comment string,
out_trade_no string,
trade_body string,
create_time timestamp,
operate_time timestamp,

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上大数据知识点，真正体系化！

由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新

需要这份系统化资料的朋友，可以戳这里获取

、实战项目、大纲路线、讲解视频，并且后续会持续更新**

需要这份系统化资料的朋友，可以戳这里获取