forked from cloudspannerecosystem/memefish
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathalter_locality_group.sql.txt
43 lines (42 loc) · 1001 Bytes
/
alter_locality_group.sql.txt
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
40
41
42
43
--- alter_locality_group.sql
ALTER LOCALITY GROUP `default` SET OPTIONS (storage = 'ssd', ssd_to_hdd_spill_timespan = '10d')
--- AST
&ast.AlterLocalityGroup{
Name: &ast.Ident{
NamePos: 21,
NameEnd: 30,
Name: "default",
},
Options: &ast.Options{
Options: 35,
Rparen: 94,
Records: []*ast.OptionsDef{
&ast.OptionsDef{
Name: &ast.Ident{
NamePos: 44,
NameEnd: 51,
Name: "storage",
},
Value: &ast.StringLiteral{
ValuePos: 54,
ValueEnd: 59,
Value: "ssd",
},
},
&ast.OptionsDef{
Name: &ast.Ident{
NamePos: 61,
NameEnd: 86,
Name: "ssd_to_hdd_spill_timespan",
},
Value: &ast.StringLiteral{
ValuePos: 89,
ValueEnd: 94,
Value: "10d",
},
},
},
},
}
--- SQL
ALTER LOCALITY GROUP `default` SET OPTIONS (storage = "ssd", ssd_to_hdd_spill_timespan = "10d")