The relational SQL database is the canonical application data store. With a myriad number of different implementations, SQL databases are the foundation of the technical world.
If your database has a JDBC adapter and is in Amazon EC2, you can use Mortar to store data to it from Hadoop. Data is stored transactionally, so there’s no risk of having duplicate rows inserted. By using Pig on the cloud you can dynamically scale your analysis, then store the output back to your database for further use and ad-hoc queries.
Supported databases include: