在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?
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/107944.html
標籤：其他數據庫
上一篇：db2中去除表里面的所有括號
下一篇：visual foxpro