Please take a look at @Matt Clarke's response above on how to extract csv files only. It is the most straight forward way. ... View more

You can't. Sqoop can only be used to import from RDBMS to HDFS (and vice versa). It does not work with other file system interfaces. ... View more

@Andres Urrego Neither. Just use the "--warehouse-dir" flag with "import-all-tables". The directory you specify does not need to be a Hive warehouse directory. It can be anything and anywhere you specify in HDFS. The reason you're unable to use "--target-dir" is because that option is only available when all the imported data is to be placed in the one particular folder, whereas "import-all-tables" needs to create subfolders for each table. The "--warehouse-dir" flag only indicates the parent folder where you want all the data to go, and "import-all-tables" would be able to create subdirectories for each table brought in. I've assumed with the above that you want to import all tables. However, if you only want to import a few tables then your best bet is to write a (shell/perl/python/etc...) script that runs multiple Sqoop commands, with each one importing a table. Does that clarify things? ... View more

@Tinkle Mahendru Take a look at the example Nifi workflow template in the link below (SplitRouteMerge.xml): https://cwiki.apache.org/confluence/download/attachments/57904847/SplitRouteMerge.xml?version=1&modificationDate=1441745127000&api=v2 This flow demonstrates splitting a file(s) on line boundaries, routing the splits based on a regex in the content, and then merging the files together for storage somewhere. It will give you a good idea on how to process and merge your files. ... View more

@Narasimma varman Use the PutSQL and ExecuteSQL processors. You can read more about them and their usage at the below link. https://nifi.apache.org/docs.html You can configure them as below: Also, to get a better idea of how to chain the processors, take a look at the below article for an example flow that ingests data into a relational database using Nifi. https://www.batchiq.com/database-ingest-with-nifi.html As always, if you find this post helpful, don't forget to "accept" answer ... View more