Hi Hive experts, I encounter one issue about insert table using dynamice partition. My partition name contains the char ':', like '2016-01-01 00:00:00'. but when doing the dynamic partition insert, it seems the partition names in the target table will randomly contain '%253A' instead of '%3A'. do you know why this happens and how to deal with it?
Thanks very much, Jonathan drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-11-24 00%253A00%253A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-11-27 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-11-30 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-02 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-04 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-11 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-12 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-24 00%253A00%253A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-25 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-27 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-30 00%253A00%253A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2015-12-31 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-05 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-06 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-19 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-20 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-21 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-25 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-28 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-01-29 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-06 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-15 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-16 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-17 00%253A00%253A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-19 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-20 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-23 00%253A00%253A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-26 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-02-29 00%3A00%3A00 drwxrwxrwt - hive hive 0 2016-04-15 02:43 hdfs://lufaxhd/user/hive/warehouse/idw.db/dim_account_hist2/dw_latest_flag=N/dw_effect_end_date=2016-03-01 00%3A00%3A00
