J Parin
08/14/2025, 8:30 AMALTER TABLE signoz_logs.logs_v2
DELETE WHERE resources_string['service.name'] = 'local-host';
ALTER TABLE signoz_traces.signoz_index_v2
DELETE WHERE serviceName = 'local-host';
ALTER TABLE signoz_metrics.time_series_v2
DELETE WHERE JSONExtractString(labels, 'service_name') = 'local-host';
but after this the service name 'local-host' is still displaying in the service name list.
maybe someone knows how to remove it.
Thank youHien Le
08/14/2025, 4:56 PMGET /api/v3/autocomplete/attribute_values?aggregateOperator=noop&dataSource=logs&aggregateAttribute=&attributeKey=k8s.deployment.name&searchText=&filterAttributeKeyDataType=string&tagType=resource
Searched Github for that handler, followed the handler to the DB queries. You may want to check these other tables:
defaultLogAttributeKeysTable string = "distributed_logs_attribute_keys"
defaultLogResourceKeysTable string = "distributed_logs_resource_keys"
defaultLogTagAttributeTableV2 string = "distributed_tag_attributes_v2"
Hien Le
08/14/2025, 5:47 PM