[#5631] Add test cases for other supported catalogs in Trino Cascading

[danhuawang]

What changes were proposed in this pull request?

1. Trino connector: add some external table type test cases in hive catalog.
2. Cascading connector: Add cases to cover hive,PG,Iceberg catalogs.
3. Some test cases can't pass on the Trino cascading v0.0.1, I move to "ignored" directory.

Why are the changes needed?

In trino-cascading-testsets, it only covered MySQL catalog. We need to add more test cases for other supported catalogs.

Fix: #5631

Does this PR introduce any user-facing change?

N/A

How was this patch tested?

./gradlew -PskipTests -PtestMode=embedded -PjdkVersion=17 -PskipDockerTests=false :trino-connector:integration-test:test

./gradlew -PskipTests -PtestMode=deploy -PjdkVersion=17 -PskipDockerTests=false :trino-connector:integration-test:test

trino-connector/integration-test/trino-test-tools/run_test.sh

2024-11-20 19:39:05 INFO  [main] TrinoQueryIT:402 - All testers have finished. Total:116, Pass: 116
hive:hive/00001_datatype.sql, PASS, 4.743, 
iceberg:lakehouse-iceberg-hive/00002_partition_sort_order.sql, PASS, 4.042, 
iceberg_mysql:lakehouse-iceberg-mysql/00002_partition_sort_order.sql, PASS, 1.614, 
iceberg_postgres:lakehouse-iceberg-postgres/00002_partition_sort_order.sql, PASS, 3.290, 
mysql:jdbc-mysql/00001_datatype.sql, PASS, 1.753, 
mysql:jdbc-mysql/00002_pushdown.sql, PASS, 1.095, 
mysql:jdbc-mysql/catalog_mysql_cascading_test.sql, PASS, 0.207, 
mysql:tpcds/00000.sql, PASS, 16.305, 
mysql:tpcds/00001.sql, PASS, 1.036, 
mysql:tpcds/00002.sql, PASS, 1.954, 
mysql:tpcds/00003.sql, PASS, 0.795, 
mysql:tpcds/00004.sql, PASS, 3.311, 
mysql:tpcds/00005.sql, PASS, 2.008, 
mysql:tpcds/00006.sql, PASS, 1.282, 
mysql:tpcds/00007.sql, PASS, 1.439, 
....
mysql:tpch/00021.sql, PASS, 1.336, 
mysql:tpch/00022.sql, PASS, 0.536, 
pg:jdbc-postgresql/00001_datatype.sql, PASS, 1.259, 
pg:jdbc-postgresql/00002_pushdown.sql, PASS, 1.583, 
pg:jdbc-postgresql/catalog_pg_cascading_test.sql, PASS, 0.217, 
All testers have finished. Total:116, Pass: 116

[danhuawang]

@diqiu50 Can you help review this PR?