kudu常见问题处理

Posted on

guide of kudu

无

impala上操作kudu

  1. 建表

    1. ```sql
      CREATE TABLE dc_stg.kudu_crm_dm_dealer_logs_new (

      id  bigint COMMENT '主键id',
dealer_id  bigint  COMMENT '门店ID',
account_id  bigint COMMENT '账户ID',
cuid  bigint COMMENT '创建者',
opt_info  string COMMENT '信息',
created  string  COMMENT '创建时间',
status  int  COMMENT '状态',
remark  string COMMENT '审核备注/操作记录',
username  string COMMENT '创建者姓名',

      PRIMARY KEY ( id )
      ) PARTITION BY HASH PARTITIONS 16 COMMENT ‘门店操作日志’
      STORED AS KUDU;

      1
      2
      3
      4
      5
      6
      7

         2. 特征`STORED AS KUDU`

      2. 删表

         1. ```sql
            drop TABLE  dc_stg.kudu_crm_dm_dealer_logs_new;

    2. 此时，impala中关于kudu表的映射关系已删除；但是，kudu表依旧存在

    3. ```shell
      kudu table delete bigdata01:7051,bigdata04:7051 impala::dc_stg.kudu_crm_dm_dealer_logs_new

      1
      2
      3
      4
      5
      6
      7

         4. ⚠️表名前impala::不可缺失

      3. 数据刷新

         1. ```sql
            refresh dc_stg.kudu_crm_dm_dealer_logs_new;