Error - ORA-02070: Database Does Not Support A Group By Clause In This Context - Using Dg4ODBC to Select From Netezza
(Doc ID 1675758.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
After upgrading from RDBMS and HSODBC 10.2 to RDBMS and DG4ODBC 188.8.131.52 to connect to Netezza the following query now gives the error -
and panel_type_id = 100
and raw_visitors >= 40
group by domain_name;
line 1: ORA-02070: database NZPRO_DEF does not support a group by clause in this context
The query ran successfully using HSODBC 10.2.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document