Jonathan Chang created HIVE-2977: ------------------------------------ Summary: Type widening on Union Alls doesn't make sense. Key: HIVE-2977 URL: https://issues.apache.org/jira/browse/HIVE-2977 Project: Hive Issue Type: Bug Reporter: Jonathan Chang Assignee: Namit Jain
When type widening occurs in a UNION ALL query between a STRING column and a BIGINT column, both are casted to DOUBLE which doesn't make any sense since this is lossy for both inputs. It should cast both to STRING. Additionally this should throw an error in strict mode. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira