impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Jacobs ...@cloudera.com>
Subject Re: numrows is incorrect after renaming external table
Date Fri, 15 Apr 2016 22:23:09 GMT
Whoops, should have been user@impala.incubator.apache.org

On Fri, Apr 15, 2016 at 3:21 PM Matthew Jacobs <mj@cloudera.com> wrote:

> Also, adding impala-user@impala.incubator.apache.org.
>
>
> On Fri, Apr 15, 2016 at 3:20 PM Matthew Jacobs <mj@cloudera.com> wrote:
>
>> Hi Mani,
>>
>> Can you confirm if this is different behavior from the same actions in
>> Hive?
>>
>> Thanks
>>
>> On Tue, Apr 12, 2016 at 8:14 AM Manikandan R <manirajv06@gmail.com>
>> wrote:
>>
>>> Hello,
>>>
>>> I created a external non-partitioned table using Impala shell and
>>> inserted few rows into it using hive. While inserting, I can see basic
>>> stats like numRows, numFiles, size etc getting generated something like
>>>
>>> Table tempdb_mani.mk_prod_inc1 stats: [numFiles=1, numRows=5,
>>> totalSize=614, rawDataSize=20]
>>>
>>> I can see the same stats in Impala-shell using show table stats command
>>> (after invalidate metadata command). Then, I renamed the table into
>>> mk_prod_inc2 using Impala shell and tried to look at the table stats using
>>> above command. Now, numRows is -1, whereas numFiles and size remains same
>>> (correct).
>>>
>>> Interestingly, this is not happening if the table type is INTERNAL. It
>>> is showing correct numRows even after RENAME. Also, It is not happening for
>>> Partitioned tables even if the type is EXTERNAL.
>>>
>>> Did anyone observed this behaviour?
>>>
>>> Thanks,
>>> Mani
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Impala User" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to impala-user+unsubscribe@cloudera.org.
>>>
>>

Mime
View raw message