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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • Impala 2.1.2
    • Impala 2.2
    • None

    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

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

            Dates

              Created:
              Updated:
              Resolved: