Product specifications

YES: the database supports the HAVING clause.
NO: the database does not support the HAVING clause.
Values
NO
Default
13.1.12 INNER_JOIN
<Parameter Name="JOIN">JOIN</Parameter>
Specifies the syntax used to define inner joins between tables in FROM
clauses.
Description
JOIN: the syntax used in queries to HIVE data sources is JOIN.
INNER JOIN: the syntax used in queries to all other data sources is
INNER JOIN.
Values
Related Topics
• Apache Hadoop HIVE connections
13.1.13 INTERSECT
<Parameter Name="INTERSECT">INTERSECT</Parameter>
Specifies the keyword supported by the database for the INTERSECT
set operation.
Description
INTERSECT: the keyword supported by the database is INTERSECT.
No value: the database does not support any keyword for the INTER-
SECT set operation. In this case, two queries are generated.
Values
2012-03-15165
PRM parameter reference