[jira] [Created] (HIVE-17616) running msck on a table partitioned by a timestamp column reports invalid character

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

Zoltan Haindrich created HIVE-17616:
---------------------------------------

             Summary: running msck on a table partitioned by a timestamp column reports invalid character
                 Key: HIVE-17616
                 URL: https://issues.apache.org/jira/browse/HIVE-17616
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Haindrich


test:
{code}
create table micky (endtimestamp string, id string, logLevel string, count bigint) partitioned by (xstart timestamp) stored as orc;
insert into micky partition (xstart="2017-09-27 13:51:58") values ("2017-09-27 13:52:58", "5", "WARN", 5);
insert into micky partition (xstart="2017-09-27 13:54:58") values ("2017-09-27 13:55:58", "6", "INFO", 6);
select * from micky;
create external table mini (endtimestamp string, id string, logLevel string, count bigint) partitioned by (xstart timestamp)
 stored as orc location "${system:test.warehouse.dir}/micky";
MSCK REPAIR TABLE mini;
{code}

results in:
{code}
2017-09-27T05:20:03,960  WARN [3bff4423-d4cf-4142-ad6e-476757c9a0b0 main] exec.DDLTask: Failed to run metacheck: 
org.apache.hadoop.hive.ql.metadata.HiveException: Repair: Cannot add partition mini:xstart=2017-09-27 13%3A51%3A58.0 due to invalid characters in the name
        at org.apache.hadoop.hive.ql.exec.DDLTask.msck(DDLTask.java:2027) [hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:436) [hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]
[...]
{code}

present on current master



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)