My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [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 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.