Query
yaml
type: "io.kestra.plugin.jdbc.pinot.query"
Examples
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
fetchType: FETCH
Properties
url *Requiredstring
fetchSize integerstring
Default
10000
fetchType string
Default
NONE
Possible Values
STORE
FETCH
FETCH_ONE
NONE
parameters object
password string
sql string
timeZoneId string
username string
Outputs
row object
rows array
SubType object
size integer
uri string
Format
uri