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" <[EMAIL PROTECTED]> 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!