To use CTAS (Create table as Select) in Apache Spark with a specific delimiter using the OPTION syntax:
CREATE TABLE sample_table
USING CSV
OPTIONS ('delimiter'='|')
AS
SELECT ....
PS:
I wrote this to also help myself retrieve the solution faster.
Top comments (0)