Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-dev@hadoop.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.212.48 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=B12zP8cBV4yWBDHLLB7qNf3pBX1SP3PLdmJSW5aECPkut2Evp3mUJpjp5KDFUtfIa4
         tQkO0J0PJjbw3Dc6VLfKqZaxtJvgNryQaJ3AMMoJ4OoJn2YfliBF+Vwgm8TX60O4Oud7
         kI2vb/xpsFCrgMTTnh8R477UDwWuXzZmKiOfI=
MIME-Version: 1.0
In-Reply-To: <4C0DEA88.1000606@mkhoj.com>
References: <4C0DEA88.1000606@mkhoj.com>
Date: Tue, 8 Jun 2010 21:40:36 -0400
Message-ID: <AANLkTik-9-aeMCs2apxZSbZI3jxzZNP_S0SJSjYPMtFH@mail.gmail.com>
Subject: Re: table Partition
From: Edward Capriolo <edlinuxguru@gmail.com>
To: hive-dev@hadoop.apache.org
Content-Type: multipart/alternative; boundary=00c09f89944c14c3d104888efe5f

--00c09f89944c14c3d104888efe5f
Content-Type: text/plain; charset=ISO-8859-1

There is no theoretical limit. Practically, the query planning phase
involves reading the partition from the metastore (derby, mysql). At some
point, when your query spans tons of partitions, the query planning phase
can take 2 minutes or more.

Edward

On Tue, Jun 8, 2010 at 3:00 AM, jaydeep vishwakarma <
jaydeep.vishwakarma@mkhoj.com> wrote:

> Hi,
>
> How many partitions at max we can create for a table? Suppose if I want
> to use date as a partition, Is it limited or unlimited ?
>
> Regards,
> jaydeep
>
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify us
> immediately by responding to this email and then delete it from your system.
> The firm is neither liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt.
>

--00c09f89944c14c3d104888efe5f--