...
- Batch Source
- Batch Sink
- Real-time Source
- Real-time Sink
- Action
- Post-Run Action
- Aggregate
- Join
- Spark Model
- Spark Compute
...
| Section | User Facing Name | Widget Type | Description | Constraints |
|---|
| General | Label | textbox |
|
|
| Reference Name | textbox |
| Required |
| Driver Name | textbox |
| Required |
| Host | textbox |
| Required |
| Port | textbox |
| Required |
| Instance | textbox |
| Required |
| Import Query | textarea |
|
|
| Bounding Query | textarea |
|
|
|
|
|
|
|
| Credentials | Username | textbox |
| Required |
| Password | password |
| Required |
|
|
|
|
|
| Advanced | Split-By Field Name | textbox |
|
|
| Number of Splits to Generate | textbox |
|
|
...
| Jethro Data Types | CDAP Schema Data Types |
|---|
| INTEGER | int |
| BIGINT | long |
| FLOAT | float |
| DOUBLE | double |
| STRING | string |
| TIMESTAMP | timestamp-micros |
Action Properties
| Section | User Facing Name | Widget Type | Description | Constraints |
|---|
| Basic | Label | textbox |
|
|
| Driver Name | textbox |
| Required |
| Host | textbox |
| Required |
| Port | textbox |
| Required |
| Instance | textbox |
| Required |
| Database Command | textarea |
| Required |
|
|
|
|
|
| Credentials | Username | textbox |
| Required |
| Password | password |
| Required |
Post-Run Action Properties
| Section | User Facing Name | Widget Type | Description | Constraints |
|---|
| Basic | Label | textbox |
|
|
| Run Condition | select |
| Required |
| Driver Name | textbox |
| Required |
| Host | textbox |
| Required |
| Port | textbox |
| Required |
| Instance | textbox |
| Required |
| Query | textarea |
| Required |
|
|
|
|
|
| Credentials | Username | textbox |
| Required |
| Password | password |
| Required |
Approach
Create a module jethro-plugin in database-plugins project, reuse existing database-plugins code if possible. Add Jethro-specific properties to configuration, add support for Jethro-specific data types. Update UI widgets JSON definitions.
...