求助:hive 1.1版本cast(timestamp as date) 的问题
在hive1.1版本上运行以下sql :
select start_time,cast(o.start_time as date) = '2017-10-17',order_no from wedw_dw.consult_order_df o where order_no='17101717104618467552' and cast(o.start_time as date) ='2017-10-17';
返回:
+-------------+-------+-----------------------+--+
| start_time | _c1 | order_no |
+-------------+-------+-----------------------+--+
| NULL | NULL | 17101717104618467552 |
+-------------+-------+-----------------------+--+
但是在hive1.0版本上运行 返回的是
+-------------+-------+-----------------------+--+
| start_time | _c1 | order_no |
+-------------+-------+-----------------------+--+
| 2017-10-17 20:00:00 | true | 17101717104618467552 |
+-------------+-------+-----------------------+--+
这是为什么呢?难道是hive1.1的bug?