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 <[email protected]> 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
