有奖征文:轻量对象存储LighthouseCOS用户实践> HOT
为了保证功能的正常使用和后续扩展,对象存储(Cloud Object Storage,COS)Select 功能制定了以下保留字段,包含函数名称、数据类型、运算符等字段。您在使用 SQL 查询语句时可能使用这些字段辅助您的查询。
序号
字段
序号
字段
序号
字段
序号
字段
序号
字段
1
absolute
51
create
101
goto
151
octet_length
201
struct
2
action
52
cross
102
grant
152
of
202
substring
3
add
53
current
103
group
153
on
203
sum
4
all
54
current_date
104
having
154
only
204
symbol
5
allocate
55
current_time
105
hour
155
open
205
system_user
6
alter
56
current_timestamp
106
identity
156
option
206
table
7
and
57
current_user
107
immediate
157
or
207
temporary
8
any
58
cursor
108
in
158
order
208
then
9
are
59
date
109
indicator
159
outer
209
time
10
as
60
day
110
initially
160
output
210
timestamp
11
asc
61
deallocate
111
inner
161
overlaps
211
timezone_hour
12
assertion
62
dec
112
input
162
pad
212
timezone_minute
13
at
63
decimal
113
insensitive
163
partial
213
to
14
authorization
64
declare
114
insert
164
pivot
214
trailing
15
avg
65
default
115
int
165
position
215
transaction
16
bag
66
deferrable
116
integer
166
precision
216
translate
17
begin
67
deferred
117
intersect
167
prepare
217
translation
18
between
68
delete
118
interval
168
preserve
218
trim
19
bit
69
desc
119
into
169
primary
219
true
20
bit_length
70
describe
120
is
170
prior
220
tuple
21
blob
71
descriptor
121
isolation
171
privileges
221
union
22
bool
72
diagnostics
122
join
172
procedure
222
unique
23
boolean
73
disconnect
123
key
173
public
223
unknown
24
both
74
distinct
124
language
174
read
224
unpivot
25
by
75
domain
125
last
175
real
225
update
26
cascade
76
double
126
leading
176
references
226
upper
27
cascaded
77
drop
127
left
177
relative
227
usage
28
case
78
else
128
level
178
restrict
228
user
29
cast
79
end
129
like
179
revoke
229
using
30
catalog
80
end-exec
130
limit
180
right
230
value
31
char
81
escape
131
list
181
rollback
231
values
32
char_length
82
except
132
local
182
rows
232
varchar
33
character
83
exception
133
lower
183
schema
233
varying
34
character_length
84
exec
134
match
184
scroll
234
view
35
check
85
execute
135
max
185
second
235
when
36
clob
86
exists
136
min
186
section
236
whenever
37
close
87
external
137
minute
187
select
237
where
38
coalesce
88
extract
138
missing
188
session
238
with
39
collate
89
false
139
module
189
session_user
239
work
40
collation
90
fetch
140
month
190
set
240
write
41
column
91
first
141
names
191
sexp
241
year
42
commit
92
float
142
national
192
size
242
zone
43
connect
93
for
143
natural
193
smallint
-
-
44
connection
94
foreign
144
nchar
194
some
-
-
45
constraint
95
found
145
next
195
space
-
-
46
constraints
96
from
146
no
196
sql
-
-
47
continue
97
full
147
not
197
sqlcode
-
-
48
convert
98
get
148
null
198
sqlerror
-
-
49
corresponding
99
global
149
nullif
199
sqlstate
-
-
50
count
100
go
150
numeric
200
string
-
-