I am curious if there is a way to model the data from Hive tables in Caravel.
Similar to how caravel can connect to a Druid cluster and display a UI on the data in Druid, is there a way to model the data in Hive in Caravel using JDBC?
Asked
Active
Viewed 210 times
1 Answers
0
Yep, take a look into the https://github.com/dropbox/PyHive. You can specify the sql alchemy connection string and connect to the Hive.
Bogdan Kyryliuk
- 1
- 1
-
Can you please elaborate on how I would use this to read data from hive into Druid? – Aug 24 '16 at 17:29
-
Ah, for that your would need to write the export pipeline, that is outside of the caravel scope. – Bogdan Kyryliuk Oct 07 '16 at 17:25
-
Is export pipeline is defined somewhere or is it my custom code to move data from Hive into Druid? – Oct 07 '16 at 21:42