hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: DESCRIBE EXTENDED show numRows=0
Date Thu, 30 Jan 2014 06:36:58 GMT
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 <spragues@gmail.com> 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 <leftyleverenz@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.ryu@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.haroon@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,
>>>>
>>>
>>>
>>
>

Mime
View raw message