table schema for floating population

CREATE table ltdb_fp (
adm_code string,
x double,
y double,
recordid integer,
block_cd long,
exist_m_00 double,
exist_m_10 double,
exist_m_20 double,
exist_m_30 double,
exist_m_40 double,
exist_m_50 double,
exist_m_60 double,
exist_m_70 double,
exist_m_80 double,
exist_m_90 double,
exist_f_00 double,
exist_f_10 double,
exist_f_20 double,
exist_f_30 double,
exist_f_40 double,
exist_f_50 double,
exist_f_60 double,
exist_f_70 double,
exist_f_80 double,
exist_f_90 double,
home_m_00 double,
home_m_10 double,
home_m_20 double,
home_m_30 double,
home_m_40 double,
home_m_50 double,
home_m_60 double,
home_m_70 double,
home_m_80 double,
home_m_90 double,
home_f_00 double,
home_f_10 double,
home_f_20 double,
home_f_30 double,
home_f_40 double,
home_f_50 double,
home_f_60 double,
home_f_70 double,
home_f_80 double,
home_f_90 double,
work_m_00 double,
work_m_10 double,
work_m_20 double,
work_m_30 double,
work_m_40 double,
work_m_50 double,
work_m_60 double,
work_m_70 double,
work_m_80 double,
work_m_90 double,
work_f_00 double,
work_f_10 double,
work_f_20 double,
work_f_30 double,
work_f_40 double,
work_f_50 double,
work_f_60 double,
work_f_70 double,
work_f_80 double,
work_f_90 double,
in_m_00 double,
in_m_10 double,
in_m_20 double,
in_m_30 double,
in_m_40 double,
in_m_50 double,
in_m_60 double,
in_m_70 double,
in_m_80 double,
in_m_90 double,
in_f_00 double,
in_f_10 double,
in_f_20 double,
in_f_30 double,
in_f_40 double,
in_f_50 double,
in_f_60 double,
in_f_70 double,
in_f_80 double,
in_f_90 double,
geohash string,
geometry string,
event_time string
)
USING r2 OPTIONS
(
table '900',
host 'fbg02',
port '18900',
partitions 'event_time geohash',
mode 'nvkvs',
rowstore 'false',
at_least_one_partition_enabled 'no',
group_query_enabled 'yes',
geometry_type 'point'
)