phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pradheep Shanmugam <Pradheep.Shanmu...@infor.com>
Subject Phoenix log
Date Wed, 26 Apr 2017 20:35:42 GMT
Hi,

I am doing a point lookup query based on row key and get back a column from another column
family(H.DATA] and it takes about 100ms though sqlline..what is a typical point lookup time?
I am not getting what takes this 54ms at the beginning..any clue…also the total time taken
does not sum up to the time returned by sqlline.assuming network time.

Phoenix log is as below:

2017-04-26 18:47:12 DEBUG ParallelIterators:97 - Id: 4595e0a3-0d93-4ab7-b300-a5e590d7f838,
Time: 54ms, Scan: {"timeRange":[0,1493232432648],"batch":-1,"startRow":"","stopRow":"\\x01","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":2097152,"maxVersions":1,"filter":"FilterList
AND (2/2): [COLUMN_NAME IS NOT NULL, ]","caching":10000}

2017-04-26 18:48:10 DEBUG ParallelIterators:97 - Id: d6ad1212-e56e-4b00-87f9-c8a4b534bbc4,
Time: 4ms, Scan: {"timeRange":[0,1493232491081],"batch":-1,"startRow":"\\x00\\x00MSBO_PHOENIX_COMP_ROWKEY\\x00\\x01","stopRow":"\\x00\\x00MSBO_PHOENIX_COMP_ROWKEY\\x01","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":2097152,"maxVersions":1,"filter":"FilterList
AND (2/2): [COLUMN_FAMILY IS NULL, ]","caching":10000}

2017-04-26 18:48:10 DEBUG ParallelIterators:97 - Id: bd8f3eb7-9259-45bc-b488-89e510881816,
Time: 1ms, Scan: {"timeRange":[0,1493232491022],"batch":-1,"startRow":"\\x07\\x00\\x00\\x00dPO\\x00\\x00\\x00\\x00\\x00-s\\x0C\\x04\\x00\\x00\\x00\\x07","stopRow":"\\x07\\x00\\x00\\x00dPO\\x00\\x00\\x00\\x00\\x00-s\\x0C\\x04\\x00\\x00\\x00\\x08","loadColumnFamiliesOnDemand":null,"totalColumns":2,"cacheBlocks":true,"families":{"0":["_0"],"H":["DATA"]},"maxResultSize":2097152,"maxVersions":1,"caching":10000}

Thanks,
Pradheep
Mime
View raw message