--! qt:dataset:src
set hive.fetch.task.conversion=more;

DESCRIBE FUNCTION regexp;
DESCRIBE FUNCTION EXTENDED regexp;

SELECT 'fofo' REGEXP '^fo', 'fo\no' REGEXP '^fo\no$', 'Bn' REGEXP '^Ba*n', 'afofo' REGEXP 'fo',
'afofo' REGEXP '^fo', 'Baan' REGEXP '^Ba?n', 'axe' REGEXP 'pi|apa', 'pip' REGEXP '^(pi)*$'
FROM src tablesample (1 rows);