Skip to content

Instantly share code, notes, and snippets.

@kbastani

kbastani/pinot-insert.sql

Created September 21, 2022 23:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kbastani/69f49384a1d66c1e049d8988e989b1ff to your computer and use it in GitHub Desktop.
Save kbastani/69f49384a1d66c1e049d8988e989b1ff to your computer and use it in GitHub Desktop.
Download ZIP
Pinot SQL Insert Example
Raw
pinot-insert.sql
INSERT INTO "baseballStats"
FROM FILE 's3://my-bucket/public_data_set/baseballStats/rawdata/'
OPTION(taskName=myTask-s3)
OPTION(input.fs.className=org.apache.pinot.plugin.filesystem.S3PinotFS)
OPTION(input.fs.prop.accessKey=my-key)
OPTION(input.fs.prop.secretKey=my-secret)
OPTION(input.fs.prop.region=us-west-2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment