[jira] Created: (HIVE-825) Better error messages regarding partitions and union all?

["Adam Kramer (JIRA)" <ji...@apache.org>]

Better error messages regarding partitions and union all?
---------------------------------------------------------

                 Key: HIVE-825
                 URL: https://issues.apache.org/jira/browse/HIVE-825
             Project: Hadoop Hive
          Issue Type: Improvement
            Reporter: Adam Kramer


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.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.