Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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,
>>>
>>
>>
>

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB