sqoop - 使用 Sqoop，是否可以从 Oracle 视图而不是表执行配置单元导入？

Question

假设我有一个通过连接其他几个表创建的 Oracle 视图，可以将视图数据导入 Hive。

提前致谢

标签： sqoop

Answer 1

Yes it is possible as it is an object for sqoop and if we can fire a query, we can fetch data via sqoop. This can be also be checked from sqoop eval command and you can try to run to see if view is accessible or not.

sqoop eval (generic-args) (eval-args)