sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Per Ullberg <per.ullb...@klarna.com>
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:21:14 GMT
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ó <maugli@apache.org> 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" <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.
>
>
>
>


-- 

*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

Mime
View raw message