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.