phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arvind S <arvind18...@gmail.com>
Subject slow response on large # of columns
Date Mon, 26 Dec 2016 07:25:55 GMT
Setup ..
hbase (1.1.2.2.4) cluster on azure with 1 Region server. (8core 28 gb ram
..~16gb RS heap)
phoenix .. 4.4

Observation ..
created a table with 3 col composite PK and 3600 float type columns (1 per
sec).
loaded with <5000 lines of data (<100 MB compressed snappy & fast diff
encoding)

On performing "select * " or select with individually naming each of these
3600 columns the query takes around 2+ mins to just return a few lines
(limit 2,10 etc).

Subsequently on selecting lesser number of columns the performance seems to
improve.

is it an anti-pattern to have large number of columns in phoenix tables?

*Cheers !!*
Arvind

Mime
View raw message