Colum '_' cannot be resolved in Trino

TrinoHelp — Wed, 11 May 2022 17:24:29 GMT

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

Re: Colum '_' cannot be resolved in Trino

araujo — Mon, 16 May 2022 22:47:21 GMT

@TrinoHelp ,

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

Cheers,

André

question Re: Colum '_' cannot be resolved in Trino in Support Questions

Colum '_' cannot be resolved in Trino

Re: Colum '_' cannot be resolved in Trino