wants to delete this PROD_SIG
# support
a
wants to delete this PROD_SIG
a
can you create a github issue for this? I will reply there. It will help others also 🙂
a
Where I can create that?
a
I have created the issue
Can u please help me with that asap?
a
do you want to remove all the timeseries that has that label?
a
I just want to remove that PROD_SIG in there right
I wants to remove that value
a
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
how I can login to signoz db?
from linux machine..
a
which DB is by default over there?
a
you need to connect to clickhouse using the docs
db and table to work on is part of the query I shared
a
Ok thanks,
I will check
Thanks for your help
a
👍
a
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?