Verify Restored Data

This section explains how you can verify that you have successfully restored the data from the backup.

Start the SQL shell on storage node 3:

java -Xmx64m -Xms64m -jar lib/sql.jar -helper-hosts phoenix581601:5000 -store mystore -security kvroot2/security/client.security
Login as:root
root's password:<password>

SQL prompt is displayed

sql->

Enter command to show the tables

show tables

Output:

tables
  SYS$IndexStatsLease
  SYS$MRTableAgentStat
  SYS$MRTableInfo
  SYS$MRTableInitCheckpoint
  SYS$PartitionStatsLease
  SYS$SGAttributesTable
  SYS$StreamRequest
  SYS$StreamResponse
  SYS$TableMetadata
  SYS$TableStatsIndex
  SYS$TableStatsPartition
  SYS$TopologyHistory
  ticket

Read the data in table ticket.

select * from ticket

Output:

{"ticketNo":34567890,"confNo":"DFGRTH"}
{"ticketNo":12345678,"confNo":"LEJDFG"}
{"ticketNo":45367892,"confNo":"FGRTFB"}

3 rows returned

You can see that the metadata, tables and data that you had backed up are now restored and available on the new store.