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)

Reply via email to