Which mass insertion tool can be used in the Hadoop connection?

[parveshp7822672]

Hello Friends,

We have connection between campaign and Hadoop via hive view.

Connection is working fine. But the performance is not good. To download the 4 Gb data it takes 4hr or more.

Network speed is good. We find that this is due the limitation on ODBC driver. ODBC driver does not support the Bach load. As mentioned in the below link.

https://docs.microsoft.com/en-us/sql/relational-databases/native-client-odbc-bulk-copy-operations/pe...

I saw there is an option to  define the mass insert tool In the external connection in adobe campaign as shown in below screenshot.

Can you please let me know which tools and how we use them there?

We are also getting the waring that bulk loading is not available.

Please find the below screenshot.

Can you please let me know how we can enable the bulk loading?

Thanks in advance.

Parvesh.