Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Subject: Re: help get 'count of distinct' using solr via cql against datastax?
To: solr-user@lucene.apache.org
References: <1511707544959-0.post@n3.nabble.com>
From: Shawn Heisey <apache@elyograg.org>
Message-ID: <336a12f6-7574-85d2-27ee-674d0b67f14a@elyograg.org>
Date: Sun, 26 Nov 2017 08:28:43 -0700
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.4.0
MIME-Version: 1.0
In-Reply-To: <1511707544959-0.post@n3.nabble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
archived-at: Sun, 26 Nov 2017 15:29:05 -0000

On 11/26/2017 7:45 AM, lamelylounges wrote:
> I have a datastax (DSE) server with cassandra.  I am running the node in
> "search" mode, which means solr is enabled and working.  I want to use CQL
> to write a query against my core/table.

I'm fairly certain that CQL is not something created by the Solr 
project.  You're going to need to talk to either the Cassandra project 
or DataStax for help with CQL.  Most questions about DataStax are best 
handled by them, even if they concern Solr, because they do a lot of 
customization of Solr, and only they are going to know how they've got 
everything configured.

> If this were a traditional SQL, here is how I would write it:
> SELECT COUNT(DISTINCT my_field) FROM my_table WHERE my_field LIKE 'S%'
> 
> Is there a way to accomplish a select count distinct?

Solr's facet functionality might be a lot like a distinct count.  The 
basic facet capability shows the number of documents in the index that 
match each of the possible terms in the index for a given field. 
Because you're running the highly customized Solr in DSE, you may get 
better (and faster) answers from DataStax.

Solr includes something in recent versions where you can access it as if 
it were a database.  I really don't know anything about it, but there 
are others on this list who do:

https://lucene.apache.org/solr/guide/6_6/parallel-sql-interface.html

> (ps I have been trying to subscribe to this mailing list but it seems like
> nabble is not sending out an initial subscribe request.  I have looked in my
> spam folder and have tried several different email domains)

Nabble is not the mailing list.  Their solr-user pages are a mirror of 
the mailing list in forum format.  If you're having trouble with Nabble, 
you're going to need to talk to Nabble about it.  I have never used Nabble.

Here is where you can find info about the actual mailing list, which is 
maintained by the Apache Software Foundation:

https://lucene.apache.org/solr/community.html#mailing-lists-irc

Thanks,
Shawn