@Test
  public void testSelectAsOfCurrentTimestampAndInterval() throws IOException, InterruptedException {
    testTables.createTableWithVersions(shell, "customers",
        HiveIcebergStorageHandlerTestUtils.CUSTOMER_SCHEMA, fileFormat,
        HiveIcebergStorageHandlerTestUtils.CUSTOMER_RECORDS, 3);

    List<Object[]> rows = shell.executeStatement("SELECT * FROM " +
        "customers FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP + interval '10' hours");

    Assert.assertEquals(5, rows.size());
  }
Tests covering the time travel feature, aka reading from a table as of a certain snapshot.
iceberg/iceberg-handler/src/test/java/org/apache/iceberg/mr/hive/TestHiveIcebergTimeTravel.java