tables-definition.sql

CREATE TABLE orders
(
   order_timestamp TIMESTAMP,
   order_date      STRING,
   id              BIGINT,
   customer_id     BIGINT
) PARTITIONED BY (order_date);

CREATE TABLE products
(
   id            BIGINT,
   name          STRING,
   product_category TINYINT,
   current_prise DECIMAL(15, 2)
);

CREATE TABLE order_items
(
   id         BIGINT,
   order_id   BIGINT,
   product_id BIGINT,
   quantity   BIGINT,
   unit_prise DECIMAL(15, 2)
);