既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,涵盖了95%以上大数据知识点,真正体系化!
由于文件比较多,这里只是将部分目录截图出来,全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频,并且后续会持续更新
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,
expire_time
timestamp,
tracking_no
string,
parent_order_id
bigint,
img_url
string,
province_id
int,
benefit_reduce_amount
decimal(16, 2),
original_total_amount
decimal(16, 2),
feight_fee
decimal(16, 2)
) partitioned by(etldate string) row format delimited fields terminated by ‘\001’ stored as textfile;
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!