hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aishwarya Ganesan <ash8as...@gmail.com>
Subject Re: Describe extended shows number of rows as 0
Date Thu, 02 May 2013 14:40:11 GMT
Also, When i run

ANALYZE TABLE lineitem1 COMPUTE STATISTICS FOR COLUMNS L_LINENUMBER;

and check the column statistics values, they are populated correctly. Only
number of row information is wrong. How is this possible?

On Thu, May 2, 2013 at 8:00 PM, Sanjay Subramanian <
Sanjay.Subramanian@wizecommerce.com> wrote:

>  Not that it could be related but if possible setup a Mysql or similar
> serious datastore….that Hive can connect to…
>
>  Its possibly not prudent spending time to analyze problems caused  by
> derby metastore and with Mysql u can start doing some heavy duty stinging
> with Hive :-)
> Regards
> sanjay
>
>   From: Aishwarya Ganesan <ash8aster@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Thursday, May 2, 2013 7:24 AM
> To: "user@hive.apache.org" <user@hive.apache.org>
> Subject: Describe extended shows number of rows as 0
>
>
> Hi,
>
> When  I run analyze table command and run describe extended command, it
> shows the number of rows as 0.
>
> Query: DESCRIBE EXTENDED lineitem1;
>
> Result:
>
> .......parameters:{numPartitions=0, numFiles=4,
> transient_lastDdlTime=1367502213, numRows=0, totalSize=3184, rawDataSize=0},
>
> My Settings:
>       <property>
>                 <name>javax.jdo.option.ConnectionURL</name>
>
> <value>jdbc:derby:;databaseName=/home/TempStatsStore;create=true</value>
>                 <description>JDBC connect string for a JDBC
> metastore</description>
>         </property>
>
> How to resolve this?
>
>
>
> Thanks,
> Aishwarya
>
> CONFIDENTIALITY NOTICE
> ======================
> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.
>



-- 
Thanks,
Aishwarya

Mime
View raw message