phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: select distinct on a casted value
Date Wed, 30 Jul 2014 18:45:50 GMT
Not a known issue as far as I know. Please file a JIRA. If you can try
against the latest in the 3.0 branch to see if the problem is fixed
already, that would be much appreciated.
Thanks,
James

On Wed, Jul 30, 2014 at 11:20 AM, Abe Weinograd <abe@flonet.com> wrote:
> I am testing some queries in Squirrel.  Because we are using unsigned_date,
> squirrel isn't terribly happy about that and I frequently am casting those
> values to date or timestamp.
>
> When I do SELECT CAST(column1 AS TIMESTAMP), ... FROM table  that seems to
> work fine.
>
> If I put a distinct in front of that, I always get NULL.
> SELECT DISTINCT CAST(column1 AS TIMESTAMP) FROM table
>
> Removing the distinct and doing a group by on the column also works
> properly.
> SELECT CAST(column1 AS TIMESTAMP) FROM table GROUP BY column1
>
> I couldn't find a JIRA for this, is it a known issue?  Currently using 3.0
> on CDH4.6 (HBase 0.94.15)
>
> Thanks,
> Abe

Mime
View raw message