如何将Hive数据表移动到MySql？ [英] How to move Hive data table to MySql?

问题描述

我已经看过如何将配置单元数据移动到Amazon DynamoDB但不能用于RDBMS像MySQL。下面是我用DynamoDB看到的例子：

  CREATE EXTERNAL TABLE tbl1（名称字符串，位置字符串）
 STORED BY'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
 TBLPROPERTIES（dynamodb.table.name=table，
dynamodb.column.mapping=name：name，location ：位置） ; 
  

我想要做同样的事情，但用MySQL来代替。我想知道我是否需要编写自己的StorageHandler？我也不想使用sqoop。我希望能够直接在我的HiveQL脚本中进行查询。

解决方案

您目前需要一个JDBC StorageHandler，它一个尚未创建，但你可以确定自己建立。

目前有一个问题报告，你可以在这里看到：

https://issues.apache.org/jira / browse / HIVE-1555

I would like to know how I can move date from Hive to MySQL?

I have seen example on how to move hive data to Amazon DynamoDB but not for a RDBMS like MySQL. Here is the example that I saw with DynamoDB:

CREATE EXTERNAL TABLE tbl1 ( name string, location string )
STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
TBLPROPERTIES ("dynamodb.table.name" = "table",
"dynamodb.column.mapping" = "name:name,location:location") ;

I would like to do the same but with MySQL instead. I wonder if I need to code my own StorageHandler? I also to do not want to use sqoop. I want to be able to do my query directly in my HiveQL script.

解决方案

You'd currently need a JDBC StorageHandler, which one has not been created just yet, but you could certain build your own.

There is currently an issue report for this which you can follow here:

https://issues.apache.org/jira/browse/HIVE-1555

这篇关于如何将Hive数据表移动到MySql？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！