sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "qq" <987626...@qq.com>
Subject 回复: How to limit the number of rows to export data when using sqoopto export data from hdfs to oracle?
Date Fri, 01 Dec 2017 12:22:30 GMT
Hello:
Did you mean that? :
First build a hive view, and then check out hive table data into the hive view, set the number
of rows in the query process, and finally hive view the data exported to oracle table through
sqoop.
Looking forward to your reply!





------------------ 原始邮件 ------------------
发件人: "Attila Szabó";<maugli@apache.org>;
发送时间: 2017年12月1日(星期五) 晚上6:08
收件人: "user"<user@sqoop.apache.org>;

主题: Re: How to limit the number of rows to export data when using sqoopto export data
from hdfs to oracle?



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