sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas Paris <nipari...@gmail.com>
Subject Direct Mode Postgres Query
Date Sat, 10 Feb 2018 16:10:51 GMT
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

Mime
View raw message