hive中的单分区与多分区在hadoop上的对应关系

ゝ一世哀愁。 2023-01-06 14:52 123阅读 0赞

<table> 
 <thead> 
  <tr> 
   <th>分区叫法</th> 
   <th>表格举例</th> 
   <th>不同种类分区在HDFS上存放的文件结构</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>单分区/一级分区/主分区</td> 
   <td>t1</td> 
   <td>/user/hive/warehouse/<strong>t1/department=depart-1</strong></td> 
  </tr> 
  <tr> 
   <td>多分区/多级分区/副分区</td> 
   <td>t2</td> 
   <td>/user/hive/warehouse/<strong>t2/department=GBD/sex=F</strong></td> 
  </tr> 
 </tbody> 
</table>

根据上述表格中的对比也可以看到,  
所谓的多分区其实就是根目录(/user/hive/warehouse/t\*)下面的多级文件夹.查看Hive表的分区结构具体操作  
打开:

http://desktop:9870/explorer.html\#/

搜索:

/user/hive/warehouse/t1/department=depart-1

如下:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FwcGxleXVjaGk_size_16_color_FFFFFF_t_70]

搜索  
/user/hive/warehouse/t2/department=GBD/sex=F  
如下:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FwcGxleXVjaGk_size_16_color_FFFFFF_t_70 1]

Reference:

\[1\]hive一级分区、二级分区、动态分区

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FwcGxleXVjaGk_size_16_color_FFFFFF_t_70]: /images/20221119/0e8826555a1547158ba82c30856ea904.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FwcGxleXVjaGk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210206223456949.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FwcGxleXVjaGk=,size_16,color_FFFFFF,t_70