There are test cases with multiple order by fields for SELECT DISTINCT and GROUP BY. But not for simple SELECT.
We are just about to release a new version of the SQL interface which uses Apache Calcite rather then Presto. I'll make sure that this is working in the new release. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Dec 29, 2016 at 3:33 PM, Joel Bernstein <joels...@gmail.com> wrote: > This would be a bug. I'll take a look at the test cases and see if there > is a test case for this. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Thu, Dec 29, 2016 at 3:17 PM, radha krishnan < > dradhakrishna...@gmail.com> wrote: > >> Hi, >> >> when i was trying out the SQL functionality, i realized that >> >> multiple order by clauses work only when " select distinct " command is >> used where as it does not work with a " select "command >> >> Eg: >> >> SELECT distinct name, salary, distance_from_office FROM "employees_core" >> ORDER BY salary desc , name desc -- this one works >> >> SELECT name, salary, distance_from_office FROM "employees_core" ORDER BY >> salary desc , name desc -- this does not work and fails with the response, >> >> >> { >> >> "result-set":{"docs":[ >> >> { >> >> "EXCEPTION":"java.util.concurrent.ExecutionException: >> java.io.IOException: --> http://localhost:8983/solr/employees_core/:Can't >> determine a Sort Order (asc or desc) in sort spec 'salary descname desc', >> pos=6", >> >> "EOF":true, >> >> "RESPONSE_TIME":152}]}} >> >> >> >> is it by design that multiple order by will work only with select >> distinct ? >> >> >> >> >> Thanks, >> >> Radhakrishnan D >> > >
