Query
Certified
Execute a SQL query against Apache Pinot
Query
Certified
Execute a SQL query against Apache Pinot
yaml
type: io.kestra.plugin.jdbc.pinot.QueryExamples
yaml
id: pinot_query
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.jdbc.pinot.Query
url: jdbc:pinot://localhost:9000
username: "{{ secret('PINOT_USERNAME') }}"
password: "{{ secret('PINOT_PASSWORD') }}"
sql: |
SELECT *
FROM airlineStats
WHERE __time >= 1672531200000 -- 2023-01-01T00:00:00Z in millis
fetchType: FETCH
Properties
sql *Requiredstring
url *Requiredstring
afterSQL string
fetchSize integerstring
Default
10000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEparameters object
password string
timeZoneId string
username string
Outputs
row object
rows array
SubTypeobject
size integer
uri string
Format
uriMetrics
fetch.size counter
Unit
rows
