You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by Yasufumi Mizoguchi <ya...@gmail.com> on 2017/02/12 15:16:35 UTC

Is there any alternative to '*' in SQL interfaces?

Hi,

I'm a newbie and trying SQL interfaces on Solr 6.4.1.

Firstly, I tried to get the values of all fields, but found the following
on 6.4 Draft Ref Guide.

> The * syntax to indicate all fields is not supported in either limited or
unlimited queries.

So, is there any alternative to '*' ?

Re: Is there any alternative to '*' in SQL interfaces?

Posted by Yasufumi Mizoguchi <ya...@gmail.com>.

Thanks Joel.

I look forward to 6.5 & future releases.

Regards,
Yasufumi

On 2017/02/13 10:21, Joel Bernstein wrote:
> Currently there is not. Round 2 of parallel SQL is slated for Solr 6.5.
> This won't include support for the "*" in the initial release but the plan
> is to support this feature in a release in the near future. The 6.5 release
> is based on Apache Calcite SQL engine and it has much deeper ties into the
> Solr schema.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Sun, Feb 12, 2017 at 10:16 AM, Yasufumi Mizoguchi <yasufumi0410@gmail.com
>> wrote:
>> Hi,
>>
>> I'm a newbie and trying SQL interfaces on Solr 6.4.1.
>>
>> Firstly, I tried to get the values of all fields, but found the following
>> on 6.4 Draft Ref Guide.
>>
>>> The * syntax to indicate all fields is not supported in either limited or
>> unlimited queries.
>>
>> So, is there any alternative to '*' ?
>>

Re: Is there any alternative to '*' in SQL interfaces?

Posted by Joel Bernstein <jo...@gmail.com>.

Currently there is not. Round 2 of parallel SQL is slated for Solr 6.5.
This won't include support for the "*" in the initial release but the plan
is to support this feature in a release in the near future. The 6.5 release
is based on Apache Calcite SQL engine and it has much deeper ties into the
Solr schema.

Joel Bernstein
http://joelsolr.blogspot.com/

On Sun, Feb 12, 2017 at 10:16 AM, Yasufumi Mizoguchi <yasufumi0410@gmail.com
> wrote:

> Hi,
>
> I'm a newbie and trying SQL interfaces on Solr 6.4.1.
>
> Firstly, I tried to get the values of all fields, but found the following
> on 6.4 Draft Ref Guide.
>
> > The * syntax to indicate all fields is not supported in either limited or
> unlimited queries.
>
> So, is there any alternative to '*' ?
>