You can export it by encapsulating it in the smallest table with 1 row and 1 column.
- Pick the final table and strip it down to a single column that has unique row values
- Filter on one of the unique row values to generate a table with 1 row and 1 column
- Apply a simple map udf such as:
Apply a map operation on the column and use this UDF. Pass the aggregate variable eg. "^avg" as a parameter to this UDF.
This will generate another table with 1 row, 1 column and the aggregate variable value in it. You can then export it.
You can generate similar scenarios, if you had multiple aggregates to export.