Hive 动态分区模式详解 - hive.exec.dynamic.partition.mode 参数说明

hive.exec.dynamic.partition.mode \u662f Hive \u4e2d \u7528\u6765\u63a7\u5236\u52a8\u6001\u5206\u533a\u7684\u6a21\u5f0f\u7684\u53c2\u6570\u3002\u52a8\u6001\u5206\u533a\u6307\u7684\u662f\u5728\u63d2\u5165\u6570\u636e\u65f6\u81ea\u52a8\u521b\u5efa\u5206\u533a\u76ee\u5f52\uff0c\u5e76\u5c06\u6570\u636e\u653e\u5165\u76f8\u5e94\u7684\u5206\u533a\u76ee\u5f52\u4e2d\u3002hive.exec.dynamic.partition.mode \u6709\u4e09\u79cd\u53ef\u9009\u7684\u6a21\u5f0f\uff1a\n\n- nonstrict\uff1a\u8868\u793a\u52a8\u6001\u5206\u533a\u6a21\u5f0f\u662f\u975e\u4e25\u683c\u7684\u3002\u5728\u8fd9\u79cd\u6a21\u5f0f\u4e0b\uff0cHive \u4f1a\u81ea\u52a8\u521b\u5efa\u4e0d\u5b58\u5728\u7684\u5206\u533a\u76ee\u5f52\uff0c\u5e76\u5c06\u6570\u636e\u653e\u5165\u76f8\u5e94\u7684\u5206\u533a\u76ee\u5f52\u4e2d\u3002\u5982\u679c\u63d2\u5165\u7684\u6570\u636e\u4e2d\u5305\u542b\u4e86\u4e0d\u5b58\u5728\u7684\u5206\u533a\u5b57\u6bb5\u503c\uff0cHive \u4f1a\u81ea\u52a8\u521b\u5efa\u8fd9\u4e2a\u5206\u533a\u76ee\u5f52\u5e76\u5c06\u6570\u636e\u653e\u5165\u5176\u4e2d\u3002\n- strict\uff1a\u8868\u793a\u52a8\u6001\u5206\u533a\u6a21\u5f0f\u662f\u4e25\u683c\u7684\u3002\u5728\u8fd9\u79cd\u6a21\u5f0f\u4e0b\uff0cHive \u53ea\u4f1a\u5c06\u6570\u636e\u63d2\u5165\u5df2\u5b58\u5728\u7684\u5206\u533a\u76ee\u5f52\u4e2d\u3002\u5982\u679c\u63d2\u5165\u7684\u6570\u636e\u4e2d\u5305\u542b\u4e86\u4e0d\u5b58\u5728\u7684\u5206\u533a\u5b57\u6bb5\u503c\uff0cHive \u4f1a\u6295\u51fa\u4e00\u4e2a\u9519\u8bef\uff0c\u5e76\u65e0\u6cd5\u63d2\u5165\u6570\u636e\u3002\n- strict_in_column\uff1a\u8868\u793a\u52a8\u6001\u5206\u533a\u6a21\u5f0f\u662f\u5728\u5217\u7ea7\u5c42\u4e0a\u662f\u4e25\u683c\u7684\u3002\u5728\u8fd9\u79cd\u6a21\u5f0f\u4e0b\uff0cHive \u53ea\u4f1a\u5c06\u6570\u636e\u63d2\u5165\u5df2\u5b58\u5728\u7684\u5206\u533a\u76ee\u5f52\u4e2d\uff0c\u5e76\u4e14\u5bf9\u4e8e\u6bcf\u4e2a\u5206\u533a\u5b57\u6bb5\uff0c\u5fc5\u987b\u5728\u63d2\u5165\u6570\u636e\u65f6\u90fd\u63d0\u4f9b\u5206\u533a\u5b57\u6bb5\u7684\u503c\u3002\u5982\u679c\u67d0\u4e2a\u5206\u533a\u5b57\u6bb5\u7684\u503c\u6ca1\u6709\u63d0\u4f9b\uff0cHive \u4f1a\u6295\u51fa\u4e00\u4e2a\u9519\u8bef\uff0c\u5e76\u65e0\u6cd5\u63d2\u5165\u6570\u636e\u3002\n\n\u4f7f\u7528 hive.exec.dynamic.partition.mode \u53c2\u6570\u53ef\u4ee5\u7075\u6d3b\u5730\u63a7\u5236\u52a8\u6001\u5206\u533a\u7684\u884c\u4e3a\uff0c\u6839\u636e\u5b9e\u9645\u9700\u6c42\u9009\u62e9\u9002\u5408\u7684\u6a21\u5f0f\u3002