landing-page/content/services/time-travel.html (19 lines of code) (raw):

--- Title: Time Travel and Rollback Description: Time-travel enables reproducible queries that use exactly the same table snapshot, or lets users easily examine changes. Version rollback allows users to quickly correct problems by resetting tables to a good state. LearnMore: /docs/latest/spark-queries/#time-travel Category: Post Draft: false weight: 4 excludeFromSearch: true --- <!-- - Licensed to the Apache Software Foundation (ASF) under one or more - contributor license agreements. See the NOTICE file distributed with - this work for additional information regarding copyright ownership. - The ASF licenses this file to You under the Apache License, Version 2.0 - (the "License"); you may not use this file except in compliance with - the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. --> <div class="termynal-container"> <div id="termynal-time-travel" data-termynal data-ty-startDelay="6000" data-ty-typeDelay="20" data-ty-lineDelay="500"> <span data-ty="input" data-ty-cursor="▋" data-ty-prompt="sql>">SELECT count(*) FROM nyc.taxis</span> <span data-ty>2,853,020</span> <span data-ty="input" data-ty-cursor="▋" data-ty-prompt="sql>">SELECT count(*) FROM nyc.taxis FOR VERSION AS OF 2188465307835585443</span> <span data-ty>2,798,371</span> <span data-ty="input" data-ty-cursor="▋" data-ty-prompt="sql>">SELECT count(*) FROM nyc.taxis FOR TIMESTAMP AS OF TIMESTAMP '2022-01-01 00:00:00.000000 Z'</span> <span data-ty>2,798,371</span> </div> </div>