Query

Query
Certified
Execute a single SQL query against Actian Vector

yaml
type: io.kestra.plugin.jdbc.actianvector.Query

Examples

yaml
id: actianvector_query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.actianvector.Query
    url: jdbc:vectorwise://url:port/base
    username: "{{ secret('VECTORWISE_USERNAME') }}"
    password: "{{ secret('VECTORWISE_PASSWORD') }}"
    sql: select * from vectorwise_types
    fetchType: FETCH_ONE

Properties

sql *string

url *string

afterSQL string

connectionPoolSize integerstring

Default10

connectionPooling booleanstring

Defaulttrue

fetchSize integerstring

Default10000

fetchType string

DefaultNONE

Possible Values

STOREFETCHFETCH_ONENONE

outputFiles array

SubTypestring

parameters object

password string

pluginDefaultsRef string

timeZoneId string

username string

Outputs

row object

rows array

SubTypeobject

size integer

uri string

Formaturi

Metrics

fetch.size counter

Unitrows

Clickhouse

Tasks that connect to ClickHouse via JDBC to run queries and loads.

Data

Weaviate

Tasks that manage and query vectors in Weaviate.

DataAI

QueryCertifiedExecute a single SQL query against Actian Vector

More Plugins in this Category

Clickhouse

Weaviate

Query
Certified
Execute a single SQL query against Actian Vector