This is a Database Connectior for different database TG.
This option allows you to explicitly define the type of database the node connects to. Depending on the database type the sql dialect, the supported data types and functions such as insert, update and delete as well as the aggregation functions might differ.
The standard option is '<based on database URL>' where the database type is determined automatically based on the first part of the database URL. However some databases such as Hive and Impala share the same url schema but have different SQL dialects as well as offer different functionality e.g. different sets of aggregation functions. For these databases you have to manually select the appropriate type from the list of supported databases.
If your database type is not listed either select the '<based on database URL>' option or the 'default' option, which uses standard sql syntax and basic aggregation functions. The 'default' type is also used if the url is unknown.
You can always verify the database type via the 'Connection' tab of the nodes database out port.
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to firstname.lastname@example.org, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.