Phoenix 4.7 CSVBulk Loading not populating index tables

2016-06-14 Thread Talanki, Vikash
Hi All, I'm currently trying to load CSV files in Phoenix table using CSVBulkLoad tool using phoenix-4.7.0-HBase-1.1-client.jar in Hortonworks. I have a phoenix table and 6 indexes were created on this table. According to CSV Bulk Load documentation - 

RE: phoenix explain plan not showing any difference after adding a local index on the table column that is used in query filter

2016-06-29 Thread Talanki, Vikash
Hi Ankit, I think this is not completely true.  Phoenix uses local index table when all columns in where clause and atleast one column in select clause are part of local index table.  "Select col1,col2,col3 from table" uses local index but "select * from table" do not.  I'm not certain of