Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS session_access_staging ;
- CREATE TABLE session_access_staging (
- first_access INT NOT NULL,
- last_access INT NOT NULL,
- content_name VARCHAR(128) NOT NULL,
- client_ip VARCHAR(20) NOT NULL,
- session_id VARCHAR(64) NOT NULL,
- bytes INT NOT NULL
- ) ENGINE=InnoDB;
- LOAD DATA LOCAL INFILE 'simple.in' INTO TABLE session_access_staging FIELDS TERMINATED BY ' ' IGNORE 1 LINES;
- DROP TABLE IF EXISTS content_dim ;
- CREATE TABLE content_dim (
- id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
- content_name VARCHAR(255) NOT NULL,
- account_name VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB;
- LOAD DATA LOCAL INFILE 'account-dim.in' INTO TABLE content_dim FIELDS TERMINATED BY ' ' (content_name, account_name);
- DROP TABLE IF EXISTS prov_fact;
- CREATE TABLE prov_fact (
- content_sk INT NOT NULL,
- bytes INT NOT NULL
- ) ENGINE=InnoDB;
- DROP TABLE IF EXISTS pre_prov_fact ;
- CREATE TABLE pre_prov_fact (
- content_name VARCHAR(128) NOT NULL,
- bytes INT NOT NULL
- ) ENGINE=InnoDB;
- INSERT INTO pre_prov_fact(content_name, bytes)
- SELECT
- session_access_staging.content_name,
- SUM(session_access_staging.bytes)
- FROM
- session_access_staging
- GROUP BY
- session_access_staging.content_name;
- INSERT INTO prov_fact(content_sk, bytes)
- SELECT
- content_dim.id,
- pre_prov_fact.bytes
- FROM
- content_dim,
- pre_prov_fact
- WHERE
- pre_prov_fact.content_name = content_dim.content_name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement