hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hajime <haj...@hajigle.com>
Subject Is "Allowed Implicit conversions" up to date?
Date Wed, 12 Dec 2018 07:03:41 GMT
Hi everyone,

I'm just wondering if the table in this page is up to date?
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-AllowedImplicitConversions

It seems bigint and timestamp do implicit conversions:

0: jdbc:hive2://node1.ubuntu.localdomain:1051> select
cast(unix_timestamp('2018-12-12 00:00:00', 'yyyy-MM-dd HH:mm:ss') as
bigint) == cast('2018-12-12 00:00:00.0' as timestamp);
+-------+--+
|  _c0  |
+-------+--+
| true  |
+-------+--+

Or am i misunderstanding how to read this table?

Thank you!
Hajime

Mime
View raw message