question Re: Can phoenix create coprocessors (triggers)? in Archives of Support Questions (Read Only)

Can phoenix create coprocessors (triggers)?

sunile_manjee — Fri, 20 May 2016 11:03:10 GMT

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.

Re: Can phoenix create coprocessors (triggers)?

ssoldatov — Fri, 20 May 2016 11:24:06 GMT

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

Re: Can phoenix create coprocessors (triggers)?

sunile_manjee — Fri, 20 May 2016 11:41:37 GMT

@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.

Re: Can phoenix create coprocessors (triggers)?

ssoldatov — Fri, 20 May 2016 13:47:43 GMT

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.