Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-8440

ANALYZE is not supported for group scan with format Delta

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Later
    • 1.21.1
    • None
    • Storage - Other
    • None
    • Ubuntu 22.04.2 LTS

      openjdk version "17.0.7" 2023-04-18

       

    Description

      Describe the bug

      Attempting to store table metadata in the Iceberg metastore, Delta tables which are queryable with SQL throw error when attempting ANALYZE TABLE

      To Reproduce
      apache drill (delta.root)> ANALYZE TABLE "path/to/table" REFRESH METADATA 'TABLE' LEVEL;

      Error detail, log output or screenshots
      Error: VALIDATION ERROR: ANALYZE is not supported for group scan [DeltaGroupScan [path="/path/to/table", entries=[ReadEntryWithPath [path=/path/to/table/partition/file.snappy.parquet], ...

      Drill version

      Apache Drill 1.21.1

      Additional context

      On same Drillbit, ANALYZE is successful on plain Parquet tables.

      Attachments

        Activity

          People

            Unassigned Unassigned
            kermatt Matt Keranen
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: