Data Source Configuration Properties¶
The configuration properties of a JDBC or an ODBC data source, also called source configuration, specify certain characteristics of the underlying source such as the operations they support.
The Execution Engine uses this information to know which operations are supported by the source, in order to push down to the data source as much processing as possible to optimize response times and minimize traffic through the network.
Note
Usually, users do not need to change these settings since Virtual DataPort automatically uses suitable configurations for most common data sources.
You can define them in the “Source configuration” tab of the data source or by adding them
to the statement CREATE DATASOURCE
.
The table below lists the properties you can configure in the
SOURCECONFIGURATION
clause of the data sources. On the left column, you have the name of each property;
on the right column, the label of this property in the administration tool, in the tab “Source configuration” of the data source.
To find the meaning of a property, go to the section Data Source Configuration Properties of the Administration Guide.
Property Name in SOURCECONFIGURATION Clause |
Property Name in the Administration Tool (Source configuration tab) |
---|---|
ALLOWFORUPDATE |
Allow for UPDATE clause |
ALLOWLITERALASPARAMETER |
Allow literal as parameter |
DELEGATEAGGREGATEFUNCTIONS |
Delegate aggregate functions list |
DELEGATEALLOPERATORS |
Delegate all operators |
DELEGATEANALYTICFUNCTIONSLIST |
Delegate analytic functions list |
DELEGATEARRAYLITERAL |
Delegate array literal |
DELEGATE_BINARY_ORDERBY_COLLATION |
Delegate binary ORDER BY collation |
DELEGATECOMPOUNDFIELDPROJECTION |
Delegate compound field projection |
DELEGATEFETCH |
Delegate FETCH clause |
DELEGATEGROUPBY |
Delegate GROUP BY clause |
DELEGATEHAVING |
Delegate HAVING clause |
DELEGATEINNERJOIN |
Delegate INNER JOIN |
DELEGATEINTERSECTION |
Delegate INTERSECT |
DELEGATEINVALIDNUMBERLITERALSASNULL |
Delegate invalid number literals as NULL |
DELEGATEJOIN |
Delegate JOIN |
DELEGATELEFTFUNCTION |
Delegate left function |
DELEGATELEFTLITERAL |
Delegate left literal |
DELEGATELITERALEXPRESSION |
Delegate literal expression |
DELEGATEMINUS |
Delegate MINUS |
DELEGATEMIXEDAGGREGATEEXPRESSION |
Delegate mixed literal expression |
DELEGATENATURALOUTERJOIN |
Delegate natural OUTER JOIN |
DELEGATENOTCONDITION |
Delegate NOT condition |
DELEGATEOFFSET |
Delegate OFFSET clause |
DELEGATE_OFFSET_RESTRICTION |
Delegate OFFSET clause restriction |
DELEGATEOPERATORSLIST |
Delegate operators list |
DELEGATEORCONDITION |
Delegate OR condition |
DELEGATEORDERBY |
Delegate ORDER BY |
DELEGATE_ORDERBY_COLLATION_MODIFIER |
Delegate ORDER BY collation modifier |
DELEGATEPROJECTION |
Delegate projection |
DELEGATEREGISTERLITERAL |
Delegate register literal |
DELEGATERIGHTFIELD |
Delegate right field |
DELEGATERIGHTFUNCTION |
Delegate right function |
DELEGATERIGHTLITERAL |
Delegate right literal |
DELEGATESCALARFUNCTIONS |
Delegate scalar functions list |
DELEGATESELECTDISTINCT |
Delegate SELECT DISTINCT |
DELEGATESELECTION |
Delegate selection |
DELEGATESUBQUERY |
Delegate subquery |
DELEGATEUNION |
Delegate UNION |
DELEGATEWHERESUBQUERY |
Delegate WHERE subquery |
NESTEDJOINWITHBLOCKSSTRATEGY |
Nested join optimization syntax |
SUPPORTSAGGREGATEFUNCTIONSOPTIONS |
Supports modifier in aggregate function |
SUPPORTSBATCHINSERT |
Supports batch inserts |
SUPPORTSBRANCHOUTERJOIN |
Supports branch OUTER JOIN |
SUPPORTSCLOBINBATCH |
Supports CLOBs in batch inserts |
SUPPORTSEQOUTERJOINOPERATOR |
Supports Eq OUTER JOIN |
SUPPORTSEXPLICITCROSSJOIN |
Supports explicit CROSS JOIN |
SUPPORTSFULLEQOUTERJOIN |
Supports full Eq OUTER JOIN |
SUPPORTSFULLNOTEQOUTERJOIN |
Supports full NotEq OUTER JOIN |
SUPPORTSFUSINGINUSINGANDNATURALJOIN |
Supports fusing in USING and natural JOIN |
SUPPORTSGROUPBYLITERALASPARAMETER |
Supports GROUP BY literals as parameters |
SUPPORTSJOINONCONDITION |
Supports JOIN ON Condition |
SUPPORTSNATURALJOIN |
Supports NATURAL JOIN |
SUPPORTS_ORDERBY_BINARY_COLLATION |
Supports binary ORDER BY collation |
SUPPORTSORDERBYEXPRESSION |
Supports ORDER BY expressions |
SUPPORTSRIGHTDEEPJOIN |
Supports right deep n-joins |
SUPPORTSPREPAREDSTATEMENT |
Supports prepared statements |
SUPPORTSUSINGJOIN |
Supports USING JOIN |
ALTER DATASOURCE JDBC ds_jdbc_athena_prod
SOURCECONFIGURATION (
SUPPORTSORDERBYEXPRESSION = false
, DELEGATENATURALOUTERJOIN = false);