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
