Input - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

The following statements create the input tables:

CREATE TABLE purchases_table (
  userid VARCHAR,
  purchaseDate TIMESTAMP,
  purchaseId INTEGER,
  itemid INTEGER,
  numitem INTEGER,
  pricePerItem DOUBLE,
  sessionid INTEGER,
  partition key(userid)
);

CREATE TABLE addToCart_table (
  userid VARCHAR,
  addtocartDate TIMESTAMP,
  cartId int, itemid INTEGER,
  numitem INTEGER,
  pricePerItem DOUBLE,
  sessionid INTEGER,
  partition key(userid)
);

CREATE table removeFromCart_table(
  userid VARCHAR,
  removefromcartDate TIMESTAMP,
  cartId INTEGER,
  itemid INTEGER,
  numitem INTEGER,
  pricePerItem DOUBLE,
  sessionid INTEGER,
  partition key(userid)
);

CREATE table ItemViews_table(
  userid VARCHAR,
  viewDate TIMESTAMP,
  pricedisplayPerItem DOUBLE,
  sessionid INTEGER,
  partition key(userid)
);