Does Trino to Spark only support conversion syntax differences? Does it not support conversion of function differences?

Open HelloZZF opened this issue 2 years ago • 2 comments

I tried to convert these two functions, but both resulted in an error message "No match found for function". select regexp_like('a','\d') select date_diff('month',cast('2022-05-23' as date),cast('2022-06-23' as date))

When I try to convert SQL statements with syntax differences, Coral can successfully perform the conversion, for example: SELECT * FROM mydb.mytable AS a CROSS JOIN UNNEST(split(a.id, ',')) AS t0 (b)

May I ask if the conversion of Trino to Spark function differences is not currently supported? I see validator. validate (query) in the code It is verified using the rules of hive, and the unique function in trino will report an error at this step

May 24 '23 02:05 HelloZZF

Yes, Trino to Coral is not fully supported yet and it is work in progress.

May 25 '23 05:05 wmoustafa

Got it，Thank you for your reply.

May 25 '23 07:05 HelloZZF