DESCRIBE FUNCTION reverse;
DESCRIBE FUNCTION EXTENDED reverse;

CREATE TABLE dest1(len STRING);
EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT reverse(src1.value);
FROM src1 INSERT OVERWRITE TABLE dest1 SELECT reverse(src1.value);
SELECT dest1.* FROM dest1;
DROP TABLE dest1;

-- Test with non-ascii characters
-- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to
-- 0xE993AEE982B5
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1;
SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5;