[Hive]Hive分区表新增字段

一直没有尝试，被分区的概念吓到了，今天尝试了下，很简单

hive (default)> desc pms.test_cross_sale_path;OKcol_name data_type commentpath_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;OKTime taken: 0.012 secondshive (pms)> alter table test_cross_sale_path add columns(platform_id int, tpa int);OKTime taken: 0.012 seconds新增的字段将加到该表的最后，，分区字段之前，并且在以前的分区中这两个字段都为NULL

hive (default)> desc pms.test_cross_sale_path;OKcol_namedata_typecommentpath_idstringvisit_track_idstringvisit_product_idbigintvisit_category_idbigintvisit_brand_idbigintrcmd_track_idstringrcmd_product_idbigintrcmd_category_idbigintrcmd_brand_idbigintrcmd_algorithm_idbigintcart_track_idstringcart_track_timestringcart_product_idbigintcart_category_idbigintcart_brand_idbigintpath_typeintpath_lengthintpath_liststringsession_idstringgu_idstringend_user_idstringplatform_idinttpaintdsstringTime taken: 3.159 seconds

也和他共度。甚至连吵架也是重复的，