HI Jaanai Zhang,
When you say migrate the data, do you mean somehow export the data from
phoenix tables(phoenix 4.6) and bulk-insert into new phoenix
tables(phoenix-4.14) ?
Do you have any data migration script or something which I can take help of
?
Thanks,
Tanvi
On Wed, Oct 17, 2018 at 5:41
It seems that is impossible to upgrade from Phoenix-4.6 to Phoenix-4.14,
the schema of SYSTEM had been changed or some futures will be
incompatible. Maybe you can migrate data from Phoenix-4.6 to Phoenix-4.14,
this solution can ensure that everything will be right.
@Shamvenk
Yes I did check the STATS table from hbase shell, it's not empty.
After dropping all SYSTEM tables and mapping hbase-tables to phoenix tables
by executing all DDLs, I am seeing new issue.
I have a table and an index on that table. Number of records in index table
and main table are
Did you check system.stats,. If it us empty, needs to be rebuilt by running
major compact on hbasr
On Tue, Sep 11, 2018, 11:33 AM Tanvi Bhandari
wrote:
> Hi,
>
>
>
> I am trying to upgrade the phoenix binaries in my setup from phoenix-4.6
> (had optional concept of schema) to phoenix-4.14
I think i found the issue :
I had the tables created in Phoenix 4.6 which did not have Column name
encoding feature(https://issues.apache.org/jira/browse/PHOENIX-1598). And
then now I have to move to phoenix 4.14 directly.
As far as I know Phoenix handles the upgrade for Column names encoding
can you attach the schema of your table? and the explain plan for select *
from mytable?
On Tue, Sep 11, 2018 at 10:24 PM, Tanvi Bhandari
wrote:
> " mapped hbase tables to phoenix and created them explicitly from phoenix
> sqlline client. I first created schema corresponding to namespace and
" mapped hbase tables to phoenix and created them explicitly from phoenix
sqlline client. I first created schema corresponding to namespace and then
tables." By this statement, I meant the same. I re-created my tables since
I had the DDLs with me.
After that I tried getting the count of records
Since you dropped all the system tables, all the phoenix metadata was lost.
If you have the ddl statements used to create your tables, you can try
rerunning them.
On Tue, Sep 11, 2018 at 9:32 AM, Tanvi Bhandari
wrote:
> Hi,
>
>
>
> I am trying to upgrade the phoenix binaries in my setup from
Hi,
I am trying to upgrade the phoenix binaries in my setup from phoenix-4.6
(had optional concept of schema) to phoenix-4.14 (schema is a must in
here).
Earlier, I had the phoenix-4.6-hbase-1.1 binaries. When I try to run the
phoenix-4.14-hbase-1.3 on the same data. Hbase comes up fine But