Cloudera Community
keroz
user rank
New Contributor

Re: Ingesting dump db (.sql) into hdfs

by New Contributor in Support Questions
‎07-19-2023 08:21 PM
‎07-19-2023 08:21 PM
Hi ggangadharan,   Thanks for you feedback. Maybe I need to explain more detail on my case above. Both solution you give more to sqoop/import the data using the JDBC. My current situation, the source system not give the permission to access their db. They will export the file and save as .sql file. I need to download the file and load into hive table.   ... View more

Ingesting dump db (.sql) into hdfs

by New Contributor in Support Questions
‎07-10-2023 11:35 PM
‎07-10-2023 11:35 PM
Hi All, I need to ingest data from database dump (.sql) file. May I know, the best method how to load the data into hive table? Below are some info the file we need to ingest.  <database name>_<table name>_yyyymmdd.sql <database name> is the name of the database exported. ‘yyyymmdd’ is the date the file was created. Regards, Khairul ... View more
Contact Me
Online
Offline
Last Visited
‎08-16-2023 04:29 AM
Community Statistics
Member Since ‎07-10-2023 11:19 PM
Last Visited ‎08-16-2023 04:29 AM
Posts 2