How to import data into Druid from a csv?

[Konojowara]

What's the simplest way to import data into Druid from a csv file? From the documentation it's not really clear because the approach described there is a bit complex.

[Himanshu]

Hi,

Please see http://druid.io/docs/0.8.0/tutorials/tutorial-loading-batch-data.html which has an example for loading data from a file containing json records.

You can follow same and change the

"parser" -> "parseSpec" -> "format" be "csv" instead of "json" . Please see the docs for csv parsing at http://druid.io/docs/0.8.0/ingestion/index.html#csv-parsespec

For general, batch ingestion docs, see  http://druid.io/docs/0.8.0/ingestion/batch-ingestion.html .

-- Himanshu

PS: For usage queries, pls use druid-users@ forum.

On Wed, Jul 22, 2015 at 10:33 AM, Konojowara <alex.masla...@gmail.com> wrote:

What's the simplest way to import data into Druid from a csv file? From the documentation it's not really clear because the approach described there is a bit complex.

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/d68be550-bbb6-4652-ba2e-2289c3c99ac3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Konojowara]

Are metricsSpec and granularitySpec mandatory?

[Fangjin Yang]

Yes they are. They define the columns that you will aggregate over and your rollup. You may want to read:

http://druid.io/docs/latest/design/index.html