Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-12853

Collection types in FROM clause for Iceberg Metadata Tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • ghx-label-4

    Description

      Iceberg Metadata Table Collection types are not supported in from clause, therefore it is not possible to use 'item' or 'pos' in case of arrays for example.

      Example query:

      select delete_ids.item
      from functional_parquet.iceberg_query_metadata.all_files, functional_parquet.iceberg_query_metadata.all_files.equality_ids delete_ids; 

      When scanning metadata tables, the whole table and row is read from Iceberg which means that the "top" level StructLikeRow is returned. But Impala only creates tuples and slots for the selected slots and tuples. This makes accessing the values inside StructLikeRows difficult, because it cannot be accessed through accessors and these have to be accessed through positions.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tmate Tamas Mate
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: