AnsweredAssumed Answered

Export from Hive to database (SQL/MySQL)

Question asked by jblackwood on Nov 14, 2012
Latest reply on Nov 14, 2012 by tomer
My application requires pulling of data from a DynamoDB table to a SQL Server table.
I have been using Amazon's vanilla Hadoop distribution to write pull from DynamoDB, write to flatfiles on S3, download to disk, and use SSIS to pull the flatfiles and write to SQL Server.

With my current workflow, there are too many moving pieces.  I'd like to be able to either use Hive to write to an external database, or use the Mapr ODBC driver to query the data in a C# console application.

Is it possible to accomplish this?

Outcomes