You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:18:27 UTC

[jira] [Resolved] (PHOENIX-537) Support for hashing functions

     [ https://issues.apache.org/jira/browse/PHOENIX-537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-537.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Support for hashing functions
> -----------------------------
>
>                 Key: PHOENIX-537
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-537
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 2.1.0-Release
>            Reporter: walshms
>
> We'd like to generate composite row keys using hashed strings and a date. Adding a hash function MD5 would allow us to query like this: 
> SELECT * FROM log_history 
> WHERE siteID= md5(?) AND logID = md5(?) AND login_date > CURRENT_DATE()-1



--
This message was sent by Atlassian JIRA
(v6.2#6252)