Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can a data engineer register the table orders from an existing SQLite database?
orders
A
CREATE TABLE orders USING org.apache.spark.sql.jdbc OPTIONS ( url “jdbc:sqlite:/bookstore.db“, dbtable “orders“ )
B
CREATE TABLE orders USING sqlite OPTIONS ( url “jdbc:sqlite:/bookstore.db“, dbtable “orders“ )
C
CREATE TABLE orders USING cloudfiles OPTIONS ( url “jdbc:sqlite:/bookstore.db“, dbtable “orders“ )
D
CREATE TABLE orders USING EXTERNAL OPTIONS ( url “jdbc:sqlite:/bookstore.db“, dbtable “orders“ )
E
CREATE TABLE ordersUSING DATABASEOPTIONS ( url “jdbc:sqlite:/bookstore.db“, dbtable “orders“ )
