hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zh_wu <zh...@163.com>
Subject tricky issue when insert table using dynamic paritition
Date Fri, 15 Apr 2016 07:28:06 GMT
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







Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message