Use ORDER BY in your select clause:- https://phoenix.apache.org/language/#select
Michael McAllister Staff Data Warehouse Engineer | Decision Systems [email protected]<mailto:[email protected]> | C: 512.423.7447 | skype: michael.mcallister.ha<mailto:[email protected]> | webex: https://h.a/mikewebex [Description: Description: cid:3410354473_30269081] This electronic communication (including any attachment) is confidential. If you are not an intended recipient of this communication, please be advised that any disclosure, dissemination, distribution, copying or other use of this communication or any attachment is strictly prohibited. If you have received this communication in error, please notify the sender immediately by reply e-mail and promptly destroy all electronic and printed copies of this communication and any attachment. From: Ns G [mailto:[email protected]] Sent: Wednesday, January 27, 2016 6:50 AM To: [email protected] Subject: REG: Natural Sort order of columns Hi There, Can I get any phoenix column in Natural sort order? For eg: If I have column with values as test11 test500 42 test9 test3 1 51 then the output should be like 1 42 51 test3 test9 test11 test500 any suggestions please? Thanks, PS: I have used AlphonumComparator class referred from [ http://www.davekoelle.com/alphanum.html ] which solves the requirementof sorting a java collection using Collections.sort method.
