Hive: when pasted into a partitioned table, in most rows, hive double url-encode section section column

I created a partitioned table:

create table  t1 ( amount double) partitioned by ( events_partition_key string) stored as paquet;

some data was added in tmp_table, where the column "events_partition_key" contains a timestamp (row type) in the following format: "2018-02-25 00:00:00"

Then I insert some data into a partitioned table.

insert into table t1 partition (events_partition_key)
select amount, events_partition_key
from tmp_table

when you select t1 from a new partitioned table, in some cases the events_partition_key column is regularly displayed in the same way as in tmp_table, i.e. "2018-02-25 00:00:00", but in most cases it looks like a URL-encoded one, i.e. "2018-02-25 00% 3A00% 3A00"

it looks like when selecting individual events_partition_key

In any case, the original partition_key column does not make any difference when it was encoded in the URL or not,

:

show partitions t1;

URL- (.. "2018-02-25 00% 253A00% 253A00" ), (.. "2018-02-25 00% 3A00% 3A00" )

enter image description here

, , .

+6

All Articles