Mailing List Archive: Using collection alias with Parallel SQL Interface

Using collection alias with Parallel SQL Interface

Jun 6, 2016, 1:22 PM

Post #1 of 3 (697 views)

Hi,
I tried to use the collection alias in my SQL query :

SELECT MyField FROM MyCollectionAlias LIMIT 10

But I got an error that MyCollectionAlias doesn't exit.

Is there a way to use the collection alias in the SQL query ?

Thank you

--
View this message in context: http://lucene.472066.n3.nabble.com/Using-collection-alias-with-Parallel-SQL-Interface-tp4280893.html
Sent from the Lucene - General mailing list archive at Nabble.com.

Re: Using collection alias with Parallel SQL Interface [ In reply to ]

joelsolr at gmail

Jun 7, 2016, 9:37 AM

Post #2 of 3 (683 views)

Permalink

Currently collection aliases are not supported with SQL interface or
Streaming Expressions. There is a ticket open for this:

https://issues.apache.org/jira/browse/SOLR-9077

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

On Mon, Jun 6, 2016 at 4:22 PM, lansing <halim.chaibi@wantedanalytics.com>
wrote:

> Hi,
> I tried to use the collection alias in my SQL query :
>
> SELECT MyField FROM MyCollectionAlias LIMIT 10
>
> But I got an error that MyCollectionAlias doesn't exit.
>
> Is there a way to use the collection alias in the SQL query ?
>
> Thank you
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Using-collection-alias-with-Parallel-SQL-Interface-tp4280893.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
>

Re: Using collection alias with Parallel SQL Interface [ In reply to ]

halim.chaibi at wantedanalytics

Jun 7, 2016, 10:50 AM

Post #3 of 3 (683 views)

Permalink

Thank you

--
View this message in context: http://lucene.472066.n3.nabble.com/Using-collection-alias-with-Parallel-SQL-Interface-tp4280893p4281075.html
Sent from the Lucene - General mailing list archive at Nabble.com.