There isn't a command available to rename or change the data type of a
column in Phoenix -- to do something like this, you need to drop a
column and then create a new column.
If you have existing data that you want to migrate, I would suggest
doing the following:
1. Create the new column (with the new name and possibly new type)
2. Run an UPSERT SELECT statement to copy/migrate data from the old
column to the new column
3. Drop the old column
- Gabriel
On Fri, Sep 11, 2015 at 6:48 AM, Hafiz Mujadid <hafizmujadid00@gmail.com> wrote:
> Hi All!
>
> I want to rename a column in phoenix with hbase. Similarly what If i want to
> change
> the type of a column, what will be the effect of altering column type on
> existing data?
>
> Thanks
|