Add test for HIVE-11470

HIVE-11470 added capability to handle NULL dynamic partitioning keys properly. However, it did not add a test for the case, we should have one so we don't have future regressions of the same.