Support Questions
Find answers, ask questions, and share your expertise

Stored-Proc-like Transformation Trigger for succeeding Hive inserts

Stored-Proc-like Transformation Trigger for succeeding Hive inserts

Contributor

We have two tables in Hive, the first one, let's call it Table A, is where the raw data is being dumped. The data in Table B is derived from Table A after some HiveQL transformation. (I understand there are no stored procedures in Hive). When new data will be inserted on Table A, how do we automatically trigger the process of doing the same transformation and appending the result on Table B?

1 REPLY 1

Re: Stored-Proc-like Transformation Trigger for succeeding Hive inserts

@J. D. Bacolod

You could check http://www.hplsql.org/ for stored procedures. These are available from HDP 2.6 with Hive interactive enabled.