Could you check the task log? For stat gathering, hive uses derby by default. If the jdbc driver for derby is not in auxlib, task cannot publish stats.
2014-01-30 Stephen Sprague <sprag...@gmail.com>: > the answer to this would seemingly be no. i just tried it in hive v0.12. > > numRows=0 before and numRows=0 after my running of "analyze table <table> > compute statistics" > > other values are populated though just not numRows. I wonder why that is. > > Cheers, > Stephen > > {noformat} > > parameters:{numPartitions=0, numFiles=420, last_modified_by=dwr, > last_modified_time=1390986197, transient_lastDdlTime=1391060001, > totalSize=10748060517, *numRows=0,* rawDataSize=0}, > viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) > > {noformat} > > > On Mon, Jan 27, 2014 at 3:52 AM, Lefty Leverenz > <leftylever...@gmail.com>wrote: > >> Can the ANALYZE statement be used to gather statistics if >> hive.stats.autogather was 'false' when the data was loaded? (See the >> wiki's Statistics in Hive doc: Existing >> Tables<https://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-ExistingTables> >> .) >> >> -- Lefty >> >> >> On Sun, Jan 26, 2014 at 8:01 PM, Navis류승우 <navis....@nexr.com> wrote: >> >>> If the data is loaded into table with insert clause with >>> hive.stats.autogather=true, it will be updated. If it's not, it's zero (or >>> -1 sometimes). >>> >>> >>> 2014-01-23 Haroon Muhammad <muhammad.har...@live.com> >>> >>> Hi, >>>> >>>> I have observed that DESCRIBE EXTENDED always shows number of rows to >>>> be zero despite the fact that the table has data. Is it a bug? Is it known >>>> ? Has anyone else also come across the same ? >>>> >>>> Thanks, >>>> >>> >>> >> >