Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
I'm having trouble debugging a pretty complicated query. I see this two messages currently, which I can fix after a bunch of debugging...but I would like to suggest some possible changes to the errors.
FAILED: Error in semantic analysis: The query does not reference any valid partition. To run this query, set hive.mapred.mode=nonstrict
...it would be awesome if you could tell me what table (real name and/ or alias, and/or the line where it was first referenced) is lacking the partition query. I'm almost certain that this is because my ds='foo' requirement is in an ON clause and not a WHERE clause, but I don't want to set nonstrict in the general case because it scares me.
Also:
FAILED: Error in semantic analysis: Schema of both sides of union should match: source:_col0 source
...it would similarly be awesome if it could tell me what "source:_col0" means, how the sides of the union do not match, why they don't match, or what doesn't match.