Hi, I am using the phoenix parcel for cloudera 5.4. Seems like there is a bug when query has Order by DESC the query hang for long time and after a while it fail with the following error . without DESC the order by works fine
Caused by: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=35, exceptions: Wed Jan 13 09:22:09 IST 2016, org.apache.hadoop.hbase.client.RpcRetryingCaller@2935d8d3, java.io.IOException: java.io.IOException at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2069) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.StackOverflowError at org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer.compareTo(Bytes.java:1295) at org.apache.hadoop.hbase.util.Bytes.compareTo(Bytes.java:1223) at org.apache.hadoop.hbase.CellComparator.compareRows(CellComparator.java:186) at org.apache.hadoop.hbase.CellComparator.compare(CellComparator.java:63) at org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1968) at org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1897) at org.apache.hadoop.hbase.util.Bytes.binarySearch(Bytes.java:1901) at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.rootBlockContainingKey(HFileBlockIndex.java:426) at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.loadDataBlockWithScanInfo(HFileBlockIndex.java:215) at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.seekToDataBlock(HFileBlockIndex.java:182) at org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:642) at org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:637) at org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:425) at org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:449) this worked in previous phoenix version can you check regards, Noam ________________________________ PRIVILEGED AND CONFIDENTIAL PLEASE NOTE: The information contained in this message is privileged and confidential, and is intended only for the use of the individual to whom it is addressed and others who have been specifically authorized to receive it. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, or if any problems occur with transmission, please contact sender. Thank you.