[
https://issues.apache.org/jira/browse/PHOENIX-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16000423#comment-16000423
]
Anishek Kamal edited comment on PHOENIX-3831 at 5/9/17 1:04 PM:
----------------------------------------------------------------
Hi [~jamestaylor],
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
was (Author: anishekkamal26):
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)
