Github user liancheng commented on the pull request:
https://github.com/apache/spark/pull/9226#issuecomment-150926541
Did the following experiments against Hive 0.13.1, seems that Hive doesn't
accept partition directory with uppercase letters in partition column names.
First create a simple partitioned table (the `src` table is the one we
commonly used in Hive tests):
```sql
DROP TABLE IF EXISTS t;
CREATE TABLE t (key INT, value STRING) PARTITIONED BY (part INT);
INSERT OVERWRITE TABLE t PARTITION (part = 0) SELECT * FROM src;
INSERT OVERWRITE TABLE t PARTITION (part = 1) SELECT * FROM src;
```
Then manually rename the `part=0` partition directory to `ParT=0`. It
turned out that Hive doesn't recognize this partition anymore, and `SELECT *
FROM part = 0` gave empty result. `MSCK REPAIR TABLE t` doesn't work either.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
