hive中关于表的一些操作指令

hive表操作

1.建表

    CREATE TABLE `test_part_category`(
    > rowkey  string COMMENT 'hbase中rowkey',
    > mid  string,
    > market_id  bigint,
    > code  string,
    > key  string,
    > value  string, 
    > create_time  string COMMENT '创建时间',
    > update_time  string COMMENT '修改时间')
    > COMMENT '测试表'
    > partitioned BY (category_key string COMMENT '属性分区字段(101:人口，102:社会）')
    > row format delimited fields terminated by '\u0001'
    > lines terminated by '\n'
    > null defined AS ''
    > stored as textfile;

2.添加分区

alter table test_part_category add partition(category_key='101');

3.删除分区

alter table test_part_category drop if exists partition(category_key='101');

4.查询分区

show partitions test_part_category;

5.新增列

alter table test_part_category add columns(market_name string);

6.删除列(将rowkey这个字段算删除),原始字段的值不会随之丢失

alter table test_part_category replace columns(
mid  string,
market_id  bigint,
code  string,
key  string,
value  string, 
create_time  string COMMENT '创建时间',
update_time  string COMMENT '修改时间'))

7.修改字段

alter table tablename change column column_orign column_new int(修改后列的属性)