Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13147

COLUMN_STATS_ACCURATE is not accurate

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 1.2.0
    • None
    • None
    • None

    Description

      Often we see on a described table:

      Table Parameters:	NULL	NULL
      18		COLUMN_STATS_ACCURATE	true                
      19		numFiles            	1                   
      20		numRows             	0                   
      21		rawDataSize         	0                   
      22		totalSize           	46069               
      23		transient_lastDdlTime	1448930216          
      

      Notice

      20		numRows             	0                   
      21		rawDataSize         	0       
      

      are wrong.

      After doing an analyze we get:

      Table Parameters:	NULL	NULL
      18		COLUMN_STATS_ACCURATE	true                
      19		numFiles            	1                   
      20		numRows             	823                 
      21		rawDataSize         	45246               
      22		totalSize           	46069               
      23		transient_lastDdlTime	1456338426 
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              romainr Romain Rigaux
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: