Querying a database for Data load via SQL Command
In the same way, you can create a data space from another data source, you can import the data of that source using a JDBC connection.
SQL Command
Load
LOAD DATA INPATH 'jdbc:mysql://mysql_server:10000/default' INTO TABLE indexima_table QUERY 'SELECT * FROM mysql_table';
COMMIT indexima_table;
This will import all the data from the MySQL table named default.mysql_table into your Indexima table named default.indexima_table. The structure of the Indexima & Database tables must match for the command to be successful.
Supported Databases
Hive, MySQL, Oracle...
You will find a list of the currently supported databases here.
Not for a Hive SQL Query
If the Hive Table is partitioned, you must adapt the SQL statement and explicitly begin with the partitioned columns, then finish by a star:
SELECT Part_col1, Part_Col2,* FROM my_hive_table
More
You can learn more about the LOAD DATA INPATH commands here.