{"record":{"id":"c8c27ebe5b529ff4","repo":"risingwavelabs/risingwave","slug":"cannot-find-member-name-please-set-it-or-use","errorCode":null,"errorMessage":"Cannot find `{MEMBER_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":385,"sourceCode":"                    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                        )));\n                    }\n                    if let Some(lat_type) = all_map.get(lat_name)\n                        && (lat_type == &DataType::Float64\n                            || lat_type == &DataType::Float32\n                            || lat_type == &DataType::Varchar)","sourceCodeStart":367,"sourceCodeEnd":403,"githubUrl":"https://github.com/risingwavelabs/risingwave/blob/6469eb736d691e8e9b8a419a57edd6429ca77417/src/connector/src/sink/redis.rs#L367-L403","documentation":"A Redis geospatial sink (template encoding, redis_value_type='geospatial') requires the `member` option naming the primary-key varchar column used as the GEOSET member. RedisSink::validate throws this SinkError::Config when `member` is absent, telling the user to set it, use JSON encoding, or switch redis_value_type to 'string'.","triggerScenarios":"CREATE SINK with encode template, redis_value_type = 'geospatial', with key_format/longitude/latitude set but no `member = '<column>'` option (src/connector/src/sink/redis.rs:384-388).","commonSituations":"GEO sink configs missing the member option entirely; confusing `member` with a column alias; typos such as `member_name` in the SQL option list.","solutions":["Add `member = '<pk_column_name>'` to the sink options, naming a varchar primary-key column","Or switch 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', latitude = 'lat')\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 member option present:\n-- options.contains_key(\"member\") && schema.contains(options[\"member\"])","typeGuard":null,"tryCatchPattern":"match result.err() { Some(e) if e.contains(\"member\") => add_option(\"member\", pk_varchar_column), _ => propagate(result) }","preventionTips":["Include member (varchar PK column) in every GEO sink option set","Ensure the upstream table/mv declares a primary key","Keep a canonical working GEO sink example for reference"],"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"}