Reading a blob datatype and writing in csv format

I am reading a table and writing the data in csv format.
The table consist of a blob datatype (250K bytes, in binary) , char, number etc.
I am using spark.read to gather the data on the table.
What is the best approach to be able to write the data of the table including the blob.