2024年大数据最新大数据竞赛数据抽取部分_gy_pub(2)，2024年最新一线互联网大厂中高级大数据开发面试真题收录

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

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

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

mysql -uroot -proot

create database shtd_store;

use shtd_store;

source ~/ds_pub.sql和gy_pub.sql文件，先上传至服务器家目录下。

链接：https://pan.baidu.com/s/1FmbqH86kG1cpQ8K6n7TJoQ?pwd=egeu 
提取码：egeu 
–来自百度网盘超级会员V5的分享

Hive数据准备

create database ods;
use ods;

create table if not exists ods.user_info(
  id bigint,
  login_name string,
  nick_name string,
  password string,
  name string,
  phone_num string,
  email string,
  head_img string,
  user_level string,
  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,"测试");


![img](https://img-blog.csdnimg.cn/img_convert/5f2b5ebeb3bc5f20cd893797abcfc6f0.png)
![img](https://img-blog.csdnimg.cn/img_convert/c3c31cf0d5cf48a18c88bfef680c0f17.png)
![img](https://img-blog.csdnimg.cn/img_convert/8eb3d9c253799edadfb6cf559944a372.png)

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

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

**[需要这份系统化资料的朋友，可以戳这里获取](https://bbs.csdn.net/topics/618545628)**

面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新**

**[需要这份系统化资料的朋友，可以戳这里获取](https://bbs.csdn.net/topics/618545628)**