Description

This test is to determine whether or not you can do an aggregation/group by on a field using an ApplyMap in a single step. I.e. Not a second load.

Result

You can


Raw:
Load * Inline [
fieldA, fieldB
one, A
two, A
three, B
];

num_map:
Mapping Load * Inline [
input, output
one, 1
two, 2
three, 3
];

grp:
Load
fieldB,
Max(ApplyMap('num_map',fieldA)) as maxnum,
Min(ApplyMap('num_map',fieldA)) as minnum
Resident
Raw
group by
fieldB;

exit script;

Return