setup.ans 722 字节
Newer Older
N
Ning Wu 已提交
1 2 3 4 5 6 7 8
DROP DATABASE IF EXISTS reuse_gptest;
DROP DATABASE
CREATE DATABASE reuse_gptest;
CREATE DATABASE
You are now connected to database "reuse_gptest" as user "gpadmin".
DROP TABLE IF EXISTS texttable;
NOTICE:  table "texttable" does not exist, skipping
DROP TABLE
9 10 11
DROP TABLE IF EXISTS csvtable;
NOTICE:  table "csvtable" does not exist, skipping
DROP TABLE
N
Ning Wu 已提交
12 13 14 15 16
CREATE TABLE texttable (
            s1 text, s2 text, s3 text, dt timestamp,
            n1 smallint, n2 integer, n3 bigint, n4 decimal,
            n5 numeric, n6 real, n7 double precision) DISTRIBUTED BY (n1);
CREATE TABLE
17 18 19 20
CREATE TABLE csvtable (
	    year int, make text, model text, decription text, price decimal)
            DISTRIBUTED BY (year);
CREATE TABLE