I forgot, there's already a ticket: HIVE-6285<https://issues.apache.org/jira/browse/HIVE-6285> .
-- Lefty On Wed, Jan 29, 2014 at 10:36 PM, Lefty Leverenz <[email protected]>wrote: > Oops, then I'd better correct what I just put in the wiki -- Describe > Table/View/Column<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable/View/Column> > . > > Who wants to open a JIRA ticket? > > -- Lefty > > > On Wed, Jan 29, 2014 at 9:37 PM, Stephen Sprague <[email protected]>wrote: > >> 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 >> <[email protected]>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류승우 <[email protected]> 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 <[email protected]> >>>> >>>> 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, >>>>> >>>> >>>> >>> >> >
