Hello After some testing, sqoop --direct mode the best way to get data from postgres.
However, this mode is limited to a --table: it is not possible to pass any --query. Sadly, postgres COPY command allows to pass a query. This would be then in theory feasible to export from any SQL query with --direct mode. My use case, is I do not want to export multiple tables from postgres, but one SQL composition of the tables. The alternative would be to create a view inside postgres to mimic a table. But I do not have the sufficient privileges to do so. Thanks for any feedbac