phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: change data type of column
Date Tue, 20 Oct 2015 16:38:53 GMT
We don't support altering the data type of a column directly. The way I've
seen this done is:
- create a new column with the new type
- copy the old value over, coercing it to the new type (either using UPSERT
SELECT or MR)
- start using the new column instead of the old column
- drop the old column

We have a JIRA for it (PHOENIX-152). In theory, we could automate the above
process, doing it asynchronously where the data type change wouldn't take
effect until the entire process is complete.

Thanks,
James

On Mon, Oct 19, 2015 at 10:29 AM, ALEX K <alex.kamil@gmail.com> wrote:

> Is it possible to change data type of column in Apache Phoenix without
> losing HBase data?
>

Mime
View raw message