Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20875

Druid storage handler Kafka ingestion timestamp column name

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      This question brought to my attention that currently the Druid-Hive-Kafka ingestion is assuming that the Kafka Stream has to include a column called __time as timestamp column.
      https://community.hortonworks.com/questions/226191/druid-kafka-ingestion-from-hive-hdp-30.html?childToView=227242#answer-227242

      Looking at the code here seems confirming that https://github.com/apache/hive/blob/a51e6aeaf816bdeea5e91ba3a0fab8a31b3a496d/druid-handler/src/java/org/apache/hadoop/hive/druid/DruidStorageHandler.java#L301.

      IMO this is a serious limitation, because user can not always guarantee that the kafka record always will contain a column called `__time`, we need to introduce a have a way to configure this, maybe via table property.

        Attachments

          Activity

            People

            • Assignee:
              nishantbangarwa Nishant Bangarwa
              Reporter:
              bslim slim bouguerra
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: