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 <[email protected]>: > Hi All, > > who can give me a simple answer, Thanks. > > > On Thu, Feb 12, 2015 at 12:25 PM, Azuryy Yu <[email protected]> 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. > > > > > > > > >
