phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anishek Kamal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3831) Support stored procedure
Date Mon, 08 May 2017 08:21:04 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16000423#comment-16000423
] 

Anishek Kamal commented on PHOENIX-3831:
----------------------------------------

Hi [~giacomotaylor],
we are working on a project where we need to keep our front end (API layer) to be independent
of the backend because our application supports multiple backend like Oracle, MySQL and Hadoop
(Hbase/Hive). So we are planning to have our procedure name same to be configured at API layer.


While exploring we came to know that Phoenix support stored procedure. But if it didn't then
could you please explain how we can use parametarized query to fullfil the same ?
Thanks

> Support stored procedure
> ------------------------
>
>                 Key: PHOENIX-3831
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3831
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.7.0
>         Environment: centos 7, Hbase 1.2 , hadoop 6 node cluster
>            Reporter: Anishek Kamal
>              Labels: features
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> There are mainly two major problem - 
> 1) How to create Stored procedure in phoenix
> 2)How to create parameterized procedure
> I am using apache phoenix to connect to hbase, so that I can work on hbase using sql
commands.
> But I am stuck at this point, as I need stored procedure to work and also need to pass
input parameters.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message