Does Sqoop export work with Views? If not, you'll have to materialise the exact dataset you want to sqoop using a CTAS.
regards /Pelle On Fri, Dec 1, 2017 at 11:08 AM, Attila Szabó <[email protected]> wrote: > 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. > > > > -- *Per Ullberg* Datavault Tech Lead Odin (Uppsala) Klarna Bank AB (publ) Sveavägen 46, 111 34 Stockholm Tel: +46 8 120 120 00 <+46812012000> Reg no: 556737-0431 klarna.com
