When we ingest the following data 2015-11-01 21:10:00.1
2015-11-01 21:10:00.1190011
2015-11-01 21:10:00.12
2015-11-01 21:10:00.123
2015-11-01 21:10:00.1234
2015-11-01 21:10:00.12345
2015-11-01 21:10:00.123456789
2015-11-01 21:10:00.490155
2015-11-01 21:10:00.1234567890
2015-11-01 21:10:00.1234567890123456789
I get the following when I do the "select", I get NULL for the last two rows instead of just truncating the additional digits. This is HDP 2.6.1 & Hive 1.2.1000 select * from test_timestamp;
+--------------------------------+--+
| test_timestamp.col |
+--------------------------------+--+
| 2015-11-01 21:10:00.1 |
| 2015-11-01 21:10:00.1190011 |
| 2015-11-01 21:10:00.12 |
| 2015-11-01 21:10:00.123 |
| 2015-11-01 21:10:00.1234 |
| 2015-11-01 21:10:00.12345 |
| 2015-11-01 21:10:00.123456789 |
| 2015-11-01 21:10:00.490155 |
| NULL |
| NULL |
... View more
