- Let's first try using a simple cat map-side script
SELECT
TRANSFORM(name) USING '/bin/cat' as name
FROM
airports
LIMIT 10
- Now, let's do something more complicated (still as a custom map script)
SELECT
TRANSFORM(name) USING "/bin/sed -e 's/\s//g'" as name
FROM
airports
LIMIT 10