create_new_tables.sh

# copy pinot table schema and config files to pinot controller
CONTROLLER_CONTAINER=$(docker container ls --filter  name=streaming-stack_pinot-controller.1 --format "{{.ID}}")
cd ~/streaming-sales-generator/apache_pinot_examples
docker cp configs_schemas/ ${CONTROLLER_CONTAINER}:/tmp/

# create three tables
docker exec -it ${CONTROLLER_CONTAINER} \
  bin/pinot-admin.sh AddTable \
    -tableConfigFile /tmp/configs_schemas/purchases-config.json \
    -schemaFile /tmp/configs_schemas/purchases-schema.json -exec

docker exec -it ${CONTROLLER_CONTAINER} \
  bin/pinot-admin.sh AddTable \
    -tableConfigFile /tmp/configs_schemas/products-config.json \
    -schemaFile /tmp/configs_schemas/products-schema.json -exec

docker exec -it ${CONTROLLER_CONTAINER} \
  bin/pinot-admin.sh AddTable \
    -tableConfigFile /tmp/configs_schemas/purchases-enriched-config.json \
    -schemaFile /tmp/configs_schemas/purchases-enriched-schema.json -exec