Breaking News: Grepper is joining You.com. Read the official announcement!

create table on spark from csv files

Atharva Jirafe answered on June 21, 2023 Popularity 5/10 Helpfulness 3/10

answer create table on spark from csv files

create table on spark from csv files

Comment

#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

Popularity 5/10 Helpfulness 3/10 Language whatever

Source: Grepper

Tags: create-table csv databricks file whatever

Link to this answer
Share Copy Link

Contributed on Jun 21 2023

Atharva Jirafe

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

create table on spark from csv files

Contents

More Related Answers

create table on spark from csv files

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.