{"record":{"id":"c99576873931a353","repo":"risingwavelabs/risingwave","slug":"cannot-find-lat-name-please-set-it-or-use-jso","errorCode":null,"errorMessage":"Cannot find `{LAT_NAME}`, please set it or use JSON or set `{REDIS_VALUE_TYPE}` to `{REDIS_VALUE_TYPE_STRING}`","messagePattern":"Cannot find `(.+?)`, please set it or use JSON or set `(.+?)` to `(.+?)`","errorType":"validation","errorClass":"SinkError::Config","httpStatus":null,"severity":"error","filePath":"src/connector/src/sink/redis.rs","lineNumber":380,"sourceCode":"                            ))\n                        })?;\n                    TemplateStringEncoder::check_string_format(value_format, &all_map)?;\n                }\n                Some(REDIS_VALUE_TYPE_GEO) => {\n                    let key_format = self.format_desc.options.get(KEY_FORMAT).ok_or_else(|| {\n                        SinkError::Config(anyhow!(\n                            \"Cannot find '{KEY_FORMAT}', please set it or use JSON\"\n                        ))\n                    })?;\n                    TemplateStringEncoder::check_string_format(key_format, &pk_map)?;\n\n                    let lon_name = self.format_desc.options.get(LON_NAME).ok_or_else(|| {\n                        SinkError::Config(anyhow!(\n                            \"Cannot find `{LON_NAME}`, please set it or use JSON or set `{REDIS_VALUE_TYPE}` to `{REDIS_VALUE_TYPE_STRING}`\"\n                        ))\n                    })?;\n                    let lat_name = self.format_desc.options.get(LAT_NAME).ok_or_else(|| {\n                        SinkError::Config(anyhow!(\n                            \"Cannot find `{LAT_NAME}`, please set it or use JSON or set `{REDIS_VALUE_TYPE}` to `{REDIS_VALUE_TYPE_STRING}`\"\n                        ))\n                    })?;\n                    let member_name = self.format_desc.options.get(MEMBER_NAME).ok_or_else(|| {\n                        SinkError::Config(anyhow!(\n                            \"Cannot find `{MEMBER_NAME}`, please set it or use JSON or set `{REDIS_VALUE_TYPE}` to `{REDIS_VALUE_TYPE_STRING}`\"\n                        ))\n                    })?;\n                    if let Some(lon_type) = all_map.get(lon_name)\n                        && (lon_type == &DataType::Float64\n                            || lon_type == &DataType::Float32\n                            || lon_type == &DataType::Varchar)\n                    {\n                        // do nothing\n                    } else {\n                        return Err(SinkError::Config(anyhow!(\n                            \"`{LON_NAME}` must be set to `float64` or `float32` or `varchar`\"\n                        )));","sourceCodeStart":362,"sourceCodeEnd":398,"githubUrl":"https://github.com/risingwavelabs/risingwave/blob/6469eb736d691e8e9b8a419a57edd6429ca77417/src/connector/src/sink/redis.rs#L362-L398","documentation":"A Redis geospatial sink (template encoding, redis_value_type='geospatial') requires the `latitude` option naming the column that holds latitude. RedisSink::validate raises this SinkError::Config when `latitude` is missing, suggesting setting it, using JSON encoding, or switching to the string value type.","triggerScenarios":"CREATE SINK with encode template, redis_value_type = 'geospatial', with key_format and longitude set but no `latitude = '<column>'` option (src/connector/src/sink/redis.rs:379-383).","commonSituations":"GEO sink configs that specify longitude/member but omit latitude; typos like `lat`; assuming longitude alone suffices for GEOADD.","solutions":["Add `latitude = '<column_name>'` to the sink options","Or change redis_value_type to 'string' if GEO semantics are not needed","Or use a JSON encoding which does not require this option"],"exampleFix":"-- before\n... encode template (redis_value_type = 'geospatial', key_format = 'geo::{pk}', longitude = 'lon', member = 'm')\n-- after\n... encode template (redis_value_type = 'geospatial', key_format = 'geo::{pk}', longitude = 'lon', latitude = 'lat', member = 'm')","handlingStrategy":"validation","validationCode":"-- for redis_value_type='geospatial', verify latitude option present and column exists:\n-- options.contains_key(\"latitude\") && schema.contains(options[\"latitude\"])","typeGuard":null,"tryCatchPattern":"match result.err() { Some(e) if e.contains(\"latitude\") => add_option(\"latitude\", numeric_column), _ => propagate(result) }","preventionTips":["Set longitude, latitude, and member options together","Verify column names against the sink schema before DDL","Use a checked config template for GEO sinks"],"tags":["redis","sink","configuration","geospatial"],"backgroundTag":"missing-required-config-field","analyzedSha":"6469eb736d691e8e9b8a419a57edd6429ca77417","analyzedAt":"2026-09-11T21:06:21.487Z","contentChangedAt":"2026-09-11T21:06:21.487Z","schemaVersion":2},"datasetVersion":"2026-09-23T08:17:48.524Z"}