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
Hey,

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,
Attila

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

Hello:

      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!
      thinks.

Mime
View raw message