I am trying to create a hive view referring to a iceberg table using spark. That view is working fine on spark but facing issues while querying with Trino
CREATE VIEW test_iceberg.testing_view as AS SELECT * FROM iceberg.test.testing_table
Using :
Iceberg (1.7.1) with Hive metastore
Spark on EMR (3.4.1)
Trino(Tried with v442 & v475)
Failed to translate Hive view 'test_iceberg.testing_table': com.linkedin.coral.hive.hive2rel.parsetree.parser.ParseException: line 1:40 cannot recognize input near '.' 'testing_table' '' in table source