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 JUNE 04, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms


After upgrading from RDBMS and HSODBC 10.2 to RDBMS and DG4ODBC 11.2.0.3 to connect to Netezza the following query now gives the error -

 

select domain_name domain, max(raw_visitors) raw_visitors from ba_domain_tally_AU@nzpro_def a where period_id = 'M20130901'
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms