github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/04_CLEANUP/02_Snapshot.sql (about)

     1  -- account level snapshot
     2  select count(*) from tpch.customer {snapshot = 'tpch_snapshot'};
     3  select count(*) from tpch.customer {snapshot = 'tpch_snapshot'};
     4  select count(*) from tpch.customer {snapshot = 'tpch_snapshot'};
     5  select count(*) from tpch.customer {snapshot = 'tpch_snapshot'};
     6  select count(*) from tpch.customer {snapshot = 'tpch_snapshot'};
     7  
     8  select count(*) from tpch.lineitem {snapshot = 'tpch_snapshot'};
     9  select count(*) from tpch.lineitem {snapshot = 'tpch_snapshot'};
    10  select count(*) from tpch.lineitem {snapshot = 'tpch_snapshot'};
    11  select count(*) from tpch.lineitem {snapshot = 'tpch_snapshot'};
    12  select count(*) from tpch.lineitem {snapshot = 'tpch_snapshot'};
    13  
    14  select count(*) from tpch.nation {snapshot = 'tpch_snapshot'};
    15  select count(*) from tpch.nation {snapshot = 'tpch_snapshot'};
    16  select count(*) from tpch.nation {snapshot = 'tpch_snapshot'};
    17  select count(*) from tpch.nation {snapshot = 'tpch_snapshot'};
    18  select count(*) from tpch.nation {snapshot = 'tpch_snapshot'};
    19  
    20  select count(*) from tpch.orders {snapshot = 'tpch_snapshot'};
    21  select count(*) from tpch.orders {snapshot = 'tpch_snapshot'};
    22  select count(*) from tpch.orders {snapshot = 'tpch_snapshot'};
    23  select count(*) from tpch.orders {snapshot = 'tpch_snapshot'};
    24  select count(*) from tpch.orders {snapshot = 'tpch_snapshot'};
    25  
    26  select count(*) from tpch.part {snapshot = 'tpch_snapshot'};
    27  select count(*) from tpch.part {snapshot = 'tpch_snapshot'};
    28  select count(*) from tpch.part {snapshot = 'tpch_snapshot'};
    29  select count(*) from tpch.part {snapshot = 'tpch_snapshot'};
    30  select count(*) from tpch.part {snapshot = 'tpch_snapshot'};
    31  
    32  select count(*) from tpch.partsupp {snapshot = 'tpch_snapshot'};
    33  select count(*) from tpch.partsupp {snapshot = 'tpch_snapshot'};
    34  select count(*) from tpch.partsupp {snapshot = 'tpch_snapshot'};
    35  select count(*) from tpch.partsupp {snapshot = 'tpch_snapshot'};
    36  select count(*) from tpch.partsupp {snapshot = 'tpch_snapshot'};
    37  
    38  select count(*) from tpch.supplier {snapshot = 'tpch_snapshot'};
    39  select count(*) from tpch.supplier {snapshot = 'tpch_snapshot'};
    40  select count(*) from tpch.supplier {snapshot = 'tpch_snapshot'};
    41  select count(*) from tpch.supplier {snapshot = 'tpch_snapshot'};
    42  select count(*) from tpch.supplier {snapshot = 'tpch_snapshot'};
    43  
    44  -- cluster level snapshot
    45  select count(*) from tpch.customer {snapshot = 'tpch_cluster'};
    46  select count(*) from tpch.customer {snapshot = 'tpch_cluster'};
    47  select count(*) from tpch.customer {snapshot = 'tpch_cluster'};
    48  select count(*) from tpch.customer {snapshot = 'tpch_cluster'};
    49  select count(*) from tpch.customer {snapshot = 'tpch_cluster'};
    50  
    51  select count(*) from tpch.lineitem {snapshot = 'tpch_cluster'};
    52  select count(*) from tpch.lineitem {snapshot = 'tpch_cluster'};
    53  select count(*) from tpch.lineitem {snapshot = 'tpch_cluster'};
    54  select count(*) from tpch.lineitem {snapshot = 'tpch_cluster'};
    55  select count(*) from tpch.lineitem {snapshot = 'tpch_cluster'};
    56  
    57  select count(*) from tpch.nation {snapshot = 'tpch_cluster'};
    58  select count(*) from tpch.nation {snapshot = 'tpch_cluster'};
    59  select count(*) from tpch.nation {snapshot = 'tpch_cluster'};
    60  select count(*) from tpch.nation {snapshot = 'tpch_cluster'};
    61  select count(*) from tpch.nation {snapshot = 'tpch_cluster'};
    62  
    63  select count(*) from tpch.orders {snapshot = 'tpch_cluster'};
    64  select count(*) from tpch.orders {snapshot = 'tpch_cluster'};
    65  select count(*) from tpch.orders {snapshot = 'tpch_cluster'};
    66  select count(*) from tpch.orders {snapshot = 'tpch_cluster'};
    67  select count(*) from tpch.orders {snapshot = 'tpch_cluster'};
    68  
    69  select count(*) from tpch.part {snapshot = 'tpch_cluster'};
    70  select count(*) from tpch.part {snapshot = 'tpch_cluster'};
    71  select count(*) from tpch.part {snapshot = 'tpch_cluster'};
    72  select count(*) from tpch.part {snapshot = 'tpch_cluster'};
    73  select count(*) from tpch.part {snapshot = 'tpch_cluster'};
    74  
    75  select count(*) from tpch.partsupp {snapshot = 'tpch_cluster'};
    76  select count(*) from tpch.partsupp {snapshot = 'tpch_cluster'};
    77  select count(*) from tpch.partsupp {snapshot = 'tpch_cluster'};
    78  select count(*) from tpch.partsupp {snapshot = 'tpch_cluster'};
    79  select count(*) from tpch.partsupp {snapshot = 'tpch_cluster'};
    80  
    81  select count(*) from tpch.supplier {snapshot = 'tpch_cluster'};
    82  select count(*) from tpch.supplier {snapshot = 'tpch_cluster'};
    83  select count(*) from tpch.supplier {snapshot = 'tpch_cluster'};
    84  select count(*) from tpch.supplier {snapshot = 'tpch_cluster'};
    85  select count(*) from tpch.supplier {snapshot = 'tpch_cluster'};