• tdh inceptor orc分区表和hdfs上表目录内文件的关系(值分区,范围分区)。


    drop table if exists user7;
    drop table if exists user7_0;
    drop table if exists user7_1;
    create table user7 (name string ,age int)partitioned by (sex string) stored as orc; 
    set hive.exec.dynamic.partition=true; 
    insert into table user7 partition(sex) select 'zs',1,'girl' from system.dual;
    
     create table user7_0 (name string ,age int ,sex string)stored as orc;
    
    load data inpath '/inceptorsql1/user/hive/warehouse/default.db/hive/user7/sex=girl' into table user7_0;
    
    insert into table user7 partition(sex) select 'zs',1,'girl' from system.dual;
    
     create table user7_1 (name string ,age int) stored as orc;
    load data inpath '/inceptorsql1/user/hive/warehouse/default.db/hive/user7/sex=girl' into table user7_1;
    
    
    select * from user7_0;
    select * from user7_1;

     

     这个实验,演示了分区表和非分区表的关系。值分区表的orc文件不保存分区列的值。

    下面试着演示范围分区:

    create table  user9(name string) partitioned by range (age int) 
    (
    PARTITION p5_105_205 VALUES LESS THAN (5),
    PARTITION p5_105_215 VALUES LESS THAN (10),
    PARTITION p5_115_205 VALUES LESS THAN (20),
    PARTITION p5_115_max VALUES LESS THAN (MAXVALUE)
    )stored as orc;
    insert into user9 select name,age from user4;
    dfs -ls /inceptorsql1/user/hive/warehouse/default.db/hive/user9/p5_105_215;
    
    create table user9_0(name string,age int) stored as orc;
    
    load data inpath '/inceptorsql1/user/hive/warehouse/default.db/hive/user9/p5_105_215/000000_0' into table user9_0;

    用dfs -ls 找出有数据的目录,然后将数据load到对应非分区表user9_0中。

    结果如下,说明范围分区表中的orc文件有和对应非分区表相同数量的列。

  • 相关阅读:
    SignalR学习笔记(一) 简单聊天室
    纽约工作日志流水账 Day 2
    纽约工作日志流水账 Day 1
    开放计算平台——数据仓库(Hive)权限控制
    SQL Standard Based Hive Authorization(基于SQL标准的Hive授权)
    jmap(Memory Map For Java)
    Hadoop CombineFileInputFormat实现原理及源码分析
    HiveServer连接优化
    Hive SQL运行状态监控(HiveSQLMonitor)
    jstack(Stack Trace for Java)
  • 原文地址:https://www.cnblogs.com/wifi0/p/7420793.html
Copyright © 2020-2023  润新知