Support for Hive and Graph Databases

[ArchenROOT]

@ShelLuser - I didn’t test this solution yet, but another came to my head based on your answer here:

Export automatically DDL on commit/save project

Interesting idea. At the time of writing I don’t know how feasible it is, but I have done a little digging into the Plugin API and some things seem possible. The DatabaseManager interface provides methods such as generateCreateSQL() which might make this possible. However… I don’t see anything that is specifically related to exporting SQL code into a sql datafile and at this time I’m not sure if these methods do the same as (for example) the ‘create database’ and ‘generate SQL’ options which …

Scenario of automated DDL pipeline with support for Postgres and Hive:

1. I use DatabaseManager interface/or other exisitng in VP to generate from Java DDL for Postgres and store those in GIT repository (as some users work in development on postgres anyway with some objects)
2. Once commit arrives in GIT I will trigger Jenkins or other CI/CD pipeline which will take those DDL and populate real Postgres database instance with dummy structures only.
3. The I will trigger sqoop --create-hive-table to get Hive DDL syntax from Postgres live instance
   Sqoop User Guide (v1.4.2)
4. Store DDL for Hive in GIT alongside with latest Postgres DDL

Its not big deal, if you have any other idea let me know.

Thx for discussion.

Ladislav