IoTDB source connector
Read external data source data through IoTDB.
supports query SQL and can achieve projection effect.
name | type | required | default value |
---|---|---|---|
host | string | yes | - |
port | Int | yes | - |
node_urls | string | yes | - |
sql | string | yes | |
fields | config | yes | - |
fetch_size | int | no | - |
username | string | no | - |
password | string | no | - |
lower_bound | long | no | - |
upper_bound | long | no | - |
num_partitions | int | no | - |
thrift_default_buffer_size | int | no | - |
enable_cache_leader | boolean | no | - |
version | string | no | - |
host [string] the host of the IoTDB when you select host of the IoTDB
port [int] the port of the IoTDB when you select
node_urls [string] the node_urls of the IoTDB when you select
e.g.
sql [string] execute sql statement e.g.
select name,age from test
the fields of the IoTDB when you select
the field type is SeaTunnel field type org.apache.seatunnel.api.table.type.SqlType
e.g.
fields{ name=STRING age=INT }
the fetch_size of the IoTDB when you select
the username of the IoTDB when you select
the password of the IoTDB when you select
the lower_bound of the IoTDB when you select
the upper_bound of the IoTDB when you select
the num_partitions of the IoTDB when you select
the thrift_default_buffer_size of the IoTDB when you select
enable_cache_leader of the IoTDB when you select
Version represents the SQL semantic version used by the client, which is used to be compatible with the SQL semantics of 0.12 when upgrading 0.13. The possible values are: V_0_12, V_0_13.
we can split the partitions of the IoTDB and we used time column split
split num
upper bound of the time column
lower bound of the time column
split the time range into numPartitions parts if numPartitions is 1, use the whole time range if numPartitions < (upper_bound - lower_bound), use (upper_bound - lower_bound) partitions eg: lower_bound = 1, upper_bound = 10, numPartitions = 2 sql = "select * from test where age > 0 and age < 10" split result split 1: select * from test where (time >= 1 and time < 6) and ( age > 0 and age < 10 ) split 2: select * from test where (time >= 6 and time < 11) and ( age > 0 and age < 10 )