Created 12-08-2020 02:43 AM
i created a table in phoenix
create table t2(pk varchar primary key, col1 varchar);
upsert into T2 values('1','abcd');
upsert into T2 values('2','123');
select * from T2;
+-----+--------+
| PK | COL1 |
+-----+--------+
| 1 | abcd |
| 2 | 123 |
+-----+--------+
table format in hbase
hbase(main):024:0> scan 'T2'
ROW COLUMN+CELL
1 column=0:\x00\x00\x00\x00, timestamp=1607423302365, value=x
1 column=0:\x80\x0B, timestamp=1607423302365, value=abcd
2 column=0:\x00\x00\x00\x00, timestamp=1607423295436, value=x
2 column=0:\x80\x0B, timestamp=1607423295436, value=123
2 row(s)
i backed up above table and restored in hbase. now i want to create phoenix table on top of that
so i used below command to create table
create table t2(pk varchar primary key, col1 varchar);
2 rows affected (0.016 seconds)
select * from T2;
+-----+-------+
| PK | COL1 |
+-----+-------+
| 1 | |
| 2 | |
+-----+-------+
after restored and created table in phoenix the primary key values are coming other values are not showing.
please help me to solve this issue
Created 12-08-2020 03:29 AM
Hello @Manoj690
Thanks for using Cloudera Community. Your concern is Phoenix Table created on top of a Restored Table isn't showing the Non-PrimaryKey Columns correctly.
Can you share the Steps used by your Team to backup the Table & subsequent restore. Additionally, Whether the Backup & Restore are being performed within the same Cluster along with the Distribution being used (For Versioning Check).
- Smarak
Created 12-08-2020 03:47 AM