Teradata Studio not able to run simple aggregation function.
SELECT department_number AS Dept
Below is the error msg
"Executed as Single statement. Failed [1005 : HY000] Unexpected parcel kind received: 33
This is no simple aggregation, the WITH aggregate syntax returns rows plus intermediate aggregates.
It's only supported in a REPORT run in BTEQ.