Re: multiple order by clauses with the sql handler

[radha krishnan]

Thanks Joel for your reply.

will test it out it in the next version.


Thanks,
Radhakrishnan D


On Thu, Dec 29, 2016 at 12:41 PM, Joel Bernstein  wrote:

> 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 
> 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
> >>
> >
> >
>

Re: multiple order by clauses with the sql handler

[Joel Bernstein]

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  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
>>
>
>

Re: multiple order by clauses with the sql handler

[Joel Bernstein]

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 
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
>