Stamatis Zampetakis created HIVE-24745:
------------------------------------------
Summary: Document rules for implicit type conversions
Key: HIVE-24745
URL: https://issues.apache.org/jira/browse/HIVE-24745
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Stamatis Zampetakis
Although there is some documentation about implicit type conversions that are
[allowed in
Hive|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-AllowedImplicitConversions]
there is no specification defining how conversions should work when the types
are not the same (which type should be converted to which type).
This makes query results hard to interpret and may lead to clients complaining
about wrong results even when the behavior is expected. Moreover, the absence
of a specification makes potential fixes harder to land since it is difficult
to agree on what is the expected behavior.
It would really help if there was a document such as the one provided by
[SQLServer|https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-type-precedence-transact-sql?view=sql-server-ver15]
clearly stating what should be the result of a conversion between two types.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
