[jira] [Created] (PHOENIX-3831) Unable to create stored procedure
Anishek Kamal created PHOENIX-3831: -- Summary: Unable to create stored procedure Key: PHOENIX-3831 URL: https://issues.apache.org/jira/browse/PHOENIX-3831 Project: Phoenix Issue Type: Task Affects Versions: 4.7.0 Environment: centos 7, Hbase 1.2 , hadoop 6 node cluster Reporter: Anishek Kamal There are mainly two major problem - 1) How to create Stored procedure in phoenix 2)How to create parameterized procedure -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (PHOENIX-3831) Unable to create stored procedure
[ https://issues.apache.org/jira/browse/PHOENIX-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anishek Kamal updated PHOENIX-3831: --- Description: 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. was: There are mainly two major problem - 1) How to create Stored procedure in phoenix 2)How to create parameterized procedure > Unable to create stored procedure > - > > Key: PHOENIX-3831 > URL: https://issues.apache.org/jira/browse/PHOENIX-3831 > Project: Phoenix > Issue Type: Task >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)
[jira] [Commented] (PHOENIX-3831) Support stored procedure
[ 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)
[jira] [Comment Edited] (PHOENIX-3831) Support stored procedure
[ 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)
[jira] [Commented] (PHOENIX-3831) Support stored procedure
[ https://issues.apache.org/jira/browse/PHOENIX-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16004231#comment-16004231 ] Anishek Kamal commented on PHOENIX-3831: Waiting for your response [~jamestaylor]. > 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)