Hi,
A work around could be to add columns from the second table as fields to
the Solr document from the first table. E.g. For DB query:
SELECT project_id
FROM projects
MINUS
SELECT project_id
FROM archived_project;
Add archived_projects as a boolean field to Projects in Solr & then query
as:
q=(
Thanks for the info Shawn.
On Sun, Jun 2, 2013 at 6:22 AM, Shawn Heisey-4 [via Lucene] <
ml-node+s472066n4067630...@n3.nabble.com> wrote:
> On 6/1/2013 10:32 AM, Bala wrote:
> > Can somebody tell me if i can achieve SQL MINUS query in solr . here is
> > Sample SQL MINUS query. Need how to get th
On 6/1/2013 10:32 AM, Bala wrote:
> Can somebody tell me if i can achieve SQL MINUS query in solr . here is
> Sample SQL MINUS query. Need how to get the same in solr
>
> select field1, field2, ... field_n
> from tables
> MINUS
> select field1, field2, ... field_n
> from tables;
I had to look up
