https://community.cloudera.com/t5/Support-Questions/Phoenix-table-creation-on-top-of-restored-hbase-table/m-p/307147#M223116 <P>i created a table in phoenix</P><P>create table t2(pk varchar primary key, col1 varchar);</P><P>upsert into T2 values('1','abcd');</P><P>upsert into T2 values('2','123');</P><P>select * from T2;<BR />+-----+--------+<BR />| PK | COL1 |<BR />+-----+--------+<BR />| 1 | abcd |<BR />| 2 | 123 |<BR />+-----+--------+</P><P>table format in hbase</P><P>hbase(main):024:0&gt; scan 'T2'<BR />ROW&nbsp; &nbsp;COLUMN+CELL<BR />1&nbsp; &nbsp; &nbsp; column=0:\x00\x00\x00\x00, timestamp=1607423302365, value=x<BR />1&nbsp; &nbsp; &nbsp; column=0:\x80\x0B, timestamp=1607423302365, value=abcd<BR />2&nbsp; &nbsp; &nbsp; column=0:\x00\x00\x00\x00, timestamp=1607423295436, value=x<BR />2&nbsp; &nbsp; &nbsp; column=0:\x80\x0B, timestamp=1607423295436, value=123<BR />2 row(s)</P><P>&nbsp;</P><P>i backed up above table and restored in hbase. now i want to create phoenix table on top of that</P><P>so i used below command to create table</P><P>create table t2(pk varchar primary key, col1 varchar);<BR />2 rows affected (0.016 seconds)</P><P>select * from T2;<BR />+-----+-------+<BR />| PK | COL1 |<BR />+-----+-------+<BR />| 1 | |<BR />| 2 | |<BR />+-----+-------+</P><P>&nbsp;</P><P>after restored and created table in phoenix the primary key values are coming other values are not showing.</P><P>&nbsp;</P><P>please help me to solve this issue</P><P>&nbsp;</P> Tue, 08 Dec 2020 10:43:11 GMT Manoj690 2020-12-08T10:43:11Z