search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.42k stars 3k forks source link

Add support for reading external tables in Redshift connector #23296

Open purewell opened 2 months ago

purewell commented 2 months ago

To access AWS Redshift spectrum schema, override RedshiftClient.getTableTypes method.

RedshiftClient.java

    @Override
    protected Optional<List<String>> getTableTypes()
    {
        return Optional.of(ImmutableList.of("TABLE", "VIEW", "EXTERNAL TABLE"));
    }
findinpath commented 1 month ago

What is the use case for implementing this request?

purewell commented 1 month ago

To join tables in redshift.spectrum schema that cannot be provided by other metastores and hive tables.