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.

Reply via email to