CREATE TABLE t_station ( id Int64, station_sn String, operator_id Int64, equioment_owner_id String, station_name String, country_code String, region_id Nullable(Int64), region_code String, regional_name Nullable(String), regional_code Nullable(String), address String, station_tel Nullable(String), service_tel String, station_type Int16, station_type_msg Nullable(String), station_business_type Nullable(Int8), station_business_type_msg Nullable(String), station_status Int16, station_status_msg Nullable(String), park_nums Int16, station_lng Float64, station_lat Float64, site_guide Nullable(String), construction Int16, construction_msg Nullable(String), pictures Nullable(String), match_cars Nullable(String), park_info Nullable(String), business_start_time Nullable(Int16), business_end_time Nullable(Int16), electricity_fee Nullable(String), service_fee Nullable(String), is_park_fee Nullable(Int8), park_fee Nullable(String), payment Nullable(Int8), payment_msg Nullable(String), support_order Nullable(Int8), support_order_msg Nullable(String), service_item Nullable(String), service_item_image_url Nullable(String), service_item_msg Nullable(String), station_location_type Nullable(Int8), station_location_type_msg Nullable(String), station_charge_type Nullable(Int8), station_charge_type_msg Nullable(String), station_power Nullable(String), station_voltage Nullable(String), station_current Nullable(String), is_open Nullable(Int8), is_open_msg Nullable(String), is_display Nullable(Int8), is_display_msg Nullable(String), sharing_code Nullable(String), sharing_applet_picture Nullable(String), theme_picture Nullable(String), is_barrier_flag Nullable(Int8), is_barrier_flag_msg Nullable(String), charge_settle_type Nullable(Int8), charge_settle_type_msg Nullable(String), fast_connector_nums Nullable(Int32), slow_connector_nums Nullable(Int32), transformer_capacity Nullable(Float64), installed_capacity Nullable(Float64), remark Nullable(String), record_unique_no String, equipment_owner_name String, supply_type Int8, resident_no String, watt_hour_meter_no String, forward_power String, operation_date DateTime, charge_replace_type Int8, is_hlht Int8, is_subsidy Int8, create_time Nullable(DateTime), update_time Nullable(DateTime), area_code_countryside Nullable(String), business_expand_type Nullable(Int8), capacity Float64, video_monitor Nullable(Int8), electricity_type Nullable(Int8), INDEX station_sn (station_sn) TYPE minmax GRANULARITY 3, INDEX operator_id (operator_id) TYPE minmax GRANULARITY 3, INDEX idx_operator_id (operator_id) TYPE minmax GRANULARITY 3 ) ENGINE = ReplacingMergeTree() ORDER BY (id) SETTINGS index_granularity = 8192;