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

CodePudding user response：

use backtick (``) to enclose the alias.

Select 'aa' as `Employee(Emp)`