phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kiru Pakkirisamy <kirupakkiris...@yahoo.com>
Subject select w/ limit hanging on large tables
Date Tue, 12 May 2015 21:55:50 GMT
We are trying to benchmark/test Phoenix with large tables.A 'select * from table1 limit 100000'
hangs on a 1.4 billion row table (in sqlline.py or SQuirreL)The same select of 1million rows
works on smaller table (300 million).Mainly we wanted to create a smaller version of the 1.4
billion table and ran into this issue.Any ideas why this is happening ?We had quite a few
problems crossing the 1 billion mark even when loading (using CsvBulkLoadTool) the table.We
are also wondering whether our HBase is configured correctly.
Any tips on HBase Configuration for loading/running Phoenix is highly appreciated as well.(We
are on HBase 0.98.12 and Phoenix 4.3.1) Regards,
- kiru
 Regards,
- kiru


Mime
View raw message