https://signoz.io logo
#support
Title
# support
a

Ankita Salunkhe

11/24/2022, 9:31 AM
wants to delete this PROD_SIG
a

Ankit Nayan

11/24/2022, 9:40 AM
can you create a github issue for this? I will reply there. It will help others also 🙂
a

Ankita Salunkhe

11/24/2022, 10:02 AM
Where I can create that?
a

Ankita Salunkhe

11/24/2022, 10:13 AM
I have created the issue
Can u please help me with that asap?
a

Ankit Nayan

11/24/2022, 10:14 AM
do you want to remove all the timeseries that has that label?
a

Ankita Salunkhe

11/24/2022, 10:32 AM
I just want to remove that PROD_SIG in there right
I wants to remove that value
a

Ankit Nayan

11/24/2022, 10:32 AM
Copy code
alter table  signoz_metrics.time_series_v2 delete where metric_name='signoz_calls_total' and JSONExtractString(labels, 'resource_deployment_environment')='PROD_SIG';
a

Ankita Salunkhe

11/24/2022, 10:33 AM
how I can login to signoz db?
from linux machine..
a

Ankita Salunkhe

11/24/2022, 10:33 AM
which DB is by default over there?
a

Ankit Nayan

11/24/2022, 10:33 AM
you need to connect to clickhouse using the docs
db and table to work on is part of the query I shared
a

Ankita Salunkhe

11/24/2022, 10:34 AM
Ok thanks,
I will check
Thanks for your help
a

Ankit Nayan

11/24/2022, 10:34 AM
👍
a

Ankita Salunkhe

11/25/2022, 7:24 AM
Hii @Ankit Nayan
Good Afternoon
Can u please help me with update query
instead of delete I wants to update that entries.. if we delete the data from database it will have some mistach so I wants to update that entries..
I tried to update but its not working
can u please share me the update query for same?