本文主要包含hive 新增字段,hive表新增字段,hive 增加字段,hive修改表字段,hive 修改字段类型等服务器相关知识,网友希望可以进行参考
[Hive]Hive分区表新增字段，hive分区表新增字段
一直没有尝试，被分区的概念吓到了，今天尝试了下，很简单
hive (default)> desc pms.test_cross_sale_path; OK col_name data_type comment path_id string visit_track_id string visit_product_id bigint visit_category_id bigint visit_brand_id bigint rcmd_track_id string rcmd_product_id bigint rcmd_category_id bigint rcmd_brand_id bigint rcmd_algorithm_id bigint cart_track_id string cart_track_time string cart_product_id bigint cart_category_id bigint cart_brand_id bigint path_type int path_length int path_list string session_id string gu_id string end_user_id string ds string Time taken: 3.159 seconds在上表中新增两个字段platform_id、tpa，类型均为int类型
hive (pms)> alter table pms.test_cross_sale_path add columns(platform_id int, tpa int); FAILED: ParseException line 1:12 cannot recognize input near 'pms' '.' 'test_cross_sale_path' in alter table statement这样执行会有问题，数据库名默认不支持，换种写法即可
hive (pms)> use pms; OK Time taken: 0.012 seconds hive (pms)> alter table test_cross_sale_path add columns(platform_id int, tpa int); OK Time taken: 0.012 seconds新增的字段将加到该表的最后，分区字段之前，并且在以前的分区中这两个字段都为NULL
hive (default)> desc pms.test_cross_sale_path; OK col_name data_type comment path_id string visit_track_id string visit_product_id bigint visit_category_id bigint visit_brand_id bigint rcmd_track_id string rcmd_product_id bigint rcmd_category_id bigint rcmd_brand_id bigint rcmd_algorithm_id bigint cart_track_id string cart_track_time string cart_product_id bigint cart_category_id bigint cart_brand_id bigint path_type int path_length int path_list string session_id string gu_id string end_user_id string platform_id int tpa int ds string Time taken: 3.159 seconds