Ingest Data
./ingest/ingest.sh ingest/lookup-ingest-spec.json
Query Simple Data
$ ./query/query.sh query/query-simple.json
[ {
"timestamp" : "2018-11-01T21:39:00.000Z",
"result" : [ {
"Count" : 3312.0,
"Country Code" : "us"
}, {
"Count" : 428.0,
"Country Code" : "gb"
}, {
"Count" : 310.0,
"Country Code" : "ca"
}, {
"Count" : 180.0,
"Country Code" : "au"
}, {
"Count" : 144.0,
"Country Code" : "es"
}, {
"Count" : 132.0,
"Country Code" : "de"
}, {
"Count" : 124.0,
"Country Code" : "fr"
}, {
"Count" : 88.0,
"Country Code" : "ie"
}, {
"Count" : 54.0,
"Country Code" : "nz"
}, {
"Count" : 36.0,
"Country Code" : "ng"
} ]
} ]
Submit Lookup Spec
-
Initialize
For the first time you’re submitting lookup to Druid coordinator, you may get the following error:
{"error":"Not initialized. If this is the first lookup, post an empty map to initialize"}In that case, you need to submit an empty json to initialize the lookup.
$ curl -H "Content-Type: application/json" --data {} http://localhost:8081/druid/coordinator/v1/lookups/configNow Submit one of the following lookup spec to druid coordinator. Remember to change the file uri in the spec.
-
Simple Json
$ curl -H "Content-Type: application/json" --data @lookup/simple-json-lookup-spec.json http://localhost:8081/druid/coordinator/v1/lookups/config -
Custom Json
$ curl -H "Content-Type: application/json" --data @lookup/custom-json-lookup-spec.json http://localhost:8081/druid/coordinator/v1/lookups/config -
CSV
$ curl -H "Content-Type: application/json" --data @lookup/csv-lookup-spec.json http://localhost:8081/druid/coordinator/v1/lookups/config
-
Check Lookup
$ curl -X GET http://localhost:8082/druid/listen/v1/lookups
Query lookup data
$ ./query/query.sh query/query-lookup.json
[ {
"timestamp" : "2018-11-01T21:39:00.000Z",
"result" : [ {
"Country Name" : "United States",
"Count" : 3312.0
}, {
"Country Name" : "United Kingdom",
"Count" : 428.0
}, {
"Country Name" : "Canada",
"Count" : 310.0
}, {
"Country Name" : "Australia",
"Count" : 180.0
}, {
"Country Name" : "Spain",
"Count" : 144.0
}, {
"Country Name" : "Germany",
"Count" : 132.0
}, {
"Country Name" : "France",
"Count" : 124.0
}, {
"Country Name" : "Ireland",
"Count" : 88.0
}, {
"Country Name" : "New Zealand",
"Count" : 54.0
}, {
"Country Name" : "Nigeria",
"Count" : 36.0
} ]
} ]
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent