Support Questions

Find answers, ask questions, and share your expertise

Can phoenix create coprocessors (triggers)?

avatar
Master Guru

Like hbase coprocessors does phoenix have the ability to create one which would essentially look like a sql create trigger statement. Maybe I should change this to idea if it doesn't exist.

1 ACCEPTED SOLUTION

avatar
Super Collaborator

We already have a similar idea logged : https://issues.apache.org/jira/browse/PHOENIX-932 But how to implement that it's still a question.

View solution in original post

3 REPLIES 3

avatar
Super Collaborator

@Sunile Manjee Could you give us an example how it's supposed to work?

avatar
Master Guru

@ssoldatov

Just similar RDBMS ddl trigger statement:

CREATE [ OR REPLACE ] TRIGGER trigger_name
BEFORE INSERT
   ON table_name
   [ FOR EACH ROW ]

DECLARE
   -- variable declarations

BEGIN
   -- trigger code

EXCEPTION
   WHEN ...
   -- exception handling

END;

However the semantics would be for hbase coprocessor. For example the trigger or coprocessing i want to do pre or post PUT.

avatar
Super Collaborator

We already have a similar idea logged : https://issues.apache.org/jira/browse/PHOENIX-932 But how to implement that it's still a question.