Compare hive and MySQL complex logical stream processing

1.Mysql of stored procedures and functions to implement complex logic processing, the comparison is as follows:
The stored procedure is used as an executable file, compiled once in the database, and the function returns a value. You can set usage permissions.

A cursor can be used in a stored procedure to declare a variable. Called with call.

2.Hive available UDF (user defined function) for complex logic processing

• Edit a Python script

Commonly used Python string splitting processing functions are: Split and so on

• Load UDF

• Call UDF

HQL syntax

you can re-write the returned results to another table, where the as post field matches the inserted table fields .

Compare hive and MySQL complex logical stream processing