Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> DESCRIBE EXTENDED show numRows=0


Copy link to this message
-
Re: DESCRIBE EXTENDED show numRows=0
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,
>>>
>>
>>
>