Amazon Redshift Bedienungsanleitung PDF herunterladen (Seite 17)

likebroadway boolean,

likemusicals boolean);

create table venue(

venueid smallint not null distkey sortkey,

venuename varchar(100),

venuecity varchar(30),

venuestate char(2),

venueseats integer);

create table category(

catid smallint not null distkey sortkey,

catgroup varchar(10),

catname varchar(10),

catdesc varchar(50));

create table date(

dateid smallint not null distkey sortkey,

caldate date not null,

day character(3) not null,

week smallint not null,

month character(5) not null,

qtr character(5) not null,

year smallint not null,

holiday boolean default('N'));

create table event(

eventid integer not null distkey,

venueid smallint not null,

catid smallint not null,

dateid smallint not null sortkey,

eventname varchar(200),

starttime timestamp);

create table listing(

listid integer not null distkey,

sellerid integer not null,

eventid integer not null,

dateid smallint not null sortkey,

numtickets smallint not null,

priceperticket decimal(8,2),

totalprice decimal(8,2),

listtime timestamp);

create table sales(

salesid integer not null,

listid integer not null distkey,

sellerid integer not null,

buyerid integer not null,

eventid integer not null,

dateid smallint not null sortkey,

qtysold smallint not null,

pricepaid decimal(8,2),

commission decimal(8,2),

saletime timestamp);

2. Copy data from Amazon S3. To optimize performance during bulk loading of large datasets from

Amazon S3 or DynamoDB, we strongly recommend that you use the Amazon Redshift SQL COPY

API Version 2012-12-01

Amazon Redshift Getting Started Guide

Step 5: Load Sample Data from Amazon S3

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 23 24

Kommentare zu diesen Handbüchern

Keine Kommentare

Amazon Redshift Bedienungsanleitung Seite 17

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Amazon Redshift