Phoenix Second Index Query very slow -phoenix 4.4

[#1]

hi,everyone

Before using Phoenix 4.2，Use second index Query speed can also be，but when I use hdp HDP-2.4.2.0-258,Phoenix 4.4 ,second index query very slow. my sql like this,

this table only 5.4 G, when i query without secondindex Spend time is 0.01 s but use sceond index Spend time 60 s

why ?

Is there other setting hdp 2.4 phoenix 4.4

1. use second index query time is 60s

2. common query time only 0.11s

3. table index -create index HBaseUnitTest_idx on "HBaseUnitTest" ("CreateTime", "ModuleCode","AppCode","Invoker","ClientIP")

4 table schema

Create table if not exists "HBaseUnitTest" ( "RowKey" varchar primary Key, "AppCode" varchar, "AppVersion" varchar, "ModuleCode" varchar, "CreateTime" varchar, "DataVersion" varchar, "ClientIP" varchar, "ServerIP" varchar, "Invoker" varchar, "Context" varchar, "ID" varchar, "UserID" varchar, "BatchID" varchar, "Action" varchar, "Result" varchar, "Description" varchar, "Ext1" varchar, "Ext2" varchar, "Ext3" varchar, "Ext4" varchar, "Ext5" varchar, "Ext6" varchar, "Ext7" varchar, "Ext8" varchar, "Ext9" varchar, "Ext10" varchar, "Ext11" varchar, "Ext12" varchar, "Ext13" varchar, "Ext14" varchar, "Ext15" varchar, "Ext16" varchar, "Ext17" varchar, "Ext18" varchar, "Ext19" varchar, "Ext20" varchar, "ExtColumnNames" varchar, "ExtKeys" varchar, "DataKey" varchar ) default_column_family = 'd'

5 some config

[#2]

can you provide your secondary index ddl. I would like to see what fields you included in your secondary index. Also have you salted your key? since RPC is high and then starts to drop, you may start to see some hot spotting.

[#3]

my create table sql :create index HBaseUnitTest_idx on "HBaseUnitTest" ("CreateTime", "ModuleCode","AppCode","Invoker","ClientIP")

My table in only 5.4G

Using index is slower than wihout using index

I didn't use salte key

[#4]

tody i Compare explain I find different ? Is there other settings?

My common hbase cluster explain -phoenix 4.2 fast

My problems hbase cluser --phoenix 4.4 slow