...
You can use the Hive - Execute Snap to execute arbitrary SQL. This Snap enables you to execute simple DML (SELECT, INSERT, UPDATE, DELETE) type statements. For the comprehensive scripting functionality offered by the various databases, you should use the stored procedure functionality offered by their chosen database in the Stored Procedure Snap.
This Snap works only with single queries.
Note |
---|
You can drop your database when working with queries, so be cautious. |
...
Field Name | Field Type | Description | |||||||||||||
Label*
Default Value: Hive - Execute | String | Specify a unique name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |||||||||||||
Hive Configuration Properties | Use this field set to configure property-value pairs to set for the SQL statement. The values are used in 'set x=y' statements executed immediately before the SQL. | ||||||||||||||
Property Default Value: N/A | String | Specify the name of the configuration property. | |||||||||||||
Value Default Value: N/A | String | Specify the value of the configuration property. | |||||||||||||
SQL Statement* Default Value: N/A | String/Expression | Specify the SQL statement to execute on the server. Document value substitution will be performed on literals starting with $ (such as The Snap does not allow to inject SQL, such as
| |||||||||||||
Query type
Default Value: Auto | Dropdown list/Expression | Select the type of query for your SQL statement (Read or Write). When Auto is selected, the Snap tries to determine the query type automatically. | |||||||||||||
Pass through Default Value: Selected | Checkbox | Select this checkbox if you want the input document to be passed through to the output view under the key 'original'. This property applies only to the Execute Snaps with a SELECT statement. | |||||||||||||
Ignore empty result Default Value: Deselected | Checkbox | Select if you want no document written to the output view when the SELECT operation does not produce any result. If this property is not selected and the Pass through property is selected, the input document will be passed through to the output view. | |||||||||||||
Number of Retries*
Default Value: 0 | Integer | Specify the maximum number of reconnections in case of a connection failure or timeout. | |||||||||||||
Retry Interval (seconds)*
Default Value: 1 | Integer | Specify the time interval in seconds between connection attempts. | |||||||||||||
Default Value: Execute only | Dropdown list |
|
...