mysql 分桶_使用hive脚本一键动态分区、分区又分桶以及脚本步骤详细详解（亲测成功）...

一、动态分区以及从linux本地文件映射到hive表中。

partitioned.sql脚本中的创造数据：

mkdir /mytemp

cd mytemp

vi stu_score.txt

1,zhangshan,50,1

2,lisi,67,1

3,tom,49,2

4,jery,48,2

hive脚本内容如下------partitioned.sql

set mapreduce.framework.name=local;

set hive.exec.dynamic.partition=true;

set hive.exec.dynamic.partition.mode=nonstrict;

use test;

drop table if exists stu_score;

create table if not exists stu_score(id int,name string,score int,status int) partitioned by (dt string) row format delimited fields terminated by ',';

load data local inpath '/mytemp/stu_score.txt' into table stu_score partition (dt='2018-10-18');

load data local inpath '/mytemp/stu_score.txt' into table stu_score partition (dt='2018-10-19');

dfs -cat /user/hive/warehouse/test.db/stu_score/dt=2018-10-18/stu_score.txt;

select * from stu_score;

show partitions stu_score;

create table if not exists stu_score_tmp(id int,name string,score int,status int) row format delimited f