从hive获取数据并进入mysql@AWS？-gettingdataoutofhiveandintomysql@AWS?

I'd love to use Sqoop but don't think it is worth running the Cloudera stack @ AWS over ElasticMapReduce (which I really like) just for this.

我喜欢使用Sqoop,但不认为值得为此运行Cloudera堆栈@ AWS over ElasticMapReduce(我非常喜欢)。

My current thought is just to write the data I need moved to an external table housed @ S3 and then write a script to import it into mysql. Amazon has some stuff with SimpleDB (example), but I am not sure about that route either? Fine with the data living at S3, just wondering if anyone has a better idea.

我目前的想法只是将我需要的数据写入容纳@ S3的外部表,然后编写一个脚本将其导入mysql。亚马逊有一些SimpleDB的例子(例子),但我也不确定那条路线?很好的生活在S3的数据,只是想知道是否有人有更好的主意。

Thanks!

1 个解决方案