Error - ORA-02070: Database Does Not Support A Group By Clause In This Context - Using Dg4ODBC to Select From Netezza
Last updated on JUNE 04, 2014
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.1]
Information in this document applies to any platform.
After upgrading from RDBMS and HSODBC 10.2 to RDBMS and DG4ODBC 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms