[HIVE-19201] Hive doesn't read Druid data correctly

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 2.3.0
• Component/s: Druid integration, Hive

Environment

Ubuntu 16.4 TLS Desktop
Druid 0.12.0 (StandAlone - Quickstart conf)
Hive 2.3.0 (StandAlone - Quickstart conf)

Also have Hadoop and Zookeeper running

• Assignee: Unassigned
• Reporter: Tournadre
• Due: 17/Apr/18
• Created: 13/Apr/18 08:33
• Updated: 05/Oct/18 22:03

Description

I created an external table on hive pointing at my datasource : wikiticker on druid (I already defined the broker adress). However few colums appear as NULL without knowing why.

I have also many time *.lck file in the metadatadb on Hive and Druid to delete (otherwise, queries don't work)

So the describe statement lists the column and their type correctly, however I only get "NULL" when I query some column (string type). I checked in my Druid, the data are still here.

 

Help !   

PS : Sorry first issue and JIRA, didn't see my issue resolved yet.