@Test
  public void testInvalidSelectAsOfTimestampExpression() throws IOException, InterruptedException {
    Table icebergTable = testTables.createTableWithVersions(shell, "customers",
        HiveIcebergStorageHandlerTestUtils.CUSTOMER_SCHEMA, fileFormat,
        HiveIcebergStorageHandlerTestUtils.CUSTOMER_RECORDS, 3);
    icebergTable.updateSchema().addColumn("create_time", Types.TimestampType.withZone()).commit();

    Assert.assertThrows(IllegalArgumentException.class, () -> shell.executeStatement("SELECT * FROM " +
        "customers FOR SYSTEM_TIME AS OF create_time - interval '10' hours"));
  }
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