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

"Warning: Consider running "INVALIDATE METADATA <tablename>"" even after invalidating metadata

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: Impala 2.1.2
    • Fix Version/s: Impala 2.2
    • Component/s: None
    • Labels:

      Description

      flatbam was created as parquet-backed table from a select as query. Whenever I query it, I get this warning about invalidating metadata. When I try to invalidate the table's metadata, I get the same warning:

      WARNINGS: Backend 19:Block locality metadata for table 'flatbam' may be stale. Consider running "INVALIDATE METADATA flatbam".
      
      [demeter-csmau08-10:21000] > INVALIDATE METADATA flatbam;
      Query: invalidate METADATA flatbam
      
      Fetched 0 row(s) in 0.03s
      [nodename:21000] > select count(*) from flatbam;
      Query: select count(*) from flatbam
      +-----------+
      | count(*)  |
      +-----------+
      | 856755914 |
      +-----------+
      WARNINGS: Backend 19:Block locality metadata for table 'flatbam' may be stale. Consider running "INVALIDATE METADATA flatbam".
      Backend 40:Block locality metadata for table 'flatbam' may be stale. Consider running "INVALIDATE METADATA flatbam".
      
      Fetched 1 row(s) in 6.20s
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              isaachodes Isaac Hodes
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: