load-data.sql

IMPORT INTO "warehouse" (
  "w_id",
  "w_name",
  "w_street_1",
  "w_street_2",
  "w_city",
  "w_state",
  "w_zip",
  "w_tax",
  "w_ytd"
) CSV DATA (
    'nodelocal://3/data-files/warehouse.csv'
) WITH nullif = 'null'
;

IMPORT INTO "district" (
  "d_w_id",
  "d_id",
  "d_name",
  "d_street_1",
  "d_street_2",
  "d_city",
  "d_state",
  "d_zip",
  "d_tax",
  "d_ytd",
  "d_next_o_id"
) CSV DATA (
    'nodelocal://3/data-files/district.csv'
) WITH nullif = 'null'
;

IMPORT INTO "customer" (
  "c_w_id",
  "c_d_id",
  "c_id",
  "c_first",
  "c_middle",
  "c_last",
  "c_street_1",
  "c_street_2",
  "c_city",
  "c_state",
  "c_zip",
  "c_phone",
  "c_since",
  "c_credit",
  "c_credit_lim",
  "c_discount",
  "c_balance",
  "c_ytd_payment",
  "c_payment_cnt",
  "c_delivery_cnt",
  "c_data"
) CSV DATA (
    'nodelocal://3/data-files/customer.csv'
) WITH nullif = 'null'
;

IMPORT INTO "order" (
  "o_w_id",
  "o_d_id",
  "o_id",
  "o_c_id",
  "o_carrier_id",
  "o_ol_cnt",
  "o_all_local",
  "o_entry_d"
) CSV DATA (
    'nodelocal://3/data-files/order.csv'
) WITH nullif = 'null'
;

IMPORT INTO "item" (
  "i_id",
  "i_name",
  "i_price",
  "i_im_id",
  "i_data"
) CSV DATA (
    'nodelocal://3/data-files/item.csv'
) WITH nullif = 'null'
;

IMPORT INTO "orderline" (
  "ol_w_id",
  "ol_d_id",
  "ol_o_id",
  "ol_number",
  "ol_i_id",
  "ol_delivery_d",
  "ol_amount",
  "ol_supply_w_id",
  "ol_quantity",
  "ol_dist_info"
) CSV DATA (
    'nodelocal://3/data-files/order-line.csv'
) WITH nullif = 'null'
;

IMPORT INTO "stock" (
  "s_w_id",
  "s_i_id",
  "s_quantity",
  "s_ytd",
  "s_order_cnt",
  "s_remote_cnt",
  "s_dist_01",
  "s_dist_02",
  "s_dist_03",
  "s_dist_04",
  "s_dist_05",
  "s_dist_06",
  "s_dist_07",
  "s_dist_08",
  "s_dist_09",
  "s_dist_10",
  "s_data"
) CSV DATA (
    'nodelocal://3/data-files/stock.csv'
) WITH nullif = 'null'
;