xxxxxxxxxx
#create temp view using csv
CREATE OR REPLACE TEMPORARY VIEW temp_table
USING csv
OPTIONS (
path 'path/to/your_file.csv',
header 'true',
inferSchema 'true',
delimiter ','
)
#create table as select
CREATE TABLE your_table AS
SELECT * FROM temp_table
#drop the temp view
DROP VIEW temp_table