Hi there, I was going through the code related to index creation via MapReduce job (IndexTool) and I have some questions. If I am not mistaken, for a global secondary index Phoenix creates a new HBase table which has the appropriate key (the column value of the original table you want to index) and loads the column values you have in your INCLUDE statement. In the PhoenixIndexImportMapper I can see that an Upsert statement is executed, but also HFiles are written. My question is the following: why is the Upsert statement needed if the table containing the secondary index will be populated from the HFiles written?
Thanks a lot
