KNOWLEDGE BASE

Unimplemented Feature Error Using Custom SQL With Oracle


Published: 29 Dec 2017
Last Modified Date: 03 Jan 2018

Issue

When using custom SQL aggregations sent to an Oracle database, an error may be returned:
 
Unimplemented Feature

Environment

  • Tableau Desktop
  • Oracle

Resolution

Use an AS clause for the aggregated field in the custom SQL, such as:
 
SELECT t."Product Name,
max(t."Required_Time") AS "Max Required Time"
FROM ....

Instead of:
 
SELECT t."Product Name,
max(t."Required_Time")
FROM ....

 

Cause

The error occurs when the aggregate field is not aliased with an AS clause. The default rules Tableau uses for naming fields without aliases does not work with aggregated fields in Oracle.
Did this article resolve the issue?