How can I apply a function to entire table?

1

Hello everybody!

I’ve started working with Dremio a few days ago and I am actually testing it. My question is: how can I apply a function to entire table? I am reading a Parquet file and it has some columns base64 encrypted so I need to convert it to UTF8. I got success to convert one column to UTF8 (by select the calculated field option and use the CONVERT_FROM function) but not in the entire table.

Thank you.

2

@victor.fuzaro

When you say not entire table, do you mean not all rows. Best is to apply the function and save as a VDS. Once you save as VDS , you have to choose run instead of preview. Then on the UI job screen if you see that results were truncated then use JDBC client