Escape Greater Than for Column Name in Athena

Question

I would like to name the output of my columns with "<" greater or less than symbols.

Select worker_name as '<<Worker>>'
from employ

But I am getting

 mismatched input ''<<Worker>>''. Expecting: <identifier>

I have tried escaping with "`" and "ESCAPE" but no luck. Is there and way to do this?

Does this answer your question? [Column name with a Space - Athena](https://stackoverflow.com/questions/54203027/column-name-with-a-space-athena) — Guru Stron, Oct 08 '22 at 07:49
And [this](https://stackoverflow.com/questions/57363073/presto-how-to-select-on-a-table-name-with-special-characters) — Guru Stron, Oct 08 '22 at 07:49

score 0 · Accepted Answer · answered Oct 07 '22 at 18:18

0

Using Double Quotes instead of Single Quotes seems to be the correct way

Select worker_name as "<<Worker>>"
from employ

answered Oct 07 '22 at 18:18

Max

1 Answers1