期货行情数据gpload并行加载到Greenplum数据库

1
2
3
4
5
6
7
8
9
10
11
12
-- Sequence: hffd.tdb_futureab_seq

-- DROP SEQUENCE hffd.tdb_futureab_seq;

CREATE SEQUENCE hffd.tdb_futureab_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
ALTER TABLE hffd.tdb_futureab_seq
  OWNER TO gpadmin;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
-- Table: hffd.tdb_futureab

-- DROP TABLE hffd.tdb_futureab;

CREATE TABLE hffd.tdb_futureab
(
  id integer NOT NULL DEFAULT nextval('hffd.tdb_futureab_seq'::regclass),
  windcode character(20),
  code character(20),
  date double precision,
  "time" double precision,
  volume double precision,
  turover double precision,
  settle double precision,
  "position" double precision,
  curdelta double precision,
  tradeflag character(50),
  accvolume double precision,
  accturover double precision,
  open double precision,
  high double precision,
  low double precision,
  price double precision,
  askprice double precision,
  askvolume double precision,
  bidprice double precision,
  bidvolume double precision,
  preclose double precision,
  presettle double precision,
  preposition double precision
)
WITH (
  OIDS=FALSE
)
DISTRIBUTED BY (id);
ALTER TABLE hffd.tdb_futureab
  OWNER TO gpadmin;
GRANT ALL ON TABLE hffd.tdb_futureab TO gpadmin;
GRANT SELECT ON TABLE hffd.tdb_futureab TO fitl;