Fix TSql in my question: create external table test (id text, name text) PARTITION BY COLUMN (dt text, phone text, gender text) USING RCFILE LOCATION '/data/hadoop/test';
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 > (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. > > > >
