...
- filepath cannot contain subdirectories.
- If the keyword LOCAL is not given, filepath must refer to files within the same filesystem as the table's (or partition's) location.
- Hive does some minimal checks to make sure that the files being loaded match the target table. Currently it checks that if the table is stored in sequencefile format, the files being loaded are also sequencefiles, and vice versa.
- A bug that prevented loading a file when its name includes the "+" character is fixed in release 0.13.0 (HIVE-6048).
- Please read CompressedStorage if your datafile is compressed.
...