CREATE TABLE orders_csv(
order_id LONG,
order_customer_id INTEGER,
order_timestamp TIMESTAMP,
total_item_quantity INTEGER,
order_amount DOUBLE,
order_status STRING
)USING CSV
TABLEPROPERTIES (
header = “false“,
delimiter = “|“
)
LOCATION “dbfs:/user/username/retail/orders-csv“
```_
CREATE TABLE orders_csv(
order_id LONG,
order_customer_id INTEGER,
order_timestamp TIMESTAMP,
total_item_quantity INTEGER,
order_amount DOUBLE,
order_status STRING
)USING CSV
TABLEPROPERTIES (
header = “false“,
delimiter = “|“
)
LOCATION “dbfs:/user/username/retail/orders-csv“
```_
