Hi, I know we have a CDC feaure in the work in phoenix but we have an immediate requirement to get CDC data from phoenix salted table and got stuck at the read from phoenix.
I did the following: 1. Run export based on rowtimestamp from hbase table(phoenix salted immutable table with composite row key) sudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Export MILESTONE_HISTORY_RCTQ /tmp/history_rctq_jul2_1 1 1711929600000 1712016000000 the data is in hbase sequence format in hdfs 2. Use import tool to write this delta to another hbase table. create 'MILESTONE_HISTORY_RCTQ_TEMP', 'H' (in hbase shell) H is the column family then we did the import sudo -u hdfs hbase org.apache.hadoop.hbase.mapreduce.Import MILESTONE_HISTORY_TEMP /tmp/history_rctq_jul2_1 3. Create a phoenix salted table using the same schema on top of new hbase table that has only the deltas. After this when I run select * from phoenix sqlline on the new table it return empty row but the select with only the row key colums is returing fine. When we seleted the columns under the column family H, we get null Not sure what is the issue. Any idea what is wrong? Any help is much apprciated. Thanks, Pradheep
