Fixes the outdated description of Key Generation and Hadoop in HiveServer2 integration doc

[linghengqian]

For #29052.

Changes proposed in this pull request:

• Fixes the outdated description of Key Generation and Hadoop in HiveServer2 integration doc. Also for #33717 .
• Fix documentation on incorrect description of key generation using shardingsphere under HiveServer2. This seems to be fixed in an unknown commit.
• Fix documentation on incorrect description of Hadoop version. HiveServer2 4.0.1 fixes the bug that HiveServer2 4.0.0 needs to introduce an additional org.apache.hadoop:hadoop-client-api:3.3.6. See https://github.com/apache/hive/pull/5313 and https://github.com/linghengqian/hive-server2-jdbc-driver/pull/10 .
• Modify nativeTest's use of h2database one-time connections to align with h2database's documentation examples. See https://h2database.com/html/quickstart.html.
• As a follow-up to https://github.com/apache/shardingsphere/discussions/32742, all actualDataNodes in nativeTest have been explicitly configured, because implicit configuration is not intuitive.

• Even though the iceberg table format supports transactions, hiveserver2 doesn't seem to care about this at all. And the transaction rollback syntax of iceberg is completely different from other databases. See https://iceberg.apache.org/docs/latest/hive/#table-rollback and org.apache.hive.jdbc.HiveConnection#rollback(). Hive's handling is a bit humorous.

  /*
  * (non-Javadoc)
  *
  * @see java.sql.Connection#rollback()
  */
  
  @Override
  public void rollback() throws SQLException {
  // TODO Auto-generated method stub
  throw new SQLFeatureNotSupportedException("Method not supported");
  }

---

Before committing this PR, I'm sure that I have checked the following options:

• [X] My code follows the code of conduct of this project.
• [X] I have self-reviewed the commit code.
• [X] I have (or in comment I request) added corresponding labels for the pull request.
• [x] I have passed maven check locally : ./mvnw clean install -B -T1C -Dmaven.javadoc.skip -Dmaven.jacoco.skip -e.
• [x] I have made corresponding changes to the documentation.
• [x] I have added corresponding unit tests for my changes.
• [ ] I have updated the Release Notes of the current development version. For more details, see Update Release Note