Support Questions

Find answers, ask questions, and share your expertise

Colum '_' cannot be resolved in Trino

avatar
New Contributor

I'm new to hive trino. I would like to concatenate three text columns with "_" as separator. So I wrote following code

select A.*,B.Name_group,mail_group,Occupation_group,CONCAT_WS("_",mail_group,Occupation_group,Name_group) combined_error from hive.employee.Job A left join hive.employee.Name B on A.Name_id=B.Name_id left join hive.employee.mail C on A.mail_id= C.mail_id left join hive.employee.Occupation D on A.Occupation_id=D.Occupation_id

 

But I got following error message

Colum '_' cannot be resolved. Can you help me to fix the issue

1 REPLY 1

avatar
Super Guru

@TrinoHelp ,

 

Double-quotes in SQL are used to specify column names. Try using single-quotes instead.

 

Cheers,

André

 

--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs up button.