cost_overcommit = true, min_cost = 50000, priority = high, memory_limit = ‘1024MB' ); • CREATE ROLE r1 RESOUCE QUEUE rq; • SELECT * FROM gp_toolkit.gp_resqueue_status; 2017 年象行中国（杭州 站）第一期 内存控制 • virtual WITH ( concurrency=1, cpu_rate_limit=.5, memory_limit=.6, memory_redzone_limit=.7 ); • CREATE ROLE r1 RESOUCE GROUP rg; • SELECT * FROM gp_toolkit.gp_resgroup_status; 2017 年象行中国（杭州 站）第一期 Resource Group

Area = 16,30 17 Funnel Automata Functions SELECT yFunnel(6, ' rule(r1)(require(get(1) = ''index.html'')), rule(r2, r1)(require(get(1) = ''product_info.html''), product_id(get(2)), return(''viewed''))

[DUPLICATE KEY(col1[, col2, ...])] [PROPERTIES("key" = "value")] ROLLUP ( ROLLUP ( r1 (k1, k3, v1, v2), r1 (k1, k3, v1, v2), r2 (k1, v1) r2 (k1, v1) )) properties properties replication_num DISTRIBUTED BY BY HASH HASH((siteid siteid)) BUCKETS BUCKETS 10 10 ROLLUP ROLLUP (( r1 r1((event_day event_day,,siteid siteid)),, r2 r2((event_day event_day,,citycode citycode)) FinishTime: NULL NULL BaseIndexName: tbl1 BaseIndexName: tbl1 RollupIndexName: r1 RollupIndexName: r1 RollupId: RollupId: 11002 11002 TransactionId: TransactionId: 5070

(host)。 每个主机上面启动一个 TiKV 实例： 1. # zone=z1 2. tikv-server --labels zone=z1,rack=r1,host=h1 3. tikv-server --labels zone=z1,rack=r1,host=h2 4. tikv-server --labels zone=z1,rack=r2,host=h1 5. tikv-server --labels zone=z1,rack=r2,host=h2 6. 7. # zone=z2 8. tikv-server --labels zone=z2,rack=r1,host=h1 9. tikv-server --labels zone=z2,rack=r1,host=h2 10. tikv-server --labels zone=z2,rack=r2,host=h1 11. tikv-server --labels zone=z2,rack=r2,host=h2 12. 13. # zone=z3 14. tikv-server --labels zone=z3,rack=r1,host=h1 15. tikv-server --labels zone=z3,rack=r1,host=h2 16. tikv-server --labels zone=z3,rack=r2,host=h1 17. tikv-server --labels

The SIMILAR pattern is formed from three SQL regular expression patterns, R1, R2 and R3. The entire pattern takes the form of R1 || '"' || R2 || '"' || R3, where is the escape double quotes (", e.g. “#"” with escape character ‘ #’). R1 matches the prefix of the string, and R3 the suffix of the string. Both R1 and R3 are optional (they can be empty), but the pattern must the full pattern is equivalent to R1(R2)R3, which must match the entire input string, and the capture group is the substring to be returned.  If any one of R1, R2, or R3 is not a zero-length string

Muster "SIMILAR" wird aus drei Mustern für reguläre SQL-Ausdrücke gebildet, R1, R2 und R3. Das gesamte Muster hat die Form R1 || '"' || R2 || '"' || R3, wobei das in der ESCAPE-Klausel eingeschlossen (", zB “#"” mit Escape-Zeichen ‘ ##+’). R1 entspricht dem Präfix des Strings und R3 dem Suffix des Strings. Sowohl R1 als auch R3 sind optional (sie können leer sein), aber das Muster Muster entspricht R1(R2)R3, das mit der gesamten Eingabezeichenfolge übereinstimmen muss, und die Erfassungsgruppe ist die zurückzugebende Teilzeichenfolge.  Wenn einer von R1, R2 oder R3 keine

config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "30" } - host: 10.63.10.31 config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "31" } - host: 10.63.10.32 config: server config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "34" } - host: 10.63.10.35 config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "35" } - host: 10.63.10.36 657 config: server config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "38" } - host: 10.63.10.39 config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "39" } - host: 10.63.10.40 config: server

config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "30" } - host: 10.63.10.31 config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "31" } - host: 10.63.10.32 config: server config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "34" } - host: 10.63.10.35 config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "35" } - host: 10.63.10.36 config: server config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "38" } - host: 10.63.10.39 config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "39" } - host: 10.63.10.40 config: server

config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "30" } - host: 10.63.10.31 config: server.labels: { zone: "z1", dc: "d1", rack: "r1", host: "31" } - host: 10.63.10.32 config: server config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "34" } - host: 10.63.10.35 config: server.labels: { zone: "z2", dc: "d1", rack: "r1", host: "35" } - host: 10.63.10.36 config: server config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "38" } - host: 10.63.10.39 config: server.labels: { zone: "z3", dc: "d1", rack: "r1", host: "39" } - host: 10.63.10.40 config: server