[HIVE-20340] Druid Needs Explicit CASTs from Timestamp to STRING when the output of timestamp function is used as String

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Druid integration
• Target Version/s: 4.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 08/Aug/18 20:06
• Updated: 17/Nov/22 08:55
• Resolved: 10/Aug/18 17:15

Description

Druid time expressions return numeric values in form of ms (instead of formatted timestamp). Because of this expressions/function which expects its argument as string type ended up returning different values for time expressions input.

e.g. 

SELECT SUBSTRING(to_date(datetime0),4) FROM tableau_orc.calcs;
| 4-07-25  |

SELECT SUBSTRING(to_date(datetime0),4) FROM druid_tableau.calcs;
| 0022400000  |

SELECT CONCAT(to_date(datetime0),' 00:00:00') FROM tableau_orc.calcs;
| 2004-07-17 00:00:00  |

SELECT CONCAT(to_date(datetime0),' 00:00:00') FROM druid_tableau.calcs;
| 1090454400000 00:00:00  |
 

Druid needs explicit cast to make this work

Issue Links

• duplicates: HIVE-20341 Druid Needs Explicit CASTs from Timestamp to STRING when the output of timestamp function is used as String