I am currently looking to find out how I can sqoop a table from Hive (20 million rows of data) into an Oracle Table.
Unfortunately due to restrictions I am unable to connect Tableau to our Big Data platform and can only connect to our Oracle Tables in order to build some visuals. I know how to sqoop from Oracle into Hive but not the other way round and I even downloaded a csv version of the table from Hive but when I use the Import Data in SQL Developer this only brings in 500k rows of data and then stops.
If somebody could please help with suggesting any other way I can bring this data into Oracle, would appreciate it. I am not sure what the steps are to sqoop from Hive into Oracle but if this is possible would love it if somebody could share some steps with a dummy file or something.
Thanks in advance
Yes. you can use sqoop export option for Hive to Oracle DB
The official sqoop documentation has all the info that you require. Sqoop documentation
Example --> Transferring-bulk-data-between-oracle-database-and-hadoop-with-sqoop