how to load data from MYSQL to Druid.

Hi,

I have installed druid on my Linux machine by following the quickstart tutorial. But the problem is how to load the data from MYSQL into druid database. And how can i get data from druid through java

I Kafka Connect wouldn’t exist, I would write a simple program which would execute a paged SQL statement to extract non-changeing data from MySql and use a Kafa producer to produce data into a Kafka topic.
Depending on the size of data in MySql - the program could be smart enough do execute coordinated parallel queries, etc…

After that, it should be simple to get data in a Druid datasource.

Sinca Kafka Connect exists, I would use it :slight_smile:
http://docs.confluent.io/3.0.0/connect/connect-jdbc/docs/jdbc_connector.html

Davor

Correction: If Kafka Connect wouldn’t exist…
Correction 2: extract non-changing

Duplicated by https://groups.google.com/forum/#!topic/druid-development/UMHxSRdJvY8