Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are given a task to create a table named 'employees' from a JDBC connection to a MySQL database. The table should include columns 'id', 'name', and 'salary'. Write the Spark SQL command to achieve this.
A
CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password')
B
CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id', 'name', 'salary')
C
CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id, name, salary')
D
CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id name salary')
