I want to show a column with some special charcter in SQL

Question

I need to extract a column[Employee] in DB as "Employee(Emp)" in Hive. Is that possible we can handle in hive.

Select Employee as Employee(Emp) from Emp_Table

But it seems doesnt work as expected

Select Employee as "Employee(Emp)" from Emp_Table Hope, this works — Sergey, Jan 04 '23 at 11:26
@Sergey..It was throwing an error.missing EOF llike that.I am using Hive for my execution — Yes_par_row, Jan 04 '23 at 11:48

score 1 · Accepted Answer · answered Jan 04 '23 at 13:16

1

use backtick (``) to enclose the alias.

Select 'aa' as `Employee(Emp)`

answered Jan 04 '23 at 13:16

Koushik Roy

1 Answers1