hive的静态分区和动态

1、在Hive分区的创HivePartitionedbyPartitioned在Hive分区的创HivePartitionedbyPartitionedby静态分create table par_tab (name string,nation string) partitioned by string) row format delimited byhivedesc #Partition # col_nameTime 0.038 seconds, 8 par_tab.txt，loaddatalocalinpath/home/hadoop/files/par_tab.txt par_tab part

2、ition (sex=man);oloaddatalocalinpath/home/hadoop/files/par_tab.txt par_tab partition (sex=man);oselect * from Time taken: seconds,Fetched:6files$ hadoop -drwxr-xr- hadoop 0 2017-03-rwxr-xr-1 hadoop 71 2017-03-创建一个目录（表名）sex=man（分区名），最后在分区名下存放实际loaddatalocalinpath/home/hadoop/files/par_tab_wm.txt par_

3、tab partition (sex=woman);o hadoophadoop001 files$ hadoop -drwxr-xr- hadoop 0 2017-03-rwxr-xr-1 hadoop 71 2017-03-drwxr-xr- hadoop 0 2017-03-rwxr-xr-1 hadoop hadoophadoop001 files$ hadoop -drwxr-xr- hadoop 0 2017-03-rwxr-xr-1 hadoop 71 2017-03-drwxr-xr- hadoop 0 2017-03-rwxr-xr-1 hadoop 41 2017-03-*

4、 from Time taken: 0.136 seconds, Fetched: 9 select frompar_tab where Time taken: 0.515 seconds, Fetched: 3 hive create table par_tab_muilt (name string, partitionedby(sexstring,dtstring)rowformatdelimitedfields terminated by , ;hiveloaddatalocalinpath/home/hadoop/files/par_tab.txt table par_tab_muil

5、t partition (sex=man,dt=2017-03-29);ohadoophadoop001 files$ hadoop dfs -drwxr-xr- hadoop 0 2017-03-29 drwxr-xr- hadoop 0 2017-03-29 /user/hive/warehouse/par_tab_muilt/sex=man/dt=2017-03-rwxr-xr-1 hadoop 71 2017-03-29 /user/hive/warehouse/par_tab_muilt/sex=man/dt=drwxr-xr- hadoop 0 2017-03-29 drwxr-x

6、r- hadoop 0 2017-03-29 /user/hive/warehouse/par_tab_muilt/sex=man/dt=2017-03-rwxr-xr-1 hadoop 71 2017-03-29 /user/hive/warehouse/par_tab_muilt/sex=man/dt=2017-03-别）动态分loaddatahive set select from 2013-03-2013-03-2013-03-2013-03-2013-03-2013-03-2013-03-2013-03-2013-03-Time taken: 1.141 seconds, Fetch

7、ed: 9 hive insert overwrite table par_dnm select name, nation, dt from drwxr-xr- hadoop 0 2017-03-drwxr-xr- hadoop 0 2017-03-/user/hive/warehouse/par_dnm/sex=man/dt=2013-03-rwxr-xr-drwxr-xr- hadoop 0 2017-03-drwxr-xr- hadoop 0 2017-03-/user/hive/warehouse/par_dnm/sex=man/dt=2013-03-rwxr-xr-1 hadoop 41 2017-03-/user/hive/warehouse/par_dnm/sex=man/dt=2013-03-drwxr-xr- hadoop 0 2017-03-29 /user/hive/warehouse/par_dnm/sex=man/dt=2013-03-rwxr-xr-1 hadoop 71 2017-03-29 /user/hive/warehouse/par_dnm/sex=man/dt=2013-03-hivesho rtitions sex=man/dt=2013-03