createtable_stmt | |
temporary_option | |
relation_factor | |
table_element | |
table_option_list | |
opt_partition_option | |
on_commit_option | |
subquery | |
bit_expr | |
partition_option_inner | |
column_partition_option | |
empty | |
normal_relation_factor | |
relation_name | |
column_definition | |
out_of_line_constraint | |
index_using_algorithm | |
index_option | |
table_option_list_space_seperated | |
table_option | EQrelation_name_or_stringTABLET_SIZECOMP_EQINTNUMMAX_USED_PART_IDCOMP_EQINTNUMENABLEROWMOVEMENTDISABLEROWMOVEMENTphysical_attributes_option |
select_no_parens | |
select_with_parens | |
with_select | |
unary_expr | |
column_name | |
subpartition_option | |
compress_option | |
range_partition_element | |
list_partition_element | |
vertical_column_name | |
column_definition_ref | |
data_type | |
visibility_option | |
opt_column_attribute_list | |
column_attribute | |
opt_generated_column_attribute_list | |
generated_column_attribute | |
reference_action | |
locality_name | |
primary_zone_name | |
relation_name_or_string | |
read_only_or_write | |
physical_attributes_option | |
select_clause | |
select_clause_set | |
with_clause | |
simple_expr | |
range_partition_expr | |
list_partition_expr | |
physical_attributes_option_list | |
int_type_i | |
double_type_i | |
number_type_i | |
number_precision | ,signed_int_num)(
)(signed_int_num) |
charset_key | |
charset_name | |
collation_name | |
varchar_type_i | |
now_or_signed_literal | |
cur_timestamp_func | |
storage_option | |
select_with_opt_hint | |
query_expression_option_list | |
projection | |
into_opt | |
no_table_select_with_hierarchical_query | |
table_reference | |
select_with_hierarchical_query | |
set_type | |
select_clause_set_right | |
common_table_expr | |
obj_access_ref | |
expr_const | |
case_expr | |
sql_function | |
cursor_attribute_expr | |
window_function | )OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)COUNT(ALLbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)COUNT(DISTINCTbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT(bit_expr,bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT_SYNOPSIS(bit_expr,bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)APPROX_COUNT_DISTINCT_SYNOPSIS_MERGE(bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)SUM(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)MAX(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)MIN(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)AVG(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LISTAGG(ALLbit_expr,bit_exprSEPARATORSTRING_VALUE)WITHINGROUP(ORDERSIBLINGSBYbit_exprASCDESC,bit_exprASCDESC)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)DENSE_RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)PERCENT_RANK()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)ROW_NUMBER()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)NTILE(bit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)CUME_DIST()OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)FIRST_VALUEwin_fun_first_last_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LAST_VALUEwin_fun_first_last_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LEADwin_fun_lead_lag_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)LAGwin_fun_lead_lag_paramsOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)NTH_VALUE(bit_expr,bit_expr)FROMfirst_or_lastrespect_or_ignoreNULLSOVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window)RATIO_TO_REPORT(ALLDISTINCTUNIQUEbit_expr)OVER(PARTITIONBYbit_expr,bit_exprORDERSIBLINGSBYsort_key,sort_keywin_window) |
range_expr | |
signed_int_num | |
cur_timestamp_func_params | |
signed_literal_params | |
unit_of_size | |
int_or_unlimited | |
hint_option | |