Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3200010311 for ; Thu, 2 May 2013 14:31:23 +0000 (UTC) Received: (qmail 24715 invoked by uid 500); 2 May 2013 14:31:21 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 24665 invoked by uid 500); 2 May 2013 14:31:21 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 24657 invoked by uid 99); 2 May 2013 14:31:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 14:31:21 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Sanjay.Subramanian@wizecommerce.com designates 213.199.154.188 as permitted sender) Received: from [213.199.154.188] (HELO db8outboundpool.messaging.microsoft.com) (213.199.154.188) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 14:31:14 +0000 Received: from mail129-db8-R.bigfish.com (10.174.8.242) by DB8EHSOBE026.bigfish.com (10.174.4.89) with Microsoft SMTP Server id 14.1.225.23; Thu, 2 May 2013 14:30:51 +0000 Received: from mail129-db8 (localhost [127.0.0.1]) by mail129-db8-R.bigfish.com (Postfix) with ESMTP id D9EC6240706 for ; Thu, 2 May 2013 14:30:50 +0000 (UTC) X-Forefront-Antispam-Report: CIP:157.56.237.133;KIP:(null);UIP:(null);IPV:NLI;H:BY2PRD0411HT005.namprd04.prod.outlook.com;RD:none;EFVD:NLI X-SpamScore: -4 X-BigFish: PS-4(zz9371I181fMc85eh4015I9a6kzz1f42h1fc6h1ee6h1de0h1fdah1202h1e76h1d1ah1d2ahzz18c673h8275bh8275dhz2fh2a8h668h839hbe3he5bhf0ah1288h12a5h12bdh137ah1441h1504h1537h153bh162dh1631h1758h18e1h1946h19b5h1ad9h1b0ah1bceh1d0ch1d2eh1d3fh1155h) Received-SPF: pass (mail129-db8: domain of wizecommerce.com designates 157.56.237.133 as permitted sender) client-ip=157.56.237.133; envelope-from=Sanjay.Subramanian@wizecommerce.com; helo=BY2PRD0411HT005.namprd04.prod.outlook.com ;.outlook.com ; Received: from mail129-db8 (localhost.localdomain [127.0.0.1]) by mail129-db8 (MessageSwitch) id 1367505049293630_20724; Thu, 2 May 2013 14:30:49 +0000 (UTC) Received: from DB8EHSMHS008.bigfish.com (unknown [10.174.8.232]) by mail129-db8.bigfish.com (Postfix) with ESMTP id 3BEAE20045 for ; Thu, 2 May 2013 14:30:49 +0000 (UTC) Received: from BY2PRD0411HT005.namprd04.prod.outlook.com (157.56.237.133) by DB8EHSMHS008.bigfish.com (10.174.4.18) with Microsoft SMTP Server (TLS) id 14.1.225.23; Thu, 2 May 2013 14:30:42 +0000 Received: from BY2PRD0411MB427.namprd04.prod.outlook.com ([169.254.3.149]) by BY2PRD0411HT005.namprd04.prod.outlook.com ([10.255.128.40]) with mapi id 14.16.0305.001; Thu, 2 May 2013 14:30:41 +0000 From: Sanjay Subramanian To: "user@hive.apache.org" Subject: Re: Describe extended shows number of rows as 0 Thread-Topic: Describe extended shows number of rows as 0 Thread-Index: AQHOR0Dne9z69zi56kuehjOTWIbs5Jjxf2AA Date: Thu, 2 May 2013 14:30:40 +0000 Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.255.128.4] Content-Type: multipart/alternative; boundary="_000_CDA7C60B726Bsanjaysubramanianwizecommercecom_" MIME-Version: 1.0 X-OriginatorOrg: wizecommerce.com X-Virus-Checked: Checked by ClamAV on apache.org --_000_CDA7C60B726Bsanjaysubramanianwizecommercecom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Not that it could be related but if possible setup a Mysql or similar serio= us datastore=85.that Hive can connect to=85 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 H= ive :-) Regards sanjay From: Aishwarya Ganesan > Reply-To: "user@hive.apache.org" > Date: Thursday, May 2, 2013 7:24 AM To: "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 sho= ws the number of rows as 0. Query: DESCRIBE EXTENDED lineitem1; Result: .......parameters:{numPartitions=3D0, numFiles=3D4, transient_lastDdlTime= =3D1367502213, numRows=3D0, totalSize=3D3184, rawDataSize=3D0}, My Settings: javax.jdo.option.ConnectionURL jdbc:derby:;databaseName=3D/home/TempStatsStore;crea= te=3Dtrue JDBC connect string for a JDBC metastore How to resolve this? Thanks, Aishwarya CONFIDENTIALITY NOTICE =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This email message and any attachments are for the exclusive use of the int= ended 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 ema= il and destroy all copies of the original message along with any attachment= s, 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 d= isclosure by the sender's Email System Administrator. --_000_CDA7C60B726Bsanjaysubramanianwizecommercecom_ Content-Type: text/html; charset="Windows-1252" Content-ID: <8DF6E6C0A611664A99E090C3360621DF@namprd04.prod.outlook.com> Content-Transfer-Encoding: quoted-printable
Not that it could be related but if possible setup a Mysql or similar = serious datastore=85.that Hive can connect to=85

Its possibly not prudent spending time to analyze problems caused &nbs= p;by derby metastore and with Mysql u can start doing some heavy duty sting= ing 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 nu= mber of rows as 0


Hi,

When  I run analyze table command and run describe extended command, i= t shows the number of rows as 0.

Query: DESCRIBE EXTENDED lineitem1;

Result:

.......parameters:{numPartitions=3D0, numFiles=3D4, transient_lastDdlTime= =3D1367502213, numRows=3D0, totalSize=3D3184, rawDataSize=3D0},

My Settings:
      <property>
            &nb= sp;   <name>javax.jdo.option.ConnectionURL</name>
            &nb= sp;   <value>jdbc:derby:;databaseName=3D/home/TempStatsStor= e;create=3Dtrue</value>
            &nb= sp;   <description>JDBC connect string for a JDBC metastore= </description>
        </property>

How to resolve this?



Thanks,
Aishwarya

CONFIDENTIALITY NOTICE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This email message and any attachments are for the exclusive use of the int= ended 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 ori= ginal message along with any attachments, from your computer system. If you= are the intended recipient, please be advised that the content of this mes= sage is subject to access, review and disclosure by the sender's Email System Administrator.
--_000_CDA7C60B726Bsanjaysubramanianwizecommercecom_--