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??";<[email protected]>; ????????: 2017??12??1??(??????) ????6:08 ??????: "user"<[email protected]>; ????: 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" <[email protected]> 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.
