Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAAHPopGAmoK2qD9=JyLcHr_0dPHEZ_FNstdCUyMbhQNijMMkJA@mail.gmail.com>
References: 
 <CAAHPopGAmoK2qD9=JyLcHr_0dPHEZ_FNstdCUyMbhQNijMMkJA@mail.gmail.com>
Date: Tue, 27 Oct 2015 18:25:56 +0100
Message-ID: 
 <CA+U3tt_jGzGaK=E-0R06y+e0jDmnsVkfGRofauNZO_=+S0svow@mail.gmail.com>
Subject: Re: QUESTION | Count (distinct column)
From: =?UTF-8?Q?Kasper_S=C3=B8rensen?= <i.am.kasper.sorensen@gmail.com>
To: "dev@metamodel.apache.org" <dev@metamodel.apache.org>
Content-Type: multipart/alternative; boundary=001a11c25a9cdeb8a80523195e23

--001a11c25a9cdeb8a80523195e23
Content-Type: text/plain; charset=UTF-8

Hi Ankit,

Good question.

Today there's only a way to fire an _equivalent_ query using a subquery. Of
this form:

  SELECT COUNT(*) FROM (SELECT DISTINCT columnA FROM tableX)

or alternatively:

  SELECT COUNT(*) FROM (SELECT columnA FROM tableX GROUP BY columnA)

I believe that adding a count distinct function would be possible tho'.
It's just not there yet. The suggestion was registered in JIRA quite some
time ago [1], but recently we made it much easier to plug in new functions,
so now might be the time to consider adding it.

Regards,
Kasper

[1] https://issues.apache.org/jira/browse/METAMODEL-168


2015-10-27 18:05 GMT+01:00 Ankit Kumar <ak.ankitkumar@gmail.com>:

> Hi All,
>
> In the Metamodel API is it possible to write a query for the below JDBC
> query.
>
> select count(distinct columnA) from tableX ;
>
> I somehow cannot find a way to write such a query using the Query API.
>
> Am I missing something or is this something to be added in the API ?
>
> Regards
> Ankit
>

--001a11c25a9cdeb8a80523195e23--