Stack Overflow
Stack Overflow

Questions tagged [point-in-time]

27 questions
1
vote
2 answers

Point-In-Time Cassandra backup & recovery

I have read about Cassandra backup & recovery here, and have a few questions: Do the native Cassandra CLI commands suffice? I see a lot of people writing scripts and custom-making their own solutions. What other tools out there would you recommend…
Desmond Chan
  • 11
  • 2
0
votes
0 answers

In opensearch while I use point in time pagination method, I was unable to get more than 10000 hits why?

I use 2.6 version with "point_in_time_full_access" have allowed actions as "manage_point_in_time". I was able to create PIT but while search I was unable to give size more than 10000. I was expecting to get hits more than 10K
Sundar Murugan
  • 1
0
votes
1 answer

Restore Azure Mysql point-in-time failing due to timeout

I'm trying to do a point-in-time restore of my Azure MySQL database. I pick the current date/time, so it's well within the retention period. It's failing with the following error: The resource provision operation did not complete within the…
Wessel Oosthuizen
  • 73
  • 11
0
votes
0 answers

How to connect Point in Time api with opensearch using Java client for performRequest()

I have to call Point in Time like //_search/point_in_time?keep_alive=1h&routing=&expand_wildcards=&preference= using java client API of OpenSearch I have tried to create the client using the java client API. Though after that I want…
CodingPolygolots
  • 1
  • 2
0
votes
1 answer

Elasticsearch collapse not working with search_after with single sort field and PIT

I have an Elastic query that initially returns results. When I attempt the query again using search_after for paging, I am getting the error: Cannot use [collapse] in conjunction with [search_after] unless the search is sorted on the same field.…
Reese Allison
  • 43
  • 1
  • 6
0
votes
2 answers

Fetch data from a middle of a big stack using searchAfter(jump to a specific page,)

I have a large data set around 25million records I am using searchAfter with PointInTime to walk through the data My question is there a way where I can skip records over the limit of 10000 index.max_result_window and start picking the records for…
Noa
  • 315
  • 1
  • 7
  • 31
0
votes
1 answer

How can I iteratively "INSERT INTO {table} SELECT FROM".... for a range of dates?

I am working on a building a Data Vault Temporal Point in Time (TPIT) table. For this I need to iterate through a list of dates and insert rows for each Date. Here is the SQL for one Date '2020-08-19' . I need to iterate over all dates from year…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
0 answers

Does SYSTEM_VERSIONING alone give old snapshots of data?

I am new to temporal tables. We have the following table in the database with which we would like to keep track of the CLV values of the customer in time. Here is the CREATE script of the table: CREATE TABLE [ana].[CLV]( [CustomerID]…
disasterkid
  • 6,948
  • 25
  • 94
  • 179
0
votes
2 answers

Getting Table Results based on a Start and End Date using a single date

Currently I am having trouble trying to query a data set that contains multiple records for unique customers. Each row has a start date and end date and the most recent record marked as Most Current and end date as 12/31/9999. I am trying to write a…
Pythonnoob12
  • 3
  • 4
-1
votes
1 answer

SQL Query for Latest Snapshot From Bitemporal Data

Given a table of data with bitemporal modeling, where there are 2 dates: (i) the date that the data applies to, and (ii) the date at which the fact was known. City Temperature Date As_of_Datetime ---- ----------- ---- …
Ramón J Romero y Vigil
  • 17,373
  • 7
  • 77
  • 125
-1
votes
1 answer

Number generator in time

:) I need a program in java, what will generate random numbers in time. Rage of random numbers is 1-100. If there will be sequence of numbers 1,50 and 95, program will stop and in the output must be written count of all random generated numbers,…
Patrik Siman
  • 1
-1
votes
2 answers

Restor sql server database to point in time useing full backup

I take a full backup of my DB at 12:00 pm, then i made some changes between 12:00 pm and 03:00 pm. Can i restore my DB to 02:00 pm using the full backup i take, and how.
Ibrahim Zakarya
  • 1
  • 1
1
2