Hi Vamsi, Creating a single hbase table for all LOCAL indexes of a phoenix data table is a regular/expected behavior. Phoenix local indexes targets write heavy use cases hence maintaining data table and single index table in same region server prevents network overhead during writes.
If you want to create a separate hbase table for each index table, you can create global indexes(create index command without 'LOCAL' work creates global indexes) that are targeted for read heavy use cases. -- View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/For-multiple-local-indexes-on-Phoenix-table-only-one-local-index-table-is-being-created-in-HBase-tp1995p1999.html Sent from the Apache Phoenix User List mailing list archive at Nabble.com.
