2026-02-11T12:03:31.710671898Z {log_app="webapi",log_type="std",pod_name="webapi-f7b8b8685-ktrcs",pod_namespace="cloud-platform"} info
{"account_email":"zhangsenquan@datafuselabs.com","account_id":2,"elapsed":6014,"latency":"6.014228822s","level":"info","msg":"access-log","query":"","remote_addr":"10.1.160.61","request_body":"{\"prompt\":\"\u003clanguage\u003een-US\u003c/language\u003e\\n\u003ccode\u003eundefined\u003c/code\u003e\\n\u003ccurrent_db\u003edefault\u003c/current_db\u003e\\n\u003csql\u003eSELECT 1;\u003c/sql\u003e\\n\u003cerror\u003estatus: 401, message: {\\\"error\\\":{\\\"code\\\":5100,\\\"message\\\":\\\"key id kms not found in jwk store, url: https://oidc.eks.us-east-2.amazonaws.com/id/120A6F5E89F8F14E7A1E5E15FE48196D/keys\\\\nget key failed, error: Internal. Code: 1001, Text = failed to load JWKS keys, and no available fallback\\\\nCould not download JWKS: error sending request for url (http://webapi.internal.datafusecloud.com/.well-known/jwks.json)., url: http://webapi.internal.datafusecloud.com/.well-known/jwks.json\\\\ncould not decode token from all available jwt key stores. \\\"}}: Authorization failed\u003c/error\u003e\\n\u003ccreate_table_schemas\u003eCREATE TABLE access_logs (\\n timestamp TIMESTAMP NOT NULL,\\n client VARCHAR NOT NULL,\\n method VARCHAR NOT NULL,\\n path VARCHAR NOT NULL,\\n protocol VARCHAR NOT NULL,\\n status INT NOT NULL,\\n size INT NOT NULL,\\n referer VARCHAR NOT NULL,\\n agent VARCHAR NOT NULL,\\n request VARCHAR NOT NULL\\n) \\tCREATE TABLE act_cust_form_detail (\\n id BIGINT NOT NULL COMMENT ' ',\\n page_id BIGINT NULL DEFAULT NULL COMMENT '表单页面id',\\n form_data VARCHAR NULL COMMENT '表单业务数据',\\n process_id VARCHAR NULL DEFAULT NULL COMMENT '流程定义id',\\n process_name VARCHAR NULL DEFAULT NULL COMMENT '流程定义名称',\\n instance_id VARCHAR NULL DEFAULT NULL COMMENT '流程实例id',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户id',\\n user_id BIGINT NULL DEFAULT NULL COMMENT '发起人用户id',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '更新时间',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '更新人',\\n mod_id BIGINT NULL DEFAULT NULL,\\n data_id BIGINT NULL DEFAULT NULL COMMENT '数据id'\\n) \\tCREATE TABLE act_cust_state (\\n state_id BIGINT NOT NULL COMMENT '转换键',\\n state_code VARCHAR NULL DEFAULT NULL COMMENT '编码',\\n state_name VARCHAR NULL DEFAULT NULL COMMENT '名称',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '修改人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户ID'\\n) \\tCREATE TABLE act_hi_varinst (\\n id_ VARCHAR NOT NULL,\\n rev_ INT NULL DEFAULT 1,\\n proc_inst_id_ VARCHAR NULL DEFAULT NULL,\\n execution_id_ VARCHAR NULL DEFAULT NULL,\\n task_id_ VARCHAR NULL DEFAULT NULL,\\n name_ VARCHAR NOT NULL,\\n var_type_ VARCHAR NULL DEFAULT NULL,\\n scope_id_ VARCHAR NULL DEFAULT NULL,\\n sub_scope_id_ VARCHAR NULL DEFAULT NULL,\\n scope_type_ VARCHAR NULL DEFAULT NULL,\\n bytearray_id_ VARCHAR NULL DEFAULT NULL,\\n double_ DOUBLE NULL DEFAULT NULL,\\n long_ BIGINT NULL DEFAULT NULL,\\n text_ VARCHAR NULL DEFAULT NULL,\\n text2_ VARCHAR NULL DEFAULT NULL,\\n create_time_ TIMESTAMP NULL DEFAULT NULL,\\n last_updated_time_ TIMESTAMP NULL DEFAULT NULL\\n) \\tCREATE TABLE array_int64_table (\\n arr ARRAY(BIGINT NOT NULL) NULL\\n) \\tCREATE TABLE array_int64_table1 (\\n arr ARRAY(BOOLEAN NOT NULL) NULL\\n) \\tCREATE TABLE base_dict (\\n dict_id BIGINT NOT NULL COMMENT '字典ID',\\n dict_type INT NULL DEFAULT NULL COMMENT '字典类型 1=系统字典,2=租户字典',\\n dict_code VARCHAR NULL DEFAULT NULL COMMENT '字典编号',\\n dict_name VARCHAR NULL DEFAULT NULL COMMENT '字典名称',\\n parent_dict_id BIGINT NULL DEFAULT NULL COMMENT '父字典id',\\n parent_dict_name VARCHAR NULL DEFAULT NULL COMMENT '父字典名称',\\n whole_dict_id VARCHAR NULL DEFAULT NULL COMMENT '字典全路径',\\n whole_dict_name VARCHAR NULL DEFAULT NULL COMMENT '字典全名称',\\n ext_code VARCHAR NULL DEFAULT NULL COMMENT '外部编码',\\n state INT NULL DEFAULT NULL COMMENT '状态 0=无效，1=有效',\\n logic_state INT NULL DEFAULT NULL COMMENT '逻辑删除 0为已删除 1为未删除',\\n sort INT NULL DEFAULT NULL COMMENT '排序好',\\n remark VARCHAR NULL DEFAULT NULL COMMENT '备注',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '修改人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',\\n tenant_id BIGINT NOT NULL COMMENT '租户ID',\\n memo1 VARCHAR NULL DEFAULT NULL COMMENT '备用1',\\n memo2 VARCHAR NULL DEFAULT NULL COMMENT '备用2',\\n memo3 VARCHAR NULL DEFAULT NULL COMMENT '备用3',\\n pi1 BIGINT NULL DEFAULT NULL COMMENT '层级1id',\\n pi2 BIGINT NULL DEFAULT NULL COMMENT '层级2id',\\n pi3 BIGINT NULL DEFAULT NULL COMMENT '层级3id',\\n pi4 BIGINT NULL DEFAULT NULL COMMENT '层级4id',\\n pi5 BIGINT NULL DEFAULT NULL COMMENT '层级5id',\\n pi6 BIGINT NULL DEFAULT NULL COMMENT '层级6id',\\n pi7 BIGINT NULL DEFAULT NULL COMMENT '层级7id',\\n pi8 BIGINT NULL DEFAULT NULL COMMENT '层级8id',\\n pi9 BIGINT NULL DEFAULT NULL COMMENT '层级9id',\\n pi10 BIGINT NULL DEFAULT NULL COMMENT '层级10id',\\n tenant_data_id VARCHAR NULL DEFAULT NULL COMMENT '客户数据ID',\\n level_code INT NULL DEFAULT NULL COMMENT '层级',\\n dict_alias VARCHAR NULL DEFAULT NULL COMMENT '字典别称',\\n img_url VARCHAR NULL DEFAULT NULL COMMENT '示例图片地址'\\n) \\tCREATE TABLE base_user (\\n user_id BIGINT NOT NULL COMMENT '用户id',\\n emp_id BIGINT NULL DEFAULT NULL COMMENT '员工id',\\n user_account VARCHAR NULL DEFAULT NULL COMMENT '用户账号',\\n user_pwd VARCHAR NULL DEFAULT NULL COMMENT '用户密码',\\n pwd_modify_time TIMESTAMP NULL DEFAULT NULL COMMENT '密码修改时间',\\n user_type BIGINT NULL DEFAULT NULL COMMENT '用户类型',\\n org_ids VARCHAR NULL COMMENT '用户所属组织',\\n duty_ids VARCHAR NULL COMMENT '用户职务',\\n duty_names VARCHAR NULL COMMENT '用户职务名称',\\n role_ids VARCHAR NULL COMMENT '用户拥有的角色',\\n state INT NULL DEFAULT NULL COMMENT '状态 0=无效，1=有效',\\n logic_state INT NULL DEFAULT NULL COMMENT '逻辑删除状态',\\n head_image_id VARCHAR NULL DEFAULT NULL COMMENT '用户头像ID',\\n is_data_auth INT NULL DEFAULT 0 COMMENT '用户数据权限类型 是否自定义数据权限 0=否，1=是',\\n org_auth_type INT NULL DEFAULT NULL COMMENT '组织权限类型：0=组织含下级；1=组织不含下级',\\n mobile_phone VARCHAR NULL DEFAULT NULL COMMENT '手机号',\\n email VARCHAR NULL DEFAULT NULL COMMENT '邮箱(okta邮箱)',\\n emp_name VARCHAR NULL DEFAULT NULL COMMENT '员工姓名',\\n emp_code VARCHAR NULL DEFAULT NULL COMMENT '员工编号',\\n emp_name_en VARCHAR NULL DEFAULT NULL COMMENT '员工英文名',\\n pinyin_full VARCHAR NULL DEFAULT NULL COMMENT '员姓名全拼',\\n pinyin_short VARCHAR NULL DEFAULT NULL COMMENT '员工姓名简拼',\\n custom_ui VARCHAR NULL DEFAULT NULL COMMENT '用户ui',\\n salt VARCHAR NULL DEFAULT NULL COMMENT '加密盐值',\\n sort INT NULL DEFAULT NULL COMMENT '序号',\\n remark VARCHAR NULL DEFAULT NULL COMMENT '备注',\\n dist_id BIGINT NULL DEFAULT NULL COMMENT '经销商id',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '更新人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '更新时间',\\n store_id BIGINT NULL DEFAULT NULL COMMENT '门店id',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户id',\\n is_encrypt INT NULL DEFAULT 0 COMMENT '是否字段已加密 0=未加密，1=已加密',\\n is_changed INT NULL DEFAULT NULL COMMENT '初始密码是否修改 0=未修改，1=已修改',\\n memo1 VARCHAR NULL DEFAULT NULL COMMENT '备用1',\\n memo2 VARCHAR NULL DEFAULT NULL COMMENT '备用2',\\n memo3 VARCHAR NULL DEFAULT NULL COMMENT '备用3',\\n memo4 VARCHAR NULL DEFAULT NULL COMMENT '备用4',\\n tenant_data_id VARCHAR NULL DEFAULT NULL COMMENT '客户数据ID',\\n dept_id BIGINT NULL DEFAULT NULL COMMENT '部门id',\\n ext_code VARCHAR NULL DEFAULT NULL COMMENT '外部编码',\\n emp_type_id BIGINT NULL DEFAULT NULL COMMENT '人员类型id',\\n geo_id BIGINT NULL DEFAULT NULL COMMENT '区域',\\n parent_user_id BIGINT NULL DEFAULT NULL COMMENT '上级用户id',\\n lat VARCHAR NULL DEFAULT NULL COMMENT '纬度',\\n lon VARCHAR NULL DEFAULT NULL COMMENT '经度',\\n is_test_user INT NULL DEFAULT 0 COMMENT '是否测试用户 0=否，1=是',\\n main_department VARCHAR NULL DEFAULT NULL COMMENT '主叶部门根节点',\\n nick_name VARCHAR NULL DEFAULT NULL COMMENT '用户名称',\\n frozen INT NULL DEFAULT NULL COMMENT '是否冻结 0=未冻结 1=冻结',\\n open_id VARCHAR NULL DEFAULT NULL COMMENT '用户微信openID',\\n is_copy INT NULL DEFAULT 0 COMMENT '是否copy 0=否，1=是',\\n channel_id BIGINT NULL DEFAULT NULL COMMENT '渠道ID',\\n parent_user_code VARCHAR NULL DEFAULT NULL COMMENT '上级人员编码',\\n dict_id BIGINT NULL DEFAULT NULL COMMENT '用户岗位ID（字典项）'\\n) \\tCREATE TABLE base_user_org (\\n user_id BIGINT NOT NULL COMMENT '用户ID',\\n org_id BIGINT NOT NULL COMMENT '组织ID',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户ID'\\n) \\tCREATE TABLE base_user_store (\\n id BIGINT NOT NULL COMMENT '主键id',\\n user_id BIGINT NULL DEFAULT NULL COMMENT '用户ID',\\n store_id BIGINT NULL DEFAULT NULL COMMENT '门店ID',\\n principal_id BIGINT NULL DEFAULT NULL COMMENT '负责人id',\\n last_visit_time DATE NULL DEFAULT NULL COMMENT '最后到访时间',\\n last_visit_img VARCHAR NULL DEFAULT NULL COMMENT '最后到访门头照',\\n last_visit_user_id BIGINT NULL DEFAULT NULL COMMENT '最后到访人ID',\\n last_co_visit_time TIMESTAMP NULL DEFAULT NULL COMMENT '最后协防时间 ',\\n last_co_visit_img VARCHAR NULL DEFAULT NULL COMMENT '最后协防门头照',\\n last_co_visit_user_id BIGINT NULL DEFAULT NULL COMMENT '协防人ID(领导) ',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '修改人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户ID',\\n dist_org_id BIGINT NULL DEFAULT NULL COMMENT '经销商组织id',\\n org_id BIGINT NULL DEFAULT NULL COMMENT '组织id',\\n last_order_time TIMESTAMP NULL DEFAULT NULL COMMENT '最后下单时间',\\n visit_update_coordinate_count INT NULL DEFAULT NULL COMMENT '坐标更新次数',\\n is_mdm_sync SMALLINT NULL DEFAULT 0 COMMENT '是否mdm同步1 是 0否',\\n type_id BIGINT NULL DEFAULT NULL COMMENT '门店和经销商的typeId'\\n) \\tCREATE TABLE bend_products (\\n id INT NOT NULL,\\n name VARCHAR NOT NULL,\\n description VARCHAR NOT NULL\\n) \\tCREATE TABLE books (\\n \\\"Title\\\" VARCHAR NULL,\\n \\\"Author\\\" VARCHAR NULL,\\n \\\"Genre\\\" VARCHAR NULL,\\n \\\"Height\\\" VARCHAR NULL,\\n \\\"Publisher\\\" VARCHAR NULL\\n) \\tCREATE TABLE books_0901 (\\n title VARCHAR NOT NULL,\\n author VARCHAR NOT NULL,\\n date VARCHAR NOT NULL\\n) \\tCREATE TABLE books_3937 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE books_6633 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE books_8727 (\\n a VARCHAR NULL,\\n b VARCHAR NULL\\n) \\tCREATE TABLE books_8763 (\\n title VARCHAR NULL,\\n date VARCHAR NULL,\\n author VARCHAR NULL\\n) \\tCREATE TABLE brazil_election_boletim_urna_2022_5975 (\\n municipio INT NOT NULL,\\n zona INT NOT NULL,\\n local INT NOT NULL,\\n secao INT NOT NULL,\\n qtd_eleitores_biometrico INT NOT NULL,\\n qtd_eleitores_codigo INT NOT NULL,\\n id_eleicao INT NOT NULL,\\n qtd_eleitores_aptos INT NOT NULL,\\n tipo_cargo VARCHAR NOT NULL,\\n codigo_cargo VARCHAR NOT NULL,\\n qtd_comparecimento INT NOT NULL,\\n tipo_voto VARCHAR NOT NULL,\\n qtd_votos INT NOT NULL,\\n partido VARCHAR NOT NULL,\\n codigo_candidato VARCHAR NOT NULL,\\n identificacao_votavel VARCHAR NOT NULL\\n) \\tCREATE TABLE cell_towers_1241 (\\n radio VARCHAR NULL,\\n mcc SMALLINT NULL,\\n net SMALLINT NULL,\\n area VARCHAR NULL,\\n cell BIGINT NULL,\\n unit SMALLINT NULL,\\n lon DOUBLE NULL,\\n lat DOUBLE NULL,\\n range INT NULL,\\n samples INT NULL,\\n changeable TINYINT NULL,\\n created BIGINT NULL,\\n updated BIGINT NULL,\\n averagesignal TINYINT NULL\\n) \\tCREATE TABLE cell_towers_3732 (\\n radio VARCHAR NOT NULL,\\n mcc SMALLINT NOT NULL,\\n net SMALLINT NOT NULL,\\n area VARCHAR NOT NULL,\\n cell BIGINT NOT NULL,\\n unit SMALLINT NOT NULL,\\n lon DOUBLE NOT NULL,\\n lat DOUBLE NOT NULL,\\n range INT NOT NULL,\\n samples INT NOT NULL,\\n changeable TINYINT NOT NULL,\\n created BIGINT NOT NULL,\\n updated BIGINT NOT NULL,\\n averagesignal TINYINT NOT NULL\\n) \\tCREATE TABLE cell_towers_4411 (\\n radio VARCHAR NOT NULL,\\n mcc SMALLINT NOT NULL,\\n net SMALLINT NOT NULL,\\n area VARCHAR NOT NULL,\\n cell BIGINT NOT NULL,\\n unit SMALLINT NOT NULL,\\n lon DOUBLE NOT NULL,\\n lat DOUBLE NOT NULL,\\n range INT NOT NULL,\\n samples INT NOT NULL,\\n changeable TINYINT NOT NULL,\\n created BIGINT NOT NULL,\\n updated BIGINT NOT NULL,\\n averagesignal TINYINT NOT NULL\\n) \\tCREATE TABLE cell_towers_7889 (\\n aa VARCHAR NULL\\n) \\tCREATE TABLE cell_towers_8367 (\\n radio VARCHAR NULL,\\n mcc SMALLINT NULL,\\n net SMALLINT NULL,\\n area VARCHAR NULL,\\n cell BIGINT NULL,\\n unit SMALLINT NULL,\\n lon DOUBLE NULL,\\n lat DOUBLE NULL,\\n range INT NULL,\\n samples INT NULL,\\n changeable TINYINT NULL,\\n created BIGINT NULL,\\n updated BIGINT NULL,\\n averagesignal TINYINT NULL\\n) \\tCREATE TABLE complex_json_demo (\\n id INT NULL,\\n config VARIANT NULL\\n) \\tCREATE TABLE copy_into (\\n i INT NULL,\\n a VARIANT NULL,\\n b VARCHAR NULL\\n) \\tCREATE TABLE covid_19_us_2022_0645 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_1065 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_1886 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_1896 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_2333 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_2635 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_2715 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_4840 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_4840444 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_5458 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_6033 (\\n date DATE NULL,\\n country VARCHAR NULL,\\n state VARCHAR NULL,\\n flip VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_6488 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_7200 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_8533 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_8881 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE covid_19_us_2022_8896 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_8958 (\\n date DATE NULL,\\n country VARCHAR NULL,\\n state VARCHAR NULL,\\n flip VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_9250 (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE covid_19_us_2022_9808 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NULL, OPENSSL_VERSION VARCHAR NULL, SETUPTOOLS_VERSION VARCHAR NULL, RUSTC_VERSION VARCHAR NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE covid_19_us_2022_fffff (\\n date DATE NULL,\\n county VARCHAR NULL,\\n state VARCHAR NULL,\\n fips VARCHAR NULL,\\n cases INT NULL,\\n deaths INT NULL\\n) \\tCREATE TABLE customers (\\n customer_id INT UNSIGNED NOT NULL,\\n customer_name VARCHAR NOT NULL,\\n segment VARCHAR NOT NULL,\\n create_timestamp DATE NOT NULL,\\n active BOOLEAN NOT NULL\\n) \\tCREATE TABLE databend_repo_logs (\\n date VARCHAR NOT NULL,\\n time VARCHAR NOT NULL,\\n \\\"x-edge-location\\\" VARCHAR NOT NULL,\\n \\\"sc-bytes\\\" VARCHAR NOT NULL,\\n \\\"c-ip\\\" VARCHAR NOT NULL,\\n \\\"cs-method\\\" VARCHAR NOT NULL,\\n \\\"cs(Host)\\\" VARCHAR NOT NULL,\\n \\\"cs-uri-stem\\\" VARCHAR NOT NULL,\\n \\\"sc-status\\\" VARCHAR NOT NULL,\\n \\\"cs(Referer)\\\" VARCHAR NOT NULL,\\n \\\"cs(User-Agent)\\\" VARCHAR NOT NULL,\\n \\\"cs-uri-query\\\" VARCHAR NOT NULL,\\n \\\"cs(Cookie)\\\" VARCHAR NOT NULL,\\n \\\"x-edge-result-type\\\" VARCHAR NOT NULL,\\n \\\"x-edge-request-id\\\" VARCHAR NOT NULL,\\n \\\"x-host-header\\\" VARCHAR NOT NULL,\\n \\\"cs-protocol\\\" VARCHAR NOT NULL,\\n \\\"cs-bytes\\\" VARCHAR NOT NULL,\\n \\\"time-taken\\\" VARCHAR NOT NULL,\\n \\\"x-forwarded-for\\\" VARCHAR NOT NULL,\\n \\\"ssl-protocol\\\" VARCHAR NOT NULL,\\n \\\"ssl-cipher\\\" VARCHAR NOT NULL,\\n \\\"x-edge-response-result-type\\\" VARCHAR NOT NULL,\\n \\\"cs-protocol-version\\\" VARCHAR NOT NULL,\\n \\\"fle-status\\\" VARCHAR NOT NULL,\\n \\\"fle-encrypted-fields\\\" VARCHAR NOT NULL,\\n \\\"c-port\\\" VARCHAR NOT NULL,\\n \\\"time-to-first-byte\\\" VARCHAR NOT NULL,\\n \\\"x-edge-detailed-result-type\\\" VARCHAR NOT NULL,\\n \\\"sc-contSUBSTRent-type\\\" VARCHAR NOT NULL,\\n \\\"sc-content-len\\\" VARCHAR NOT NULL,\\n \\\"sc-range-start\\\" VARCHAR NOT NULL,\\n \\\"sc-rSUBSTRange-end\\\" VARCHAR NOT NULL\\n) \\tCREATE TABLE date_conversion_final (\\n id INT NULL,\\n original_date VARCHAR NULL,\\n formatted_date_string VARCHAR NULL,\\n standard_date DATE NULL\\n) \\tCREATE TABLE date_conversion_test (\\n id INT NULL,\\n date_string VARCHAR NULL,\\n converted_date DATE NULL\\n) \\tCREATE TABLE date_dim (\\n date_key DATE NOT NULL,\\n day_of_week TINYINT UNSIGNED NOT NULL,\\n month TINYINT UNSIGNED NOT NULL,\\n year SMALLINT UNSIGNED NOT NULL\\n) \\tCREATE TABLE date_format_test (\\n id INT NULL,\\n date_string VARCHAR NULL\\n) \\tCREATE TABLE day_users (\\n day DATE NULL,\\n users BITMAP NULL\\n) \\tCREATE TABLE ddddd (\\n acd DECIMAL(32, 0) NULL\\n) \\tCREATE TABLE ddddd3 (\\n acd DECIMAL(34, 10) NULL\\n) \\tCREATE TABLE ddddd4 (\\n acd VARCHAR NULL\\n) \\tCREATE TABLE demo (\\n no VARCHAR NULL,\\n name VARCHAR NULL,\\n date VARCHAR NULL,\\n ss VARCHAR NULL\\n) \\tCREATE TABLE dim_task_trigger_config (\\n task_name VARCHAR NULL,\\n database_name VARCHAR NULL,\\n table_name VARCHAR NULL,\\n is_active BOOLEAN NULL\\n) \\tCREATE TABLE distribution_check_balance (\\n id BIGINT NOT NULL COMMENT '主键',\\n biz_month VARCHAR NULL DEFAULT NULL COMMENT '月份（财月）',\\n mod_code VARCHAR NULL DEFAULT NULL COMMENT '模块编码 湾仔：M1138 哈根：M1140',\\n store_id BIGINT NULL DEFAULT NULL COMMENT '门店Id',\\n prod_id BIGINT NULL DEFAULT NULL COMMENT '产品Id',\\n freezer_type BIGINT NULL DEFAULT NULL COMMENT '冰柜类型',\\n freezer_display_type SMALLINT NULL DEFAULT NULL COMMENT '冰柜陈列类型 1 自有冰柜 2客户冰柜',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '更新人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '更新时间',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户id',\\n facing_number DECIMAL(16, 0) NULL DEFAULT NULL COMMENT '排面数',\\n prod_number INT NULL DEFAULT NULL COMMENT '产品数',\\n owner_id BIGINT NULL DEFAULT NULL COMMENT '所属人Id',\\n is_target INT NULL DEFAULT NULL COMMENT '是否目标',\\n rule_id BIGINT NULL DEFAULT NULL COMMENT '规则Id',\\n rule_freezer_type BIGINT NULL DEFAULT NULL COMMENT '规则冰柜类型',\\n prod_group BIGINT NULL DEFAULT NULL COMMENT '产品组',\\n prod_group_distribute_num INT NULL DEFAULT NULL COMMENT '产品组分销数',\\n prod_type_id BIGINT NULL DEFAULT NULL COMMENT '产品品类ID',\\n channel_one_id BIGINT NULL DEFAULT NULL COMMENT '门店渠道Id',\\n channel_one_code VARCHAR NULL DEFAULT NULL COMMENT '门店渠道编码',\\n cover_type_id BIGINT NULL DEFAULT NULL COMMENT '覆盖类型Id',\\n cover_type_code VARCHAR NULL DEFAULT NULL COMMENT '覆盖类型编码',\\n prod_barcode VARCHAR NULL DEFAULT NULL COMMENT '产品条码',\\n need_visit INT NULL DEFAULT NULL COMMENT '是否需要拜访'\\n) \\tCREATE TABLE dwd_log_event_fault_with_boot_ice_di (\\n vehicle_id VARCHAR NOT NULL,\\n soft_version VARCHAR NOT NULL,\\n soc_index VARCHAR NOT NULL,\\n boot_count VARCHAR NOT NULL,\\n boot_start_time TIMESTAMP NOT NULL,\\n boot_end_time TIMESTAMP NOT NULL,\\n boot_duration DOUBLE NOT NULL,\\n fault_code VARCHAR NOT NULL,\\n fault_name VARCHAR NOT NULL,\\n fault_insight VARCHAR NOT NULL,\\n fault_module VARCHAR NOT NULL,\\n fault_submodule VARCHAR NOT NULL,\\n fault_category VARCHAR NOT NULL,\\n fault_start_time TIMESTAMP NOT NULL,\\n fault_end_time TIMESTAMP NOT NULL,\\n fault_has_start_time BOOLEAN NOT NULL,\\n fault_has_recovered BOOLEAN NOT NULL,\\n fault_start_ts BIGINT NOT NULL,\\n fault_end_ts BIGINT NOT NULL,\\n fault_durtaion DOUBLE NOT NULL,\\n fault_start_mileage DOUBLE NOT NULL,\\n fault_end_mileage DOUBLE NOT NULL,\\n fault_delta_mileage DOUBLE NOT NULL,\\n boot_start_to_fault DOUBLE NOT NULL,\\n fault_to_boot_end DOUBLE NOT NULL,\\n vehspdkph DOUBLE NOT NULL,\\n taugapset INT NOT NULL,\\n commit VARCHAR NOT NULL,\\n baseline VARCHAR NOT NULL,\\n file_key VARCHAR NOT NULL,\\n fw_version VARCHAR NOT NULL,\\n model_type VARCHAR NOT NULL,\\n vehicle_uuid VARCHAR NOT NULL,\\n fault_start_vehstate VARCHAR NOT NULL,\\n mcu1_hw_part_number VARCHAR NOT NULL,\\n soc1_board_version VARCHAR NOT NULL,\\n soc1_build_date DATE NOT NULL,\\n uuid VARCHAR NOT NULL,\\n pt VARCHAR NULL\\n) \\tCREATE TABLE employees (\\n id INT NOT NULL,\\n name VARCHAR NOT NULL,\\n age INT NOT NULL,\\n salary INT NOT NULL\\n) \\tCREATE TABLE events (\\n user_id INT NOT NULL,\\n login_date DATE NOT NULL\\n) \\tCREATE TABLE events1 (\\n user_id INT NULL,\\n login_date DATE NULL\\n) \\tCREATE TABLE example_table (\\n a VARCHAR NULL\\n) \\tCREATE TABLE fact_avia_creative_detail (\\n creative_name VARCHAR NULL,\\n creative_type VARCHAR NULL,\\n new_creative_name VARCHAR NULL,\\n customize_creative_name VARCHAR NULL,\\n campaign_id VARCHAR NULL,\\n campaign_name VARCHAR NULL,\\n adset_id VARCHAR NULL,\\n adset_name VARCHAR NULL,\\n put_market_form VARCHAR NULL,\\n source_url VARCHAR NULL,\\n os VARCHAR NULL,\\n creator VARCHAR NULL,\\n original_producer VARCHAR NULL,\\n producer VARCHAR NULL,\\n main_producer VARCHAR NULL,\\n film_location VARCHAR NULL,\\n grade VARCHAR NULL,\\n weight VARCHAR NULL,\\n app_name VARCHAR NULL,\\n short_app_name VARCHAR NULL,\\n media_source VARCHAR NULL,\\n short_media_source VARCHAR NULL,\\n country VARCHAR NULL,\\n creative_size VARCHAR NULL,\\n source_group VARCHAR NULL,\\n new_sub_set VARCHAR NULL,\\n set_category VARCHAR NULL,\\n new_created_at DATE NULL,\\n install_date DATE NULL,\\n impressions FLOAT NULL,\\n clicks FLOAT NULL,\\n cost FLOAT NULL,\\n c_bi_install FLOAT NULL,\\n c_d0_payer FLOAT NULL,\\n c_d6_payer FLOAT NULL,\\n c_d0_iaa_revenue FLOAT NULL,\\n c_d0_revenue FLOAT NULL,\\n c_d2_iaa_revenue FLOAT NULL,\\n c_d2_revenue FLOAT NULL,\\n c_d6_iaa_revenue FLOAT NULL,\\n c_d6_revenue FLOAT NULL,\\n c_d1_retained FLOAT NULL,\\n man_hour FLOAT NULL,\\n creative_start_date DATE NULL,\\n creative_end_date DATE NULL,\\n creative_install_duration BIGINT NULL,\\n anchor_nth_month BIGINT NULL,\\n customize_creative_id BIGINT NULL,\\n image_url VARCHAR NULL,\\n game_type VARCHAR NULL,\\n source_flag VARCHAR NULL,\\n media VARCHAR NULL\\n) \\tCREATE TABLE fact_creative_tag_relation_v1 (\\n material_name VARCHAR NULL,\\n max_cost_source_url VARCHAR NULL,\\n set_category VARCHAR NULL,\\n customize_creative_start_date DATE NULL,\\n customize_creative_end_date DATE NULL,\\n tag_category VARCHAR NULL,\\n tag_list ARRAY(VARCHAR NOT NULL) NULL,\\n created_at TIMESTAMP NULL,\\n updated_at TIMESTAMP NULL\\n) \\tCREATE TABLE fact_employ_v1_amp_ug_prod (\\n id BIGINT NULL,\\n created_at TIMESTAMP NULL,\\n updated_at TIMESTAMP NULL,\\n valid BIGINT NULL,\\n del_version BIGINT NULL,\\n creator VARCHAR NULL,\\n modifier VARCHAR NULL,\\n employ_role VARCHAR NULL,\\n employ_name VARCHAR NULL,\\n employ_short_name VARCHAR NULL,\\n employ_email VARCHAR NULL,\\n employ_team VARCHAR NULL,\\n employ_country VARCHAR NULL,\\n employ_en_name VARCHAR NULL\\n) \\tCREATE TABLE geo_data (\\n latitude DOUBLE NULL,\\n longitude DOUBLE NULL,\\n area_in_meters DOUBLE NULL,\\n confidence DOUBLE NULL,\\n geometry GEOMETRY NULL,\\n full_plus_code VARCHAR NULL\\n) \\tCREATE TABLE guance_logs (\\n trace_id VARCHAR NOT NULL,\\n __doc_id VARCHAR NOT NULL,\\n __namespace VARCHAR NOT NULL,\\n date_ns INT NOT NULL,\\n duration INT NOT NULL,\\n parent_id VARCHAR NOT NULL,\\n priority INT NOT NULL,\\n service VARCHAR NOT NULL,\\n create_time BIGINT NOT NULL,\\n resource VARCHAR NOT NULL,\\n span_id VARCHAR NOT NULL,\\n host VARCHAR NOT NULL,\\n host_ip VARCHAR NOT NULL,\\n operation VARCHAR NOT NULL,\\n project VARCHAR NOT NULL,\\n runtime_id VARCHAR NOT NULL,\\n span_type VARCHAR NOT NULL,\\n service_sub VARCHAR NOT NULL,\\n time BIGINT NOT NULL,\\n message VARCHAR NOT NULL,\\n source VARCHAR NOT NULL,\\n source_type VARCHAR NOT NULL,\\n start BIGINT NOT NULL,\\n status VARCHAR NOT NULL\\n) \\tCREATE TABLE hits (\\n watchid BIGINT NOT NULL,\\n javaenable SMALLINT NOT NULL,\\n title VARCHAR NOT NULL,\\n goodevent SMALLINT NOT NULL,\\n eventtime TIMESTAMP NOT NULL,\\n eventdate DATE NOT NULL,\\n counterid INT NOT NULL,\\n clientip INT NOT NULL,\\n regionid INT NOT NULL,\\n userid BIGINT NOT NULL,\\n counterclass SMALLINT NOT NULL,\\n os SMALLINT NOT NULL,\\n useragent SMALLINT NOT NULL,\\n url VARCHAR NOT NULL,\\n referer VARCHAR NOT NULL,\\n isrefresh SMALLINT NOT NULL,\\n referercategoryid SMALLINT NOT NULL,\\n refererregionid INT NOT NULL,\\n urlcategoryid SMALLINT NOT NULL,\\n urlregionid INT NOT NULL,\\n resolutionwidth SMALLINT NOT NULL,\\n resolutionheight SMALLINT NOT NULL,\\n resolutiondepth SMALLINT NOT NULL,\\n flashmajor SMALLINT NOT NULL,\\n flashminor SMALLINT NOT NULL,\\n flashminor2 VARCHAR NOT NULL,\\n netmajor SMALLINT NOT NULL,\\n netminor SMALLINT NOT NULL,\\n useragentmajor SMALLINT NOT NULL,\\n useragentminor VARCHAR NOT NULL,\\n cookieenable SMALLINT NOT NULL,\\n javascriptenable SMALLINT NOT NULL,\\n ismobile SMALLINT NOT NULL,\\n mobilephone SMALLINT NOT NULL,\\n mobilephonemodel VARCHAR NOT NULL,\\n params VARCHAR NOT NULL,\\n ipnetworkid INT NOT NULL,\\n traficsourceid SMALLINT NOT NULL,\\n searchengineid SMALLINT NOT NULL,\\n searchphrase VARCHAR NOT NULL,\\n advengineid SMALLINT NOT NULL,\\n isartifical SMALLINT NOT NULL,\\n windowclientwidth SMALLINT NOT NULL,\\n windowclientheight SMALLINT NOT NULL,\\n clienttimezone SMALLINT NOT NULL,\\n clienteventtime TIMESTAMP NOT NULL,\\n silverlightversion1 SMALLINT NOT NULL,\\n silverlightversion2 SMALLINT NOT NULL,\\n silverlightversion3 INT NOT NULL,\\n silverlightversion4 SMALLINT NOT NULL,\\n pagecharset VARCHAR NOT NULL,\\n codeversion INT NOT NULL,\\n islink SMALLINT NOT NULL,\\n isdownload SMALLINT NOT NULL,\\n isnotbounce SMALLINT NOT NULL,\\n funiqid BIGINT NOT NULL,\\n originalurl VARCHAR NOT NULL,\\n hid INT NOT NULL,\\n isoldcounter SMALLINT NOT NULL,\\n isevent SMALLINT NOT NULL,\\n isparameter SMALLINT NOT NULL,\\n dontcounthits SMALLINT NOT NULL,\\n withhash SMALLINT NOT NULL,\\n hitcolor VARCHAR NOT NULL,\\n localeventtime TIMESTAMP NOT NULL,\\n age SMALLINT NOT NULL,\\n sex SMALLINT NOT NULL,\\n income SMALLINT NOT NULL,\\n interests SMALLINT NOT NULL,\\n robotness SMALLINT NOT NULL,\\n remoteip INT NOT NULL,\\n windowname INT NOT NULL,\\n openername INT NOT NULL,\\n historylength SMALLINT NOT NULL,\\n browserlanguage VARCHAR NOT NULL,\\n browsercountry VARCHAR NOT NULL,\\n socialnetwork VARCHAR NOT NULL,\\n socialaction VARCHAR NOT NULL,\\n httperror SMALLINT NOT NULL,\\n sendtiming INT NOT NULL,\\n dnstiming INT NOT NULL,\\n connecttiming INT NOT NULL,\\n responsestarttiming INT NOT NULL,\\n responseendtiming INT NOT NULL,\\n fetchtiming INT NOT NULL,\\n socialsourcenetworkid SMALLINT NOT NULL,\\n socialsourcepage VARCHAR NOT NULL,\\n paramprice BIGINT NOT NULL,\\n paramorderid VARCHAR NOT NULL,\\n paramcurrency VARCHAR NOT NULL,\\n paramcurrencyid SMALLINT NOT NULL,\\n openstatservicename VARCHAR NOT NULL,\\n openstatcampaignid VARCHAR NOT NULL,\\n openstatadid VARCHAR NOT NULL,\\n openstatsourceid VARCHAR NOT NULL,\\n utmsource VARCHAR NOT NULL,\\n utmmedium VARCHAR NOT NULL,\\n utmcampaign VARCHAR NOT NULL,\\n utmcontent VARCHAR NOT NULL,\\n utmterm VARCHAR NOT NULL,\\n fromtag VARCHAR NOT NULL,\\n hasgclid SMALLINT NOT NULL,\\n refererhash BIGINT NOT NULL,\\n urlhash BIGINT NOT NULL,\\n clid INT NOT NULL\\n) \\tCREATE TABLE json_demo (\\n id INT NULL,\\n data VARIANT NULL\\n) \\tCREATE TABLE jxcsdrpt (\\n settleno INT NOT NULL,\\n fildate DATE NOT NULL,\\n storegid INT NOT NULL,\\n gdgid INT NOT NULL,\\n qcqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n qctax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n qcamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lsqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lstax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lsamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lstqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lsttax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lstamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcyqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcytax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcyamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pfqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pftax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pfamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pftqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pfttax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pftamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpcqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpctax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpcamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpctqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpcttax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n tpctamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpcqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpctax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpcamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpctqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpcttax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n zpctamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbjqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbjtax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbjamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbcqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbctax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n dbcamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n shqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n shtax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n shamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n yyqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n yytax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n yyamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pyqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pytax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pyamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pkqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pktax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n pkamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n qmqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n qmtax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n qmamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n phcyamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n phcytax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n phcyqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcy2qty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcy2tax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n cbcy2amt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbjqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbjtax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbjamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbcqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbctax DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n jmdbcamt DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lsrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n lstrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n scoreqty DECIMAL(24, 4) NOT NULL DEFAULT 0.00,\\n scoreamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n scoretax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n scorertotal DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzyqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzyamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzytax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzyrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzycqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzycamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzyctax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n cbzycrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pdhcqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pdhcamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pdhctax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pdhcrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n djcqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n djctax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n djcamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n djcrtotal DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pfrealtax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pfrealamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lsrealtax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lsrealamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lstrealtax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lstrealamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pftrealtax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n pftrealamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n kcjtzqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n kcjtziamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n kcjtzitax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lyqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lyamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lytax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lyfhqty DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lyfhamt DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n lyfhtax DECIMAL(24, 4) NOT NULL DEFAULT 0,\\n ocrdate DATE NOT NULL\\n) \\tCREATE TABLE lib_meta_test (\\n lib_name VARCHAR NOT NULL,\\n vendor VARCHAR NOT NULL,\\n platform VARCHAR NOT NULL,\\n ver_number VARCHAR NOT NULL,\\n feature_len VARIANT NOT NULL,\\n release_date VARIANT NOT NULL\\n) \\tCREATE TABLE lt (\\n number BIGINT UNSIGNED NOT NULL\\n) \\tCREATE TABLE mdm_store (\\n store_id BIGINT NOT NULL COMMENT '主键',\\n store_name VARCHAR NULL DEFAULT NULL COMMENT '门店名称',\\n store_code VARCHAR NOT NULL COMMENT '门店编码',\\n type_id BIGINT NULL DEFAULT NULL COMMENT '客户类型',\\n sales_region BIGINT NULL DEFAULT NULL COMMENT '销售大区',\\n geo_id BIGINT NULL DEFAULT NULL COMMENT '地理区域',\\n store_addr VARCHAR NULL DEFAULT NULL COMMENT '门店地址',\\n state BIGINT NULL DEFAULT NULL COMMENT '状态',\\n logic_state INT NULL DEFAULT 1 COMMENT '逻辑删除标识 0 删除 1 未删',\\n business_state VARCHAR NULL DEFAULT NULL COMMENT 'mdm状态1营业关闭冻结',\\n ext_code VARCHAR NULL DEFAULT NULL COMMENT '外部编码',\\n store_alias VARCHAR NULL DEFAULT NULL COMMENT '门店别称',\\n nature_id BIGINT NULL DEFAULT NULL COMMENT '门店性质',\\n channel_id BIGINT NULL DEFAULT NULL COMMENT '门店渠道id(b_shop_type 门店类型)',\\n cha VARCHAR NULL DEFAULT NULL,\\n other_id BIGINT NULL DEFAULT NULL COMMENT '其他分类 仓库、门店、办公处、经销商门市',\\n zip_code VARCHAR NULL DEFAULT NULL COMMENT '邮政编码',\\n linkman VARCHAR NULL DEFAULT NULL COMMENT '联系人',\\n linktel VARCHAR NULL DEFAULT NULL COMMENT '联系电话',\\n level_id BIGINT NULL DEFAULT NULL COMMENT '门店等级',\\n lon VARCHAR NULL DEFAULT NULL COMMENT '经　　度',\\n lat VARCHAR NULL DEFAULT NULL COMMENT '纬　　度',\\n remark VARCHAR NULL DEFAULT NULL COMMENT '备注',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户Id',\\n tenant_data_id VARCHAR NULL DEFAULT NULL COMMENT '客户数据唯一key',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '修改人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',\\n channel_one_id BIGINT NULL DEFAULT NULL COMMENT '一级渠道ID(b_channel 门店渠道)',\\n channel_two_id BIGINT NULL DEFAULT NULL COMMENT '二级渠道ID(b_channel_type 门店渠道类型)',\\n img_id VARCHAR NULL DEFAULT NULL COMMENT '门店图片',\\n owner_id BIGINT NULL DEFAULT NULL COMMENT '所属人ID',\\n owner_org_id BIGINT NULL DEFAULT NULL COMMENT '所属组织ID',\\n sort INT NULL DEFAULT NULL COMMENT '排序',\\n last_visit_time TIMESTAMP NULL DEFAULT NULL COMMENT '最后到访时间',\\n last_visit_img VARCHAR NULL DEFAULT NULL COMMENT '最后到防门头照',\\n last_visit_user_id BIGINT NULL DEFAULT NULL COMMENT '最后到访人ID',\\n mod_id BIGINT NULL DEFAULT NULL COMMENT '功能模块Id',\\n trace_id VARCHAR NULL DEFAULT NULL COMMENT '流程id',\\n biz_date DATE NULL DEFAULT NULL COMMENT '业务日期',\\n mobile_upload_date TIMESTAMP NULL DEFAULT NULL COMMENT '移动端上传时间',\\n is_temp INT NULL DEFAULT NULL COMMENT '暂存',\\n remark01 VARCHAR NULL DEFAULT NULL COMMENT '备用字段01',\\n remark02 VARCHAR NULL DEFAULT NULL COMMENT '备用字段02',\\n remark03 VARCHAR NULL DEFAULT NULL COMMENT '备用字段03',\\n remark04 VARCHAR NULL DEFAULT NULL COMMENT '备用字段04',\\n remark05 VARCHAR NULL DEFAULT NULL COMMENT '备用字段05',\\n remark06 VARCHAR NULL DEFAULT NULL COMMENT '备用字段06',\\n cust_org VARCHAR NULL DEFAULT NULL COMMENT '客户组织',\\n chain_group_id BIGINT NULL DEFAULT NULL COMMENT '门店客户组id',\\n chain_type_id BIGINT NULL DEFAULT NULL COMMENT '门店客户组类别id',\\n channel_type_id BIGINT NULL DEFAULT NULL COMMENT '门店渠道类型id(无用字段，用channel_two_id)',\\n cover_type_id BIGINT NULL DEFAULT NULL COMMENT '覆盖类型id',\\n customer_category_id BIGINT NULL DEFAULT NULL COMMENT '客户类别',\\n distribution_type_id BIGINT NULL DEFAULT NULL COMMENT '分销门店类型',\\n sales_brand_ids VARCHAR NULL DEFAULT NULL COMMENT '售卖品牌',\\n sales_other_brand_ids VARCHAR NULL DEFAULT NULL COMMENT '其他售卖冰冻品牌',\\n retail_id BIGINT NULL DEFAULT NULL COMMENT '零售环境id',\\n has_wz VARCHAR NULL DEFAULT NULL COMMENT '湾仔分销：1是，0否',\\n has_hgds VARCHAR NULL DEFAULT NULL COMMENT '哈根达斯分销：1是，0否',\\n has_wb VARCHAR NULL DEFAULT NULL COMMENT '维邦分销：1是，0否',\\n cust_org_id BIGINT NULL DEFAULT NULL COMMENT '客户组织字典id',\\n mod_code VARCHAR NULL DEFAULT NULL COMMENT '功能模块编号',\\n conf_approval_status INT NULL DEFAULT NULL COMMENT '审批状态 1审批中 2等待处理 3驳回 4通过 5重新申请 6撤回 7取消',\\n conf_approver BIGINT NULL DEFAULT NULL COMMENT '审批人',\\n conf_approval_time TIMESTAMP NULL DEFAULT NULL COMMENT '审批时间',\\n has_check_nmj SMALLINT NULL DEFAULT NULL COMMENT '1是否考核糯米鸡',\\n parent_store_id BIGINT NULL DEFAULT NULL COMMENT '父级客户id',\\n account_holder VARCHAR NULL DEFAULT NULL COMMENT '开户人',\\n account VARCHAR NULL DEFAULT NULL COMMENT '账号',\\n account_back VARCHAR NULL DEFAULT NULL COMMENT '开户行',\\n dist_code VARCHAR NULL DEFAULT NULL COMMENT '经销商编码',\\n dist_codes VARCHAR NULL DEFAULT NULL COMMENT '经销商编码（后台报表）',\\n dist_names VARCHAR NULL DEFAULT NULL COMMENT '经销商名称（后台报表）',\\n owner_codes VARCHAR NULL COMMENT '所属人编码',\\n owner_names VARCHAR NULL COMMENT '所属人名称',\\n dist_ids VARCHAR NULL DEFAULT NULL COMMENT '经销商id(后台报表)',\\n owner_ids VARCHAR NULL COMMENT '所属人id（后台报表）',\\n org_ids VARCHAR NULL COMMENT '组织ids（后台报表）',\\n org_codes VARCHAR NULL COMMENT '组织编码',\\n org_names VARCHAR NULL COMMENT '组织名称',\\n business_type_id BIGINT NULL DEFAULT NULL COMMENT '经营品类',\\n prod_brand_id BIGINT NULL DEFAULT NULL COMMENT '经营品牌',\\n has_own_store VARCHAR NULL DEFAULT NULL COMMENT '是否有自家门店',\\n has_cooperated VARCHAR NULL DEFAULT NULL COMMENT '是否有过合作',\\n cooperation_amount DECIMAL(20, 2) NULL DEFAULT NULL COMMENT '合作金额',\\n maintainer_org_id BIGINT NULL DEFAULT NULL COMMENT '维护团队',\\n maintainer_id BIGINT NULL DEFAULT NULL COMMENT '维护人',\\n business_type VARCHAR NULL DEFAULT NULL COMMENT '经营品类文本',\\n prod_brand VARCHAR NULL DEFAULT NULL COMMENT '经营品牌文本',\\n team_id VARCHAR NULL DEFAULT NULL COMMENT '组织编码（sync）',\\n team_name VARCHAR NULL DEFAULT NULL COMMENT '组织名称（sync）',\\n manager_id VARCHAR NULL DEFAULT NULL COMMENT '负责人编码（sync）',\\n manager_name VARCHAR NULL DEFAULT NULL COMMENT '负责人名称（sync）',\\n cust_stat_cd VARCHAR NULL DEFAULT NULL COMMENT '门店状态（sync）',\\n province VARCHAR NULL DEFAULT NULL COMMENT '省（sync）',\\n city VARCHAR NULL DEFAULT NULL COMMENT '市（sync）',\\n county VARCHAR NULL DEFAULT NULL COMMENT '区（sync）',\\n ou_type_cd VARCHAR NULL DEFAULT NULL COMMENT '门店渠道（sync）',\\n par_ou_name VARCHAR NULL DEFAULT NULL COMMENT '门店所属系统（sync）',\\n par_ou_type_cd VARCHAR NULL DEFAULT NULL COMMENT '门店所属系统第一层字典名称（sync）',\\n par_ou_id VARCHAR NULL DEFAULT NULL COMMENT '门店所属系统第二层字典编码（sync）',\\n send_status INT NULL DEFAULT NULL COMMENT '推送状态1 成功 2新增推送失败3编辑推送失败'\\n) \\tCREATE TABLE mdm_store_apply (\\n store_apply_id BIGINT NOT NULL COMMENT '申请ID',\\n store_id BIGINT NULL DEFAULT NULL COMMENT '门店ID',\\n store_name VARCHAR NULL DEFAULT NULL COMMENT '门店名称',\\n store_code VARCHAR NULL DEFAULT NULL COMMENT '门店编码',\\n type_id BIGINT NULL DEFAULT NULL COMMENT '门店类型',\\n sales_region BIGINT NULL DEFAULT NULL COMMENT '销售大区',\\n geo_id BIGINT NULL DEFAULT NULL COMMENT '地理区域',\\n villages VARCHAR NULL DEFAULT NULL COMMENT '乡镇',\\n store_addr VARCHAR NULL DEFAULT NULL COMMENT '门店地址',\\n state BIGINT NULL DEFAULT NULL COMMENT '状态',\\n logic_state INT NULL DEFAULT 1 COMMENT '逻辑删除标识 0 删除 1 未删',\\n business_state VARCHAR NULL DEFAULT NULL COMMENT '业务状态',\\n channel_id BIGINT NULL DEFAULT NULL COMMENT '门店渠道id',\\n other_id BIGINT NULL DEFAULT NULL COMMENT '其他分类 仓库、门店、办公处、经销商门市',\\n linkman VARCHAR NULL DEFAULT NULL COMMENT '联系人',\\n linktel VARCHAR NULL DEFAULT NULL COMMENT '联系电话',\\n level_id BIGINT NULL DEFAULT NULL COMMENT '门店等级',\\n lon VARCHAR NULL DEFAULT NULL COMMENT '经　　度',\\n lat VARCHAR NULL DEFAULT NULL COMMENT '纬　　度',\\n remark VARCHAR NULL DEFAULT NULL COMMENT '备注',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户Id',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '修改人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',\\n img_id VARCHAR NULL DEFAULT NULL COMMENT '门店图片',\\n owner_id BIGINT NULL DEFAULT NULL COMMENT '所属人ID',\\n owner_org_id BIGINT NULL DEFAULT NULL COMMENT '所属组织ID',\\n location VARCHAR NULL DEFAULT NULL COMMENT '地理位置',\\n sort INT NULL DEFAULT NULL COMMENT '排序',\\n last_order_user_id BIGINT NULL DEFAULT NULL COMMENT '最后订单人',\\n chain_id BIGINT NULL DEFAULT NULL COMMENT '连锁店Id',\\n retail_store_code VARCHAR NULL DEFAULT NULL COMMENT '零售商系统门店编码',\\n mod_id BIGINT NULL DEFAULT NULL COMMENT '功能模块Id',\\n trace_id VARCHAR NULL DEFAULT NULL COMMENT '流程id',\\n biz_date DATE NULL DEFAULT NULL COMMENT '业务日期',\\n mobile_upload_date TIMESTAMP NULL DEFAULT NULL COMMENT '移动端上传时间',\\n is_temp INT NULL DEFAULT NULL COMMENT '暂存',\\n dist_id BIGINT NULL DEFAULT NULL COMMENT '经销商id',\\n artificial_cash_num INT NULL DEFAULT NULL COMMENT '人工收银台数量',\\n machine_cash_num INT NULL DEFAULT NULL COMMENT '自助收银台数量',\\n cash_imgs VARCHAR NULL COMMENT '收银台照片',\\n retail_id BIGINT NULL DEFAULT NULL COMMENT '零售环境id',\\n maintain_id BIGINT NULL DEFAULT NULL COMMENT '门店维护原因id',\\n maintain_item VARCHAR NULL DEFAULT NULL COMMENT '门店维护详情',\\n contractor_linktel VARCHAR NULL DEFAULT NULL COMMENT '包场商联系电话',\\n remark01 VARCHAR NULL DEFAULT NULL COMMENT '备用字段01',\\n remark02 VARCHAR NULL DEFAULT NULL COMMENT '备用字段02',\\n remark03 VARCHAR NULL DEFAULT NULL COMMENT '备用字段03',\\n remark04 VARCHAR NULL DEFAULT NULL COMMENT '备用字段04',\\n remark05 VARCHAR NULL DEFAULT NULL COMMENT '备用字段05',\\n remark06 VARCHAR NULL DEFAULT NULL COMMENT '备用字段06',\\n is_visit BIGINT NULL DEFAULT NULL COMMENT '是否拜访',\\n freeze_id BIGINT NULL DEFAULT NULL COMMENT '冻结类型',\\n freeze_img VARCHAR NULL COMMENT '冻结图片',\\n mod_code VARCHAR NULL DEFAULT NULL,\\n conf_approval_status VARCHAR NULL DEFAULT '1' COMMENT '审批状态（1：待审批 4：审批通过）',\\n conf_approver VARCHAR NULL DEFAULT NULL,\\n conf_approval_time TIMESTAMP NULL DEFAULT NULL,\\n all_cash_num INT NULL DEFAULT NULL COMMENT '收银台总数',\\n iis_freeze BIGINT NULL DEFAULT NULL COMMENT '是否冻结',\\n approval_type BIGINT NULL DEFAULT NULL COMMENT '申请类型（1：新增 2：修改 3：冻结 4：申请经纬度 5:资料确认）',\\n update_lat_lon_imgs VARCHAR NULL DEFAULT NULL COMMENT '修改经纬度图片',\\n iis_same INT NULL DEFAULT NULL COMMENT '以上资料是否与实际一致',\\n store_elationship VARCHAR NULL DEFAULT NULL COMMENT '门岗关系绑定',\\n city_level BIGINT NULL DEFAULT NULL COMMENT '城市等级',\\n sync_picture VARCHAR NULL DEFAULT NULL COMMENT '同步照片',\\n sync_source VARCHAR NULL DEFAULT NULL COMMENT '同步来源',\\n province VARCHAR NULL DEFAULT NULL COMMENT '省份',\\n city VARCHAR NULL DEFAULT NULL COMMENT '城市',\\n area VARCHAR NULL DEFAULT NULL COMMENT '区域',\\n new_maintain_item VARCHAR NULL DEFAULT NULL COMMENT '新增维护原因',\\n dist_code VARCHAR NULL DEFAULT NULL COMMENT '经销商Code',\\n store_state VARCHAR NULL DEFAULT NULL COMMENT '门店状态',\\n start_flow INT NULL DEFAULT NULL COMMENT '是否启动流程',\\n nature_id BIGINT NULL DEFAULT NULL COMMENT '门店性质',\\n corp_id BIGINT NULL DEFAULT NULL COMMENT '客户系统Id',\\n store_alias VARCHAR NULL DEFAULT NULL COMMENT '门店别称',\\n ext_code VARCHAR NULL DEFAULT NULL COMMENT '外部编码',\\n parent_store_id BIGINT NULL DEFAULT NULL COMMENT '父客户',\\n account_holder VARCHAR NULL DEFAULT NULL COMMENT '开户人',\\n account VARCHAR NULL DEFAULT NULL COMMENT '账号',\\n account_back VARCHAR NULL DEFAULT NULL COMMENT '开户行',\\n is_edit VARCHAR NULL DEFAULT NULL\\n) \\tCREATE TABLE mytable1 (\\n a INT NULL\\n) \\tCREATE TABLE nation (\\n n_nationkey INT NOT NULL,\\n n_name VARCHAR NOT NULL,\\n n_regionkey INT NOT NULL,\\n n_comment VARCHAR NOT NULL\\n) \\tCREATE TABLE night_time_execution (\\n id INT NULL,\\n execution_time TIMESTAMP NULL,\\n result VARCHAR NULL,\\n condition_met BOOLEAN NULL\\n) \\tCREATE TABLE ontime (\\n year SMALLINT UNSIGNED NOT NULL,\\n quarter TINYINT UNSIGNED NOT NULL,\\n month TINYINT UNSIGNED NOT NULL,\\n dayofmonth TINYINT UNSIGNED NOT NULL,\\n dayofweek TINYINT UNSIGNED NOT NULL,\\n flightdate DATE NOT NULL,\\n reporting_airline VARCHAR NOT NULL,\\n dot_id_reporting_airline INT NOT NULL,\\n iata_code_reporting_airline VARCHAR NOT NULL,\\n tail_number VARCHAR NOT NULL,\\n flight_number_reporting_airline VARCHAR NOT NULL,\\n originairportid INT NOT NULL,\\n originairportseqid INT NOT NULL,\\n origincitymarketid INT NOT NULL,\\n origin VARCHAR NOT NULL,\\n origincityname VARCHAR NOT NULL,\\n originstate VARCHAR NOT NULL,\\n originstatefips VARCHAR NOT NULL,\\n originstatename VARCHAR NOT NULL,\\n originwac INT NOT NULL,\\n destairportid INT NOT NULL,\\n destairportseqid INT NOT NULL,\\n destcitymarketid INT NOT NULL,\\n dest VARCHAR NOT NULL,\\n destcityname VARCHAR NOT NULL,\\n deststate VARCHAR NOT NULL,\\n deststatefips VARCHAR NOT NULL,\\n deststatename VARCHAR NOT NULL,\\n destwac INT NOT NULL,\\n crsdeptime INT NOT NULL,\\n deptime INT NOT NULL,\\n depdelay INT NOT NULL,\\n depdelayminutes INT NOT NULL,\\n depdel15 INT NOT NULL,\\n departuredelaygroups VARCHAR NOT NULL,\\n deptimeblk VARCHAR NOT NULL,\\n taxiout INT NOT NULL,\\n wheelsoff INT NOT NULL,\\n wheelson INT NOT NULL,\\n taxiin INT NOT NULL,\\n crsarrtime INT NOT NULL,\\n arrtime INT NOT NULL,\\n arrdelay INT NOT NULL,\\n arrdelayminutes INT NOT NULL,\\n arrdel15 INT NOT NULL,\\n arrivaldelaygroups INT NOT NULL,\\n arrtimeblk VARCHAR NOT NULL,\\n cancelled TINYINT UNSIGNED NOT NULL,\\n cancellationcode VARCHAR NOT NULL,\\n diverted TINYINT UNSIGNED NOT NULL,\\n crselapsedtime INT NOT NULL,\\n actualelapsedtime INT NOT NULL,\\n airtime INT NOT NULL,\\n flights INT NOT NULL,\\n distance INT NOT NULL,\\n distancegroup TINYINT UNSIGNED NOT NULL,\\n carrierdelay INT NOT NULL,\\n weatherdelay INT NOT NULL,\\n nasdelay INT NOT NULL,\\n securitydelay INT NOT NULL,\\n lateaircraftdelay INT NOT NULL,\\n firstdeptime VARCHAR NOT NULL,\\n totaladdgtime VARCHAR NOT NULL,\\n longestaddgtime VARCHAR NOT NULL,\\n divairportlandings VARCHAR NOT NULL,\\n divreacheddest VARCHAR NOT NULL,\\n divactualelapsedtime VARCHAR NOT NULL,\\n divarrdelay VARCHAR NOT NULL,\\n divdistance VARCHAR NOT NULL,\\n div1airport VARCHAR NOT NULL,\\n div1airportid INT NOT NULL,\\n div1airportseqid INT NOT NULL,\\n div1wheelson VARCHAR NOT NULL,\\n div1totalgtime VARCHAR NOT NULL,\\n div1longestgtime VARCHAR NOT NULL,\\n div1wheelsoff VARCHAR NOT NULL,\\n div1tailnum VARCHAR NOT NULL,\\n div2airport VARCHAR NOT NULL,\\n div2airportid INT NOT NULL,\\n div2airportseqid INT NOT NULL,\\n div2wheelson VARCHAR NOT NULL,\\n div2totalgtime VARCHAR NOT NULL,\\n div2longestgtime VARCHAR NOT NULL,\\n div2wheelsoff VARCHAR NOT NULL,\\n div2tailnum VARCHAR NOT NULL,\\n div3airport VARCHAR NOT NULL,\\n div3airportid INT NOT NULL,\\n div3airportseqid INT NOT NULL,\\n div3wheelson VARCHAR NOT NULL,\\n div3totalgtime VARCHAR NOT NULL,\\n div3longestgtime VARCHAR NOT NULL,\\n div3wheelsoff VARCHAR NOT NULL,\\n div3tailnum VARCHAR NOT NULL,\\n div4airport VARCHAR NOT NULL,\\n div4airportid INT NOT NULL,\\n div4airportseqid INT NOT NULL,\\n div4wheelson VARCHAR NOT NULL,\\n div4totalgtime VARCHAR NOT NULL,\\n div4longestgtime VARCHAR NOT NULL,\\n div4wheelsoff VARCHAR NOT NULL,\\n div4tailnum VARCHAR NOT NULL,\\n div5airport VARCHAR NOT NULL,\\n div5airportid INT NOT NULL,\\n div5airportseqid INT NOT NULL,\\n div5wheelson VARCHAR NOT NULL,\\n div5totalgtime VARCHAR NOT NULL,\\n div5longestgtime VARCHAR NOT NULL,\\n div5wheelsoff VARCHAR NOT NULL,\\n div5tailnum VARCHAR NOT NULL\\n) \\tCREATE TABLE orders_placed (\\n order_id INT NULL,\\n customer_id INT NULL,\\n order_amount FLOAT NULL,\\n order_date DATE NULL\\n) \\tCREATE TABLE ori_video_tags_frame_bitmap (\\n ori_video VARCHAR NOT NULL COMMENT '原始视频ID，格式：ori000000001（9位补零）',\\n tag_key INT NOT NULL COMMENT '标签键，例如254=天气、53=加塞、300-319=业务标签',\\n tag_value SMALLINT NOT NULL COMMENT '标签值，例如天气：1=晴天、2=雨天、3=阴天',\\n frame_count INT NOT NULL COMMENT '该标签包含的帧数，与ori_frame_bitmap中的元素个数一致',\\n ori_frame_bitmap BITMAP NOT NULL COMMENT '帧ID的BITMAP，压缩存储包含该标签的所有帧ID（0-5999）'\\n) \\tCREATE TABLE product_detail (\\n product_id VARCHAR NOT NULL,\\n product_name VARCHAR NOT NULL,\\n pro_price INT NOT NULL\\n) \\tCREATE TABLE products (\\n product_id INT UNSIGNED NOT NULL,\\n product_name VARCHAR NOT NULL,\\n price DECIMAL(10, 2) NOT NULL,\\n category VARCHAR NOT NULL\\n) \\tCREATE TABLE pypi_file_download_test_001 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file VARIANT NULL,\\n details VARIANT NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE rand_id (\\n id BIGINT NULL\\n) \\tCREATE TABLE random_video_id (\\n video_id VARCHAR NULL,\\n number BIGINT UNSIGNED NULL\\n) \\tCREATE TABLE raw_data (\\n id INT NULL,\\n data VARIANT NULL\\n) \\tCREATE STREAM `raw_data_stream` ON TABLE `default`.`raw_data`\\tCREATE TABLE sail_info (\\n product_id VARCHAR NOT NULL,\\n number INT NOT NULL,\\n sail_time TIMESTAMP NOT NULL\\n) \\tCREATE TABLE sales (\\n sale_id INT UNSIGNED NOT NULL,\\n product_id INT UNSIGNED NOT NULL,\\n customer_id INT UNSIGNED NOT NULL,\\n sale_date DATE NOT NULL,\\n quantity INT NOT NULL,\\n net_paid DECIMAL(10, 2) NOT NULL\\n) \\tCREATE TABLE sales_data (\\n id INT NULL,\\n salesperson VARCHAR NULL,\\n region VARCHAR NULL,\\n sale_date DATE NULL,\\n amount DECIMAL(10, 2) NULL\\n) \\tCREATE TABLE sbtest01 (\\n id INT NOT NULL,\\n k INT NOT NULL DEFAULT 0,\\n c VARCHAR NOT NULL DEFAULT '',\\n pad VARCHAR NOT NULL DEFAULT ''\\n) \\tCREATE TABLE stor (\\n type VARCHAR NOT NULL,\\n price INT NOT NULL\\n) \\tCREATE TABLE stor1 (\\n type VARCHAR NOT NULL,\\n price FLOAT NOT NULL\\n) \\tCREATE TABLE stor2 (\\n type VARCHAR NOT NULL,\\n price FLOAT NOT NULL\\n) \\tCREATE TABLE stream_data_update_note_v1 (\\n database_name VARCHAR NULL,\\n table_name VARCHAR NULL\\n) \\tCREATE TABLE students (\\n uid SMALLINT NULL,\\n name VARCHAR NULL,\\n age SMALLINT NULL\\n) \\tCREATE TABLE svc_service_order (\\n id INT NOT NULL COMMENT '主键ID,',\\n dealercode VARCHAR NOT NULL COMMENT '服务站编号',\\n dealername VARCHAR NULL DEFAULT NULL COMMENT '服务站;名称',\\n serviceordercode VARCHAR NULL DEFAULT NULL COMMENT '维修委托书编号,',\\n ordertype VARCHAR NULL DEFAULT NULL COMMENT '委托书类型',\\n chargetypes VARCHAR NULL DEFAULT NULL COMMENT '委托书收费类型',\\n serviceadvisorid INT NULL DEFAULT NULL COMMENT '服务顾问id,',\\n serviceadvisorname VARCHAR NULL DEFAULT NULL COMMENT '服务顾问名,',\\n arrivalon TIMESTAMP NULL DEFAULT NULL COMMENT '进店时间',\\n arrivalmileage INT NULL DEFAULT NULL COMMENT '进店里程',\\n faultdesc VARCHAR NULL DEFAULT NULL COMMENT '故障描述',\\n checkresult VARCHAR NULL DEFAULT NULL COMMENT '检查结果',\\n expectfinishat TIMESTAMP NULL DEFAULT NULL COMMENT '预计交车时间',\\n finishat TIMESTAMP NULL DEFAULT NULL COMMENT '实际交车时间',\\n carid INT NULL DEFAULT NULL COMMENT '车辆ID',\\n vin VARCHAR NULL DEFAULT NULL COMMENT '车辆VIN',\\n platenumber VARCHAR NULL DEFAULT NULL COMMENT '车牌号',\\n brand VARCHAR NULL DEFAULT NULL COMMENT '品牌',\\n series VARCHAR NULL DEFAULT NULL COMMENT '车系',\\n model VARCHAR NULL DEFAULT NULL COMMENT '车型',\\n madedate TIMESTAMP NULL DEFAULT NULL COMMENT '生产日期',\\n buydate TIMESTAMP NULL DEFAULT NULL COMMENT '购车日期',\\n customername VARCHAR NULL DEFAULT NULL COMMENT '顾客姓名',\\n customertel VARCHAR NULL DEFAULT NULL COMMENT '顾客电话',\\n customertype VARCHAR NULL DEFAULT NULL COMMENT '顾客类型',\\n sendername VARCHAR NULL DEFAULT NULL COMMENT '送修者姓名',\\n sendertel VARCHAR NULL DEFAULT NULL COMMENT '送修者电话',\\n insuranceendat TIMESTAMP NULL DEFAULT NULL COMMENT '保险到期日',\\n lastarrivalon TIMESTAMP NULL DEFAULT NULL COMMENT '上次进店日期',\\n lastmaintainon TIMESTAMP NULL DEFAULT NULL COMMENT '上次保养日期',\\n nextmaintainon TIMESTAMP NULL DEFAULT NULL COMMENT '下次保养日期',\\n nextmaintainmileage INT NULL DEFAULT NULL COMMENT '下次保养里程',\\n historytotalamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '累计消费金额',\\n historytotalcount INT NULL DEFAULT NULL COMMENT '累计消费次数',\\n partamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '配件金额合计',\\n itemamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '工时金额合计',\\n totalamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '总金额',\\n payableamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '结算金额',\\n discountamount DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '优惠金额',\\n techid INT NULL DEFAULT NULL COMMENT '维修技师Id',\\n techname VARCHAR NULL DEFAULT NULL COMMENT '维修技师名称',\\n repairstartat TIMESTAMP NULL DEFAULT NULL COMMENT '开工时间',\\n repairendat TIMESTAMP NULL DEFAULT NULL COMMENT '完工时间',\\n checkendat TIMESTAMP NULL DEFAULT NULL COMMENT '质检完成时间',\\n checkname VARCHAR NULL DEFAULT NULL COMMENT '质检人员姓名',\\n checkby INT NULL DEFAULT NULL COMMENT '质检人员id',\\n ringcheckstatus INT NULL DEFAULT NULL COMMENT ';',\\n laneid BIGINT NULL DEFAULT NULL COMMENT '工位id',\\n lanecode VARCHAR NULL DEFAULT NULL COMMENT '工位编号',\\n lanename VARCHAR NULL DEFAULT NULL COMMENT '工位名称',\\n appointmentcode VARCHAR NULL DEFAULT NULL COMMENT '预约单号',\\n status INT NULL DEFAULT NULL COMMENT '状态,创建中0,排队中1,待维修2,维修中3,待质检4,待结算5,已结算6,待交车7,已交车8,已作废9',\\n isdeleted TINYINT NOT NULL DEFAULT 0 COMMENT '删除标志,',\\n sequence INT NULL DEFAULT NULL COMMENT '排序,',\\n comments VARCHAR NULL DEFAULT NULL COMMENT '备注,',\\n creater INT NOT NULL COMMENT '创建人,',\\n createdate TIMESTAMP NOT NULL COMMENT '创建时间,',\\n updater INT NULL DEFAULT NULL COMMENT '修改人,',\\n updatedate TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间,',\\n version INT NOT NULL DEFAULT 0 COMMENT '数据版本',\\n enginenumber VARCHAR NULL DEFAULT NULL COMMENT '发动机号',\\n gearnumber VARCHAR NULL DEFAULT NULL COMMENT '变速箱号',\\n billdate TIMESTAMP NULL DEFAULT NULL COMMENT '开票日期',\\n meterchangemileage DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '换表里程',\\n vehicleattachment VARCHAR NULL DEFAULT NULL COMMENT '车辆附件',\\n custaddress VARCHAR NULL DEFAULT NULL COMMENT '客户地址',\\n iswash TINYINT NULL DEFAULT NULL COMMENT '是否洗车',\\n takeoldpart TINYINT NULL DEFAULT NULL COMMENT '带走旧件',\\n ringcheckpicture VARCHAR NULL DEFAULT NULL COMMENT '环检结果图片',\\n maintainconfirmpicture VARCHAR NULL DEFAULT NULL COMMENT '维修确认签名图片',\\n settlementconfirmpicture VARCHAR NULL DEFAULT NULL COMMENT '结算确认签名图片',\\n isassignfinishat TINYINT NOT NULL DEFAULT 0 COMMENT '是否手动指定完成时间',\\n rescueordercode VARCHAR NULL DEFAULT NULL COMMENT '救援单号',\\n rescueorderid VARCHAR NULL DEFAULT NULL COMMENT '救援单ID',\\n lineupdate TIMESTAMP NULL DEFAULT NULL COMMENT '排队时间',\\n parentordertype VARCHAR NULL DEFAULT NULL COMMENT '委托书大类',\\n appointmentat TIMESTAMP NULL DEFAULT NULL COMMENT '预约时间',\\n vsn VARCHAR NULL DEFAULT NULL COMMENT '车辆vsn',\\n isadd TINYINT NOT NULL DEFAULT 0 COMMENT '增项',\\n audit INT NOT NULL DEFAULT 0 COMMENT '审核状态',\\n auditdate TIMESTAMP NULL DEFAULT NULL COMMENT '审核时间',\\n auditreason VARCHAR NULL DEFAULT NULL COMMENT '审核备注',\\n isgoods TINYINT NULL DEFAULT NULL COMMENT '车内是否有规则物品',\\n speccheckdate TIMESTAMP NULL DEFAULT NULL COMMENT '检查单创建时间',\\n pickpartstatus VARCHAR NULL DEFAULT NULL COMMENT '领料状态 1待领料 2已领料 3 待退料 英文逗号拼接的',\\n lastarrivalmileage INT NULL DEFAULT NULL COMMENT '上次进站里程',\\n oilsign INT NULL DEFAULT NULL COMMENT '燃油量',\\n vehicletype INT NULL DEFAULT NULL COMMENT '车辆类型 ，1燃油车，2新能源',\\n saleprice DECIMAL(18, 3) NULL DEFAULT NULL COMMENT '销售价格',\\n isaddsign TINYINT NOT NULL DEFAULT 0 COMMENT '是否增修签名',\\n settlementsigndate TIMESTAMP NULL DEFAULT NULL COMMENT '结算签名时间',\\n settlementdate TIMESTAMP NULL DEFAULT NULL COMMENT '结算时间',\\n workordertype INT NULL DEFAULT NULL COMMENT '工单类型（1、普通工单，2、自助工单）',\\n reverttag INT NULL DEFAULT NULL COMMENT '反结算标志 (1有反结算 0无反结算)',\\n preordertag TINYINT NULL DEFAULT NULL COMMENT '售前工单标识',\\n nextarrivalon TIMESTAMP NULL DEFAULT NULL COMMENT '下次进店日期',\\n vehiclepictureurl VARCHAR NULL DEFAULT NULL COMMENT '车辆照片',\\n custno VARCHAR NULL DEFAULT NULL COMMENT '客户编号',\\n ordertip VARCHAR NULL DEFAULT NULL COMMENT '开单提醒',\\n serviceactivitytag TINYINT NULL DEFAULT NULL COMMENT '是否服务活动',\\n serviceactivitycode VARCHAR NULL DEFAULT NULL COMMENT '服务活动编号',\\n serviceactivityhasall TINYINT NULL DEFAULT NULL COMMENT '服务活动项目是否完整',\\n serviceactivityitem VARCHAR NULL DEFAULT NULL COMMENT '服务活动工时',\\n serviceactivitypart VARCHAR NULL DEFAULT NULL COMMENT '服务活动配件',\\n modelterrace VARCHAR NULL DEFAULT NULL COMMENT '车型平台',\\n lineorderid INT NULL DEFAULT NULL COMMENT '排队数据id',\\n serviceadvisorphone VARCHAR NULL DEFAULT NULL COMMENT '服务顾问手机号',\\n techphone VARCHAR NULL DEFAULT NULL COMMENT '技师手机号',\\n enginecapacity VARCHAR NULL DEFAULT NULL COMMENT '排量',\\n busstype VARCHAR NULL DEFAULT NULL COMMENT '工单业务类型',\\n onlineordercode VARCHAR NULL DEFAULT NULL COMMENT '关联线上订单 单号',\\n onlineordertype VARCHAR NULL DEFAULT NULL COMMENT '线上订单类型',\\n useridstr VARCHAR NULL DEFAULT NULL COMMENT '菱菱邦用户id',\\n source INT NULL DEFAULT NULL COMMENT '0、顾问直接开单 ,1、客户扫码;2、扫会员码 3、扫特殊二维码',\\n sourcesofvehicle VARCHAR NULL DEFAULT NULL COMMENT '车辆来源',\\n sourcesofuser VARCHAR NULL DEFAULT NULL COMMENT '用户来源',\\n custidno VARCHAR NULL DEFAULT NULL COMMENT '证件号',\\n certificatetype VARCHAR NULL DEFAULT NULL COMMENT '证件类型0:身份证;1:组织机构代码;2:税号;3:其他特殊证件;',\\n identificationurl VARCHAR NULL DEFAULT NULL COMMENT '行驶证url',\\n uploadstatus INT NOT NULL DEFAULT 0 COMMENT '上传状态 未上传0;上传成功1,上传失败2',\\n givedate TIMESTAMP NULL DEFAULT NULL COMMENT '交车日期',\\n insurancefirm VARCHAR NULL DEFAULT NULL COMMENT '保险公司',\\n dispatchtechids VARCHAR NULL DEFAULT NULL COMMENT '所有技师ID',\\n dispatchtechnames VARCHAR NULL DEFAULT NULL COMMENT '所有技师名字',\\n isgeneratebackvisit INT NULL DEFAULT NULL COMMENT '是否生成回访单1:生成',\\n revertexplain VARCHAR NULL DEFAULT NULL COMMENT '反结算说明',\\n userdescribe VARCHAR NULL DEFAULT NULL COMMENT '用户情绪',\\n parentrepairtype VARCHAR NULL DEFAULT NULL COMMENT '维修大类',\\n revertname VARCHAR NULL DEFAULT NULL COMMENT '反结算人',\\n revertdate TIMESTAMP NULL DEFAULT NULL COMMENT '反结算时间',\\n ismember TINYINT NOT NULL DEFAULT 0,\\n mebefore TINYINT NOT NULL DEFAULT 0 COMMENT '维保是否在维修前添加工时配件',\\n vehiclecode VARCHAR NULL DEFAULT NULL,\\n cancellationname VARCHAR NULL DEFAULT NULL,\\n cancellationid INT NULL DEFAULT NULL,\\n updatername VARCHAR NULL DEFAULT NULL,\\n cancellationdate TIMESTAMP NULL DEFAULT NULL COMMENT '作废时间',\\n uploaddate TIMESTAMP NULL DEFAULT NULL COMMENT '健康档案上传时间',\\n byconfirm INT NOT NULL DEFAULT 0 COMMENT '改装订单用户确认 0未确认,1已确认',\\n designateitemamount DECIMAL(18, 3) NOT NULL DEFAULT 0.000,\\n saledealername VARCHAR NULL DEFAULT NULL,\\n saledealerid VARCHAR NULL DEFAULT NULL,\\n automatictag TINYINT NOT NULL DEFAULT 0,\\n pdiabnormal TINYINT NOT NULL DEFAULT 0 COMMENT 'pdi是否异常（0：正常；1:异常）',\\n pdicode VARCHAR NULL DEFAULT NULL COMMENT 'pdi工单号',\\n vehicleownerchangetag TINYINT NULL DEFAULT NULL COMMENT '是否变更首任车主标志'\\n) \\tCREATE TABLE t1 (\\n a INT NOT NULL,\\n b INT NOT NULL\\n) \\tCREATE TABLE t10086 (\\n \\\"$insert_id\\\" INT NULL\\n) \\tCREATE TABLE t2 (\\n c VARCHAR NULL\\n) \\tCREATE TABLE t_0jzskh6elp7itu6a727e185khtf6kjfjr89ka1nb52v8mpgamm50ulk4rdei6kse_4662 (\\n _cq_source_name VARCHAR NULL,\\n _cq_sync_time TIMESTAMP NULL,\\n \\\"ID\\\" BIGINT NULL,\\n \\\"REPORT_ID\\\" BIGINT NULL,\\n \\\"NAME\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_0jzskh6elp7itu6a727e185khtf6kjfjr89ka1nb52v8mpgamm50ulk4rdei6kse_8929 (\\n _cq_source_name VARCHAR NULL,\\n _cq_sync_time TIMESTAMP NULL,\\n \\\"ID\\\" BIGINT NULL,\\n \\\"REPORT_ID\\\" BIGINT NULL,\\n \\\"NAME\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_8xvycvwtx3krzu3n22khw4jldl0kwntthv9bjaxp8d2m9c2jdisi65alexchk8lk_5288 (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_8xvycvwtx3krzu3n22khw4jldl0kwntthv9bjaxp8d2m9c2jdisi65alexchk8lk_5590 (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_8xvycvwtx3krzu3n22khw4jldl0kwntthv9bjaxp8d2m9c2jdisi65alexchk8lk_5647 (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_8xvycvwtx3krzu3n22khw4jldl0kwntthv9bjaxp8d2m9c2jdisi65alexchk8lk_7501 (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_8xvycvwtx3krzu3n22khw4jldl0kwntthv9bjaxp8d2m9c2jdisi65alexchk8lk_9641 (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_books_0400 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_1345 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_1684 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_3127 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_5005 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_8118 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_books_8207 (\\n title BINARY NULL,\\n author BINARY NULL,\\n date BINARY NULL\\n) \\tCREATE TABLE t_books_8653 (\\n title VARCHAR NULL,\\n author VARCHAR NULL,\\n date VARCHAR NULL\\n) \\tCREATE TABLE t_demo2_7317 (\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL\\n) \\tCREATE TABLE t_demo_5032 (\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL\\n) \\tCREATE TABLE t_demo_8732 (\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n c11 VARCHAR NULL,\\n c12 VARCHAR NULL,\\n c13 VARCHAR NULL,\\n c14 VARCHAR NULL,\\n c15 VARCHAR NULL,\\n c16 VARCHAR NULL,\\n c17 VARCHAR NULL,\\n c18 VARCHAR NULL,\\n c19 VARCHAR NULL,\\n c20 VARCHAR NULL,\\n c21 VARCHAR NULL,\\n c22 VARCHAR NULL,\\n c23 VARCHAR NULL,\\n c24 VARCHAR NULL,\\n c25 VARCHAR NULL\\n) \\tCREATE TABLE t_demo_87321 (\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n c11 VARCHAR NULL,\\n c12 VARCHAR NULL,\\n c13 VARCHAR NULL,\\n c14 VARCHAR NULL,\\n c15 VARCHAR NULL,\\n c16 VARCHAR NULL,\\n c17 VARCHAR NULL,\\n c18 VARCHAR NULL,\\n c19 VARCHAR NULL,\\n c20 VARCHAR NULL,\\n c21 VARCHAR NULL,\\n c22 VARCHAR NULL,\\n c23 VARCHAR NULL,\\n c24 VARCHAR NULL,\\n c25 VARCHAR NULL,\\n c26 VARCHAR NULL\\n) \\tCREATE TABLE t_demo_8794 (\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL\\n) \\tCREATE TABLE t_file_download001 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NOT NULL, PROJECT VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, TYPE VARCHAR NOT NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, DISTRO TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, ID VARCHAR NOT NULL, LIBC TUPLE(LIB VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NOT NULL, RELEASE VARCHAR NOT NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download002 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NOT NULL, PROJECT VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, TYPE VARCHAR NOT NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download003 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NULL, OPENSSL_VERSION VARCHAR NULL, SETUPTOOLS_VERSION VARCHAR NULL, RUSTC_VERSION VARCHAR NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_30441 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_30442 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_30443 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NOT NULL, RELEASE VARCHAR NOT NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_30445 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NOT NULL, RELEASE VARCHAR NOT NULL) NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_3051 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NOT NULL, PROJECT VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, TYPE VARCHAR NOT NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL, DISTRO TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, ID VARCHAR NOT NULL, LIBC TUPLE(LIB VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL) NOT NULL, SYSTEM TUPLE(NAME VARCHAR NOT NULL, RELEASE VARCHAR NOT NULL) NOT NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_3251 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NOT NULL, PROJECT VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, TYPE VARCHAR NOT NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL, PYTHON VARCHAR NOT NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL, DISTRO TUPLE(NAME VARCHAR NOT NULL, VERSION VARCHAR NOT NULL, ID VARCHAR NOT NULL, LIBC TUPLE(LIB VARCHAR NOT NULL, VERSION VARCHAR NOT NULL) NOT NULL) NOT NULL, SYSTEM TUPLE(NAME VARCHAR NOT NULL, RELEASE VARCHAR NOT NULL) NOT NULL, CPU VARCHAR NOT NULL, OPENSSL_VERSION VARCHAR NOT NULL, SETUPTOOLS_VERSION VARCHAR NOT NULL, RUSTC_VERSION VARCHAR NOT NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_6052 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file VARIANT NULL,\\n details VARIANT NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000000_8131 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NULL, OPENSSL_VERSION VARCHAR NULL, SETUPTOOLS_VERSION VARCHAR NULL, RUSTC_VERSION VARCHAR NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_file_download_000000000001_2141 (\\n timestamp TIMESTAMP NULL,\\n country_code VARCHAR NULL,\\n url VARCHAR NULL,\\n project VARCHAR NULL,\\n file TUPLE(FILENAME VARCHAR NULL, PROJECT VARCHAR NULL, VERSION VARCHAR NULL, TYPE VARCHAR NULL) NULL,\\n details TUPLE(INSTALLER TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, PYTHON VARCHAR NULL, IMPLEMENTATION TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL) NULL, DISTRO TUPLE(NAME VARCHAR NULL, VERSION VARCHAR NULL, ID VARCHAR NULL, LIBC TUPLE(LIB VARCHAR NULL, VERSION VARCHAR NULL) NULL) NULL, SYSTEM TUPLE(NAME VARCHAR NULL, RELEASE VARCHAR NULL) NULL, CPU VARCHAR NULL, OPENSSL_VERSION VARCHAR NULL, SETUPTOOLS_VERSION VARCHAR NULL, RUSTC_VERSION VARCHAR NULL) NULL,\\n tls_protocol VARCHAR NULL,\\n tls_cipher VARCHAR NULL\\n) \\tCREATE TABLE t_json (\\n c1 MAP(VARCHAR NOT NULL, VARCHAR NOT NULL) NOT NULL\\n) \\tCREATE TABLE t_mt_2020 (\\n year SMALLINT UNSIGNED NOT NULL,\\n quarter TINYINT UNSIGNED NOT NULL,\\n month TINYINT UNSIGNED NOT NULL,\\n dayofmonth TINYINT UNSIGNED NOT NULL,\\n dayofweek TINYINT UNSIGNED NOT NULL,\\n cpid VARCHAR NOT NULL,\\n phone INT NOT NULL,\\n content VARCHAR NOT NULL,\\n sendtime VARCHAR NOT NULL,\\n reportcode VARCHAR NOT NULL,\\n spnumber VARCHAR NOT NULL,\\n province VARCHAR NOT NULL,\\n city VARCHAR NOT NULL\\n) \\tCREATE TABLE t_mtcars_2591 (\\n model VARCHAR NULL,\\n mpg DOUBLE NULL,\\n cyl INT NULL,\\n disp DOUBLE NULL,\\n hp INT NULL,\\n drat DOUBLE NULL,\\n wt DOUBLE NULL,\\n qsec DOUBLE NULL,\\n vs INT NULL,\\n am INT NULL,\\n gear INT NULL,\\n carb INT NULL\\n) \\tCREATE TABLE t_parquet (\\n \\\"JOBID\\\" DECIMAL(12, 0) NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE t_path_to_output_parquet_file_3320 (\\n id BIGINT NULL,\\n traffic_info VARCHAR NULL\\n) \\tCREATE TABLE t_zsq (\\n a BOOLEAN NULL,\\n c VARCHAR NULL DEFAULT {\\\"Cast\\\":{\\\"input\\\":{\\\"Constant\\\":{\\\"value\\\":{\\\"String\\\":[104,105]},\\\"data_type\\\":{\\\"type\\\":\\\"String\\\"}}},\\\"target\\\":{\\\"type\\\":\\\"Nullable\\\",\\\"inner\\\":{\\\"type\\\":\\\"String\\\"}}}}\\n) \\tCREATE TABLE t_zsq_2 (\\n a VARCHAR NOT NULL,\\n b SMALLINT NOT NULL\\n) \\tCREATE TABLE tags_config (\\n tag_key INT NOT NULL,\\n tag_value SMALLINT NOT NULL,\\n frame_count INT NOT NULL,\\n percentage DOUBLE NULL\\n) \\tCREATE TABLE target_data (\\n id INT NULL,\\n data VARIANT NULL\\n) \\tCREATE TABLE task_execution_log (\\n task_name VARCHAR NULL,\\n execution_time TIMESTAMP NULL,\\n status VARCHAR NULL\\n) \\tCREATE TABLE task_trigger_events (\\n task_name VARCHAR NULL,\\n exec_time TIMESTAMP NULL DEFAULT CAST(now() AS Timestamp NULL)\\n) \\tCREATE TABLE tb01 (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL,\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE TABLE tb0325 (\\n id INT NULL,\\n c1 VARCHAR NULL\\n) \\tCREATE STREAM `tb0325_sp1` ON TABLE `default`.`tb0325`\\tCREATE TABLE tb_t (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL DEFAULT '中国人民银行',\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE TABLE tb_t_bak (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL DEFAULT '中国人民银行',\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE TABLE tbcc (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL DEFAULT '中国人民银行',\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE TABLE tbcc_bak (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL DEFAULT '中国人民银行',\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE STREAM `tbcc_s1` ON TABLE `default`.`tbcc`\\tCREATE TABLE test (\\n x INT NOT NULL,\\n y VARCHAR NOT NULL\\n) \\tCREATE TABLE test1111 (\\n a BOOLEAN NOT NULL\\n) \\tCREATE TABLE test_01 (\\n date DATE NOT NULL,\\n country VARCHAR NOT NULL,\\n state VARCHAR NOT NULL,\\n flip VARCHAR NOT NULL,\\n cases INT NOT NULL,\\n deaths INT NOT NULL\\n) \\tCREATE TABLE test_098_parquet (\\n \\\"JOBID\\\" VARCHAR NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE test_config (\\n task_name VARCHAR NULL,\\n database_name VARCHAR NULL,\\n table_name VARCHAR NULL,\\n is_active BOOLEAN NULL\\n) \\tCREATE TABLE test_cte_scope (\\n id INT NULL,\\n name VARCHAR NULL,\\n value INT NULL\\n) \\tCREATE TABLE test_data (\\n id INT NULL,\\n name VARCHAR NULL,\\n value INT NULL\\n) \\tCREATE TABLE test_date_range (\\n effective_start_date DATE NULL,\\n metric_type VARCHAR NULL\\n) \\tCREATE TABLE test_events (\\n task_name VARCHAR NULL,\\n exec_time TIMESTAMP NULL\\n) \\tCREATE TABLE test_ndjson_data (\\n id VARCHAR NULL,\\n timestamp VARCHAR NULL,\\n raw_data VARCHAR NULL,\\n record_metadata VARCHAR NULL\\n) \\tCREATE TABLE test_ndjson_import (\\n id VARCHAR NULL,\\n timestamp VARCHAR NULL,\\n raw_data VARCHAR NULL,\\n record_metadata VARCHAR NULL\\n) \\tCREATE TABLE test_ndjson_solution (\\n id VARCHAR NULL,\\n timestamp VARCHAR NULL,\\n raw_data VARCHAR NULL,\\n record_metadata VARCHAR NULL\\n) \\tCREATE TABLE test_parquet (\\n \\\"JOBID\\\" VARCHAR NULL,\\n \\\"JOBACCOUNT\\\" VARCHAR NULL\\n) \\tCREATE TABLE test_table1 (\\n id BIGINT NULL,\\n field1 VARCHAR NULL,\\n field2 VARCHAR NULL,\\n field3 VARCHAR NULL,\\n field4 VARCHAR NULL,\\n field5 VARCHAR NULL,\\n field6 VARCHAR NULL,\\n field7 VARCHAR NULL,\\n field8 VARCHAR NULL,\\n field9 VARCHAR NULL,\\n field10 VARCHAR NULL,\\n field11 VARCHAR NULL,\\n field12 VARCHAR NULL,\\n field13 VARCHAR NULL,\\n field14 VARCHAR NULL,\\n field15 VARCHAR NULL,\\n field16 VARCHAR NULL,\\n field17 VARCHAR NULL,\\n field18 VARCHAR NULL,\\n field19 VARCHAR NULL,\\n field20 VARCHAR NULL,\\n created_at TIMESTAMP NULL\\n) \\tCREATE TABLE testkv (\\n key VARCHAR NULL,\\n val INT NULL\\n) \\tCREATE TABLE time_check_log (\\n id INT NULL,\\n check_time TIMESTAMP NULL,\\n result VARCHAR NULL,\\n exec_time TIMESTAMP NULL\\n) \\tCREATE TABLE tmp_numbers (\\n number BIGINT UNSIGNED NOT NULL\\n) \\tCREATE TABLE tmp_random_tb_t (\\n id BIGINT NULL,\\n batch VARCHAR NULL,\\n name VARCHAR NULL,\\n birthday DATE NULL,\\n address VARCHAR NULL,\\n company VARCHAR NULL,\\n job VARCHAR NULL,\\n bank VARCHAR NULL DEFAULT '中国人民银行',\\n password VARCHAR NULL,\\n phone_number VARCHAR NULL,\\n user_agent VARCHAR NULL,\\n c1 VARCHAR NULL,\\n c2 VARCHAR NULL,\\n c3 VARCHAR NULL,\\n c4 VARCHAR NULL,\\n c5 VARCHAR NULL,\\n c6 VARCHAR NULL,\\n c7 VARCHAR NULL,\\n c8 VARCHAR NULL,\\n c9 VARCHAR NULL,\\n c10 VARCHAR NULL,\\n d DATE NULL,\\n t TIMESTAMP NULL\\n) \\tCREATE TABLE tmp_tb01 (\\n id INT NULL,\\n c1 VARCHAR NULL\\n) \\tCREATE TABLE tmp_tb_t (\\n number BIGINT UNSIGNED NOT NULL\\n) \\tCREATE TABLE user (\\n id INT NULL,\\n name VARCHAR NULL,\\n age INT NULL\\n) \\tCREATE TABLE user_behavior (\\n user_id BIGINT UNSIGNED NOT NULL,\\n item_id INT NULL,\\n category_id INT NULL,\\n behavior_type VARCHAR NULL,\\n ts TIMESTAMP NULL,\\n day DATE NULL\\n) \\tCREATE TABLE user_behavior_count (\\n user_id INT NULL,\\n pv BIGINT UNSIGNED NULL,\\n fav BIGINT UNSIGNED NULL,\\n cart BIGINT UNSIGNED NULL,\\n buy BIGINT UNSIGNED NULL\\n) \\tCREATE TABLE user_interests (\\n user_id INT NULL,\\n user_name VARCHAR NULL,\\n interests ARRAY(VARCHAR NULL) NULL,\\n scores ARRAY(INT NULL) NULL\\n) \\tCREATE TABLE user_scores (\\n user_id INT NULL,\\n username VARCHAR NULL,\\n score INT NULL,\\n last_updated TIMESTAMP NULL\\n) \\tCREATE VIEW `default`.`v_ontime` AS SELECT * FROM ontime LIMIT 10\\tCREATE TABLE vectors (\\n id INT NULL,\\n vec VECTOR(3) NULL,\\n SYNC VECTOR INDEX idx_vec (vec) distance = 'cosine'\\n) \\tCREATE TABLE visit_conventional (\\n visit_id BIGINT NOT NULL COMMENT '主键ID',\\n store_id BIGINT NOT NULL COMMENT '门店ID',\\n user_id BIGINT NOT NULL COMMENT '人员ID',\\n biz_date VARCHAR NOT NULL COMMENT '业务日期',\\n biz_date_day DATE NULL DEFAULT NULL COMMENT '业务日期(日期格式)',\\n in_type INT NULL DEFAULT 1 COMMENT '进店类型 1 正常打卡 2 异常打卡 3 异常打卡并更新门店定位 4 定位失败打卡 5 添加位置打卡',\\n in_time TIMESTAMP NULL DEFAULT NULL COMMENT '进店时间',\\n in_lat VARCHAR NULL DEFAULT NULL COMMENT '进店纬度',\\n in_lon VARCHAR NULL DEFAULT NULL COMMENT '进店经度',\\n last_in_lat VARCHAR NULL DEFAULT NULL COMMENT '上次进店纬度',\\n last_in_lon VARCHAR NULL DEFAULT NULL COMMENT '上次进店经度',\\n in_addr VARCHAR NULL DEFAULT NULL COMMENT '进店地址',\\n in_img_url VARCHAR NULL COMMENT '进店照片',\\n out_time TIMESTAMP NULL DEFAULT NULL COMMENT '离店时间',\\n out_lat VARCHAR NULL DEFAULT NULL COMMENT '离店纬度',\\n out_lon VARCHAR NULL DEFAULT NULL COMMENT '离店经度',\\n store_times DECIMAL(6, 0) NULL DEFAULT NULL COMMENT '在店时长',\\n store_times_second DECIMAL(10, 0) NULL DEFAULT NULL COMMENT '在店时长(秒)',\\n in_transit_second DECIMAL(10, 0) NULL DEFAULT NULL COMMENT '在途时长(秒)，进店时间减去上次离店时间',\\n reminder_id BIGINT NULL DEFAULT NULL COMMENT '下次业务提醒',\\n purpose_id VARCHAR NULL DEFAULT NULL COMMENT '本次拜访目的ID,字典项',\\n other_purpose VARCHAR NULL DEFAULT NULL COMMENT '其他拜访目的',\\n out_type INT NULL DEFAULT 1 COMMENT '离店类型 1 正常 2 外勤 3未结束拜访,跑批添加',\\n is_assist_visit VARCHAR NULL DEFAULT '0' COMMENT '是否协访 0正常 1路线辅导 2路线检查',\\n visited_user_id BIGINT NULL DEFAULT NULL COMMENT '被协访人Id',\\n owner_id BIGINT NULL DEFAULT NULL COMMENT '所属人',\\n owner_org_id BIGINT NULL DEFAULT NULL COMMENT '数据所属组织',\\n org_id BIGINT NULL DEFAULT NULL COMMENT '组织ID',\\n tenant_id BIGINT NULL DEFAULT NULL COMMENT '租户ID',\\n out_addr VARCHAR NULL DEFAULT NULL COMMENT '离店地址',\\n outside_reason VARCHAR NULL DEFAULT NULL COMMENT '异常原因',\\n out_img_url VARCHAR NULL COMMENT '离店照片',\\n inoutside_reason VARCHAR NULL DEFAULT NULL COMMENT '进店异常原因',\\n created_by BIGINT NULL DEFAULT NULL COMMENT '创建人',\\n created_time TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间',\\n updated_by BIGINT NULL DEFAULT NULL COMMENT '更新人',\\n updated_time TIMESTAMP NULL DEFAULT NULL COMMENT '更新时间',\\n upload_time TIMESTAMP NULL DEFAULT NULL COMMENT '离线上传时间',\\n in_distance DOUBLE NULL DEFAULT NULL COMMENT '进店偏差距离',\\n out_distance DOUBLE NULL DEFAULT NULL COMMENT '离店偏差距离',\\n is_offline VARCHAR NULL DEFAULT '0' COMMENT '是否离线数据 0非离线 1离线',\\n trace_id VARCHAR NULL DEFAULT NULL COMMENT '流程ID',\\n mobile_upload_date TIMESTAMP NULL DEFAULT NULL COMMENT '离线上传时间',\\n remark VARCHAR NULL DEFAULT NULL COMMENT '备注',\\n visit_state BIGINT NULL DEFAULT NULL COMMENT '拜访状态存放字典项中',\\n cancel_visit_cause BIGINT NULL DEFAULT NULL COMMENT '取消拜访原因',\\n is_last_visit_of_day INT NULL DEFAULT NULL COMMENT '是否当天最后一次拜访 0 = 否 1 = 是 ',\\n in_plan INT NULL DEFAULT NULL COMMENT '是否计划内 0 = 计划外 1 = 计划内',\\n route_date VARCHAR NULL DEFAULT NULL COMMENT '路线日期',\\n standard_point_error_in VARCHAR NULL DEFAULT NULL COMMENT '进店确认基准点有误 0无误 1有误',\\n interrupt_visit_id BIGINT NULL DEFAULT NULL COMMENT '中断拜访原因',\\n interrupt_remark VARCHAR NULL DEFAULT NULL COMMENT '中断拜访说明',\\n next_visit_remind VARCHAR NULL DEFAULT NULL COMMENT '离店备注',\\n assist_visit_type INT NULL DEFAULT NULL COMMENT '协访类型 1 = 协同拜访， 2 = 内审随访',\\n remind_reply VARCHAR NULL DEFAULT NULL,\\n remind_reply_user BIGINT NULL DEFAULT NULL,\\n remind_reply_time TIMESTAMP NULL DEFAULT NULL\\n) \\tCREATE TABLE web_traffic_data (\\n id BIGINT NULL,\\n traffic_info MAP(VARCHAR NOT NULL, VARCHAR NOT NULL) NULL\\n) \\tCREATE TABLE web_traffic_data02 (\\n id BIGINT NULL,\\n traffic_info MAP(VARCHAR NOT NULL, VARCHAR NULL) NULL\\n) \\tCREATE TABLE web_traffic_data03 (\\n id BIGINT NULL,\\n traffic_info MAP(VARCHAR NOT NULL, VARCHAR NULL) NULL\\n) \\tCREATE TABLE web_traffic_data05 (\\n id BIGINT NULL,\\n traffic_info MAP(VARCHAR NOT NULL, VARCHAR NULL) NULL\\n) \\tCREATE TABLE xx3490 (\\n acd VARIANT NULL\\n) \\tCREATE TABLE xx490 (\\n acd FLOAT NULL\\n) \u003c/create_table_schemas\u003e\\n \",\"stream\":true}","request_id":"aaeed8cf0f2a8512a88baf6f32efdedd","request_method":"POST","request_uri":"/api/v1/query/orgs/orgchasen-slug-test/optimize-errors","status":200,"time":"2026-02-11T12:03:31Z","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36"}