tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaehwa Jung <blrun...@apache.org>
Subject Re: questions of table partition in Tajo
Date Fri, 13 Feb 2015 03:38:20 GMT
Hi Yu,

You need to rename HDFS directories as follows:

/data/hadoop/test/dt=20150201/phone=1300/gender=m
/data/hadoop/test/dt=20150201/phone=1300/gender=f
/data/hadoop/test/dt=20150202/phone=1500/gender=m
/data/hadoop/test/dt=20150202/phone=1500/gender=f

For reference, Tajo column partition is designed to support the partition
of Apache hive.
So, each directory names must contain each column names.


Cheers
Jaehwa


2015-02-13 12:33 GMT+09:00 Azuryy Yu <azuryyyu@gmail.com>:

> Hi All,
>
> who can give me a simple answer, Thanks.
>
>
> On Thu, Feb 12, 2015 at 12:25 PM, Azuryy Yu <azuryyyu@gmail.com> wrote:
>
> > Hi,
> >
> > How can I add partiton to a table if it was partitoned during creat.
> >
> > such as:
> >
> > create external table test (id text, name text) PARTITION BY COLUMN (dt
> > text, phone text, gender text) USING RCFILE LOCATION '/data/hadoop/test';
> >
> > My data on HDFS was:
> > /data/hadoop/test/20150201/1300/m
> > /data/hadoop/test/20150201/1300/f
> > /data/hadoop/test/20150202/1500/m
> > /data/hadoop/test/20150202/1500/f
> >
> > so how can I add partitions to this table? I cannot find the answer on
> the
> > Wiki.
> >
> >
> > Thanks.
> >
> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message