datetime-string-to-timestamp

Converting DateTime strings to Timestamps

In this recipe we'll learn how to import DateTime strings into Pinot.

Pinot Version	1.0.0
Schema	config/schema.json
Table Config	config/table.json

This is the code for the following recipe: https://dev.startree.ai/docs/pinot/recipes/datetime-string-to-timestamp

---

git clone [email protected]:startreedata/pinot-recipes.git
cd pinot-recipes/recipes/datetime-string-to-timestamp

Spin up a Pinot cluster using Docker Compose:

docker-compose up

Add table and schema:

docker run \
   --network datetime \
   -v $PWD/config:/config \
   apachepinot/pinot:1.0.0 AddTable   \
  -tableConfigFile /config/table.json   \
  -schemaFile /config/schema.json \
  -controllerHost "pinot-controller-datetime" \
  -exec

Import message into Kafka:

printf '{"timestamp1": "2019-10-09 22:25:25", "timestamp2": "1570656325000", "timestamp3": "10/09/2019T22:25:25"}\n' |
kcat -P -b localhost:9092 -t dates

Query Pinot:

select * 
from dates