Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Druid/Hive ColumnHow to rename columns to made Hive work with Druid?

Druid/Hive ColumnHow to rename columns to made Hive work with Druid?

New Contributor

Hi!
I'm trying to use druid and hive together. The problem is that all columns must be lowercase, because hive will not query column if any letter in column name will be uppercase.
I read it here:
https://community.hortonworks.com/questions/238873/hivedruid-all-queries-yield-null-columns.html


And now I can't undertend how to rename columns in existing datasource.
I know that I could use firehourse to made exist datasource as input for spec, also I know how actually rename dimensions from here https://support.imply.io/hc/en-us/articles/360005727614-How-to-rename-dimension-during-raw-data-inge...
But my spec doesn't parse floats. Also i have 400gb of data and 1600 intervals. Index task is very slow.
(I don't use hadoop index, i use index task (also i can't use index_parallel because of json firehorse input)).
So very slow spec that renames columns and didn't parse floats:
https://gist.github.com/tvorogme/d139e550720fc2725fbd15adb5785a40
Can anybody help me?
Thanks!