Query
Certified
Execute a SQL query against Apache Druid
Query
Certified
Execute a SQL query against Apache Druid
yaml
type: io.kestra.plugin.jdbc.druid.QueryExamples
yaml
id: druid_query
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.jdbc.druid.Query
url: jdbc:avatica:remote:url=http://localhost:8888/druid/v2/sql/avatica/;transparent_reconnection=true
sql: |
SELECT *
FROM wikiticker
WHERE __time >= TIMESTAMP '2023-01-01 00:00:00'
fetchType: STORE
Properties
sql *Requiredstring
url *Requiredstring
afterSQL string
fetchSize integerstring
Default
10000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEoutputFiles array
SubTypestring
parameters object
password string
timeZoneId string
username string
Outputs
row object
rows array
SubTypeobject
size integer
uri string
Format
uriMetrics
fetch.size counter
Unit
rows
