roryqi commented on issue #10698: URL: https://github.com/apache/gravitino/issues/10698#issuecomment-4197456996
> USE CATALOG is not spark syntax. I show in the ticket that USE works on hive and postgres catalogs, but the Iceberg connector does not work. > > spark-sql (default)> use hive_nyc ; Time taken: 0.042 seconds spark-sql ()> use nyc_taxi; Time taken: 0.15 seconds spark-sql (nyc_taxi)> show tables; yellow_trips Time taken: 0.096 seconds, Fetched 1 row(s) spark-sql (nyc_taxi)> use postgres_demo; Time taken: 0.01 seconds spark-sql ()> use sales; Time taken: 0.021 seconds spark-sql (sales)> show tables; customers orders products Time taken: 0.025 seconds, Fetched 3 row(s) > > spark-sql (sales)> use spark_catalog; Time taken: 0.01 seconds spark-sql (default)> use iceberg_nyc; 26/04/07 07:57:16 WARN ObjectStore: Failed to get database iceberg_nyc, returning NoSuchObjectException [SCHEMA_NOT_FOUND] The schema `iceberg_nyc` cannot be found. Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a catalog, verify the current_schema() output, or qualify the name with the correct catalog. To tolerate the error on drop use DROP SCHEMA IF EXISTS. spark-sql (default)> use nyc_taxi; 26/04/07 07:57:25 WARN ObjectStore: Failed to get database nyc_taxi, returning NoSuchObjectException [SCHEMA_NOT_FOUND] The schema `nyc_taxi` cannot be found. Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a catalog, verify the current_schema() output, or qualify the name with the correct catalog. To tolerate the error on drop use DROP SCHEMA IF EXISTS. spark-sql (default)> show tables; Time taken: 0.014 seconds spark-sql (default)> I got it. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
