0

I have created one hbase table using phoenix and added data using phoenix bulk upload and also created index table and added reference into index table as well but when I execute and SQL then it will take some time as before adding index table. I have added total 1 millions records in that and find data whose status = 1 but it will take same time as I have added index on status column. Please check screen shot as well.

enter image description here

enter image description here

Please let me know if I did something wrong and let me know if I need to set some more configration on hbase. let me know your concerns if any.

Thanks in advance.

Community
  • 1
  • 1
Jain Hemant
  • 150
  • 2
  • 19
  • Type explain 'your sql query' it should tell you what's going on with your query plan. Once you have that you can use the index hints with your query and see if that makes any difference. it's best to use the sqlline.py commandline tool – Paul Bastide Jul 17 '17 at 10:29
  • My query is like this "select * from mobile_phone where status = 0 and caller = '23452342'". – Jain Hemant Jul 17 '17 at 11:14

0 Answers0