@mallory_cormier
To cast varbinary to varchar in Presto, you can use the CAST function. Here's an example query that demonstrates how to do this:
1 2 |
SELECT CAST(varbinary_column AS VARCHAR) AS varchar_column FROM your_table; |
Replace varbinary_column with the name of the column that contains the varbinary data in your table, and your_table with the name of your table. This query will convert the varbinary data in the varbinary_column to a varchar data type and alias it as varchar_column.