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
... View more
