sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Attila Szabó <mau...@apache.org>
Subject Re: How to limit the number of rows to export data when using sqoop to export data from hdfs to oracle?
Date Fri, 01 Dec 2017 10:08:00 GMT

If you're trying to export from Hive into RDBMS I would suggest creating a
Hive view and only export the content of the view. Thus you could directly
control the data quantity by the underlying HiveQL query.

My 2cents,

On Dec 1, 2017 10:54 AM, "qq" <987626311@qq.com> wrote:


      I have a question on the export of sqoop need your help, the problem
is as follows:
      How to limit the number of rows that need to be exported when
exporting data from hdfs to oracle using sqoop?
      For example: hive data stored in the hdfs 100 lines, just want the
first 10 lines of data through sqoop exported to the oracle table, how to
achieve through sqoop?
      I am looking forward to your reply!

View raw message