Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix Second Index Query very slow -phoenix 4.4

Highlighted

Phoenix Second Index Query very slow -phoenix 4.4

New Contributor

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

11248-123.png

2. common query time only 0.11s

11249-common.png

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

11250-456.png

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

11261-789.png

11262-333.png

3 REPLIES 3

Re: Phoenix Second Index Query very slow -phoenix 4.4

Super Guru

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.

Re: Phoenix Second Index Query very slow -phoenix 4.4

New Contributor

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

Re: Phoenix Second Index Query very slow -phoenix 4.4

New Contributor

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

My common hbase cluster explain -phoenix 4.2 fast

11280-1qpng.png

My problems hbase cluser --phoenix 4.4 slow

11301-54.png

Don't have an account?
Coming from Hortonworks? Activate your account here