[HIVE-18729] Druid Time column type

• Type: Task
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Component/s: Druid integration
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Slim Bouguerra
• Created: 16/Feb/18 15:20
• Updated: 27/Feb/24 22:23
• Resolved: 28/Jul/18 15:24

Description

I have talked Offline with jcamachorodriguez about this and agreed that the best way to go is to support both cases where Druid time column can be Timestamp or Timestamp with local time zone. 

In fact, for the Hive-Druid internal table, this makes perfect sense since we have Hive metadata about the time column during the CTAS statement then we can handle both cases as we do for another type of storage eg ORC.

For the Druid external tables, we can have a default type and allow the user to override that via table properties. 

CC ashutoshc and nishantbangarwa. 

Issue Links

• is blocked by: HIVE-12192 Hive should carry out timestamp computations in UTC
• is blocked by: HIVE-20007 Hive should carry out timestamp computations in UTC
• is part of: HIVE-20213 Upgrade Calcite to 1.17.0