Stack Overflow
Stack Overflow

Questions tagged [retention]

When data is to be retained, downsampled, or eliminated from a: database, filesystem or other storage device use 'retention'.

203 questions
2
votes
1 answer

Azure table storage Retention Policy

Working with Azure storage, I can of course set the retention policy for blobs. But I would like to learn if there's possibility to set retention policy over Azure table storage. and the only article I found on Microsoft documentation was this one.…
Afflatus
  • 933
  • 1
  • 12
  • 39
2
votes
1 answer

Create custom method level annotation only available to specific return types [AOP]

I want to create an annotation which is only available to a specific type of return values. For example this is my annotation. @Retention(RetentionPolicy.RUNTIME) @Target({ElementType.METHOD}) public @interface MyAnnotation { } I also have an…
cagdasalagoz
  • 460
  • 1
  • 12
  • 22
2
votes
1 answer

MySQL query calculate user retention in a certain date-range

I'm trying to select the count of users retaining in a certain date range and that was successful using this query and the table below: +----------+-------------+ | Field | Type | +----------+-------------+ | id | varchar(17) | |…
HHSE123
  • 67
  • 10
2
votes
2 answers

Is there any way to delete logic app run history / logs?

Is there any way to delete all the Run history logs from a logic app. I know there is a preview on "Log Retention Time" right now being tested but the most frequent time to delete all logs is once every week. I need to be able to do it more…
H4p7ic
  • 1,669
  • 2
  • 32
  • 61
2
votes
1 answer

HPE Vertica live aggregate projection example for user retention

create table events( id char(36) PRIMARY KEY, game_id varchar(24) not null, user_device_id char(36) not null, event_name varchar(100) not null, generated_at timestamp with time zone not null ); SELECT …
Prata
  • 1,250
  • 2
  • 16
  • 31
2
votes
0 answers

Calculating Fast Product Usage Intervals (Funnel Conversions) in Vertica SQL

I've got a massive dataset (~30 billion rows): host_id | usr_id | src_id | visit_num | event_ts where any user from their parent host can visit a page on a source (src_id), where the source is, say, their phone, tablet, or computer…
boldbrandywine
  • 322
  • 1
  • 14
2
votes
4 answers

Cohort/ Retention query in BigQuery using Google Analytics exported data

I need help formulating a cohort/retention query I am trying to build a query to look at visitors who performed ActionX on their first visit (in the time frame) and then how many days later they returned to perform Action X again The output I…
Shaz
  • 39
  • 1
  • 3
2
votes
1 answer

Resolving "Failed to parse input string" error in BigQuery

I'm working on a cohort analysis where I count the number of users who signed up by week, then count the number of events each perform over subsequent weeks. (Pretty standard stuff!) After spending a lot of time understanding BigQuery nesting and…
Karen Clark
  • 166
  • 2
  • 4
  • 12
2
votes
0 answers

how to implement database retention in MongoDB

Say I have a MongoDB instance and I want my data to be automatically deleted if it expires after 90 days or 30 days. Say my data are just stock market stock prices updated/inserted every 5 seconds. What's the best ways/method to do that? I can use…
Xianlin
  • 1,139
  • 5
  • 20
  • 34
2
votes
1 answer

SQL Retention query

I'm a complete newbie in sql (and any kind of coding), but I'm trying to write a basic query that would return, by country, the number of users who logged in for the first time after august 15th, and the number of users who came back on the day…
QuiZzer
  • 23
  • 3
1
vote
2 answers

How to prevent a user to insert a file into AWS S3 bucket if a file with the same name already exists in the bucket?

I need to configure my s3 bucket in a way that when a user inserts a file into the bucket which already exists in the bucket it should block the user inserting that file. I thought of implementing an object block with a retention policy on the…
user34534
  • 21
  • 5
1
vote
1 answer

Limit retention in MongoDB Atlas oplog

I have a small dataset stored in MongoDB Atlas with very low write activity. This yields an oplog window of 1.5 years! I have short retention policies, but if I have essentially a point-in-time restore going back over a year then they aren't much…
Michael Haren
  • 105,752
  • 40
  • 168
  • 205
1
vote
0 answers

Obtaining a bucket retention period with golang and InfluxDB

fellow programmers, I have a use case where I run a influxDB instance in another container (and possibly host) for the purpose of collecting some data. I would want to obtain the retention period of the InfluxDB bucket before writing to it, so that…
Victoria Kraleva
  • 11
  • 2
1
vote
1 answer

Kafka persistent storage is growing, though cleanup and retention policies are set

We are seeing a steady growth in the persistent storage for Kafka, around 10% per day - effectively implying the configs are not tuned. There are 3 brokers and 5 topics. Retention was configured for 2 hours. Following are the config parameters set…
prof
  • 21
  • 3
1
vote
1 answer

postgres simple churn/retention

I'm trying to create a simple user retention, I tried a lot of ways searching, but none of them seems efficient and most of them have a lot of calculations that I don't really need. Input my table…
automation_m
  • 61
  • 7
1 2
3
…
13 14