hive和hbase表数据同步
来源:互联网 发布:cv source数据库 复旦 编辑:程序博客网 时间:2024/06/10 11:20
第一步:建立book_local
create external table book_load (
id int,
bcode String,
zcode String,
bname String,
author String,
publish String,
fcode String,
floor String
) row format delimited fields terminated by ','
第二步:建book_hive和book_hbase数据同步表
CREATE TABLE book_hive(
id String,
bcode String,
zcode String,
bname String,
author String,
publish String,
fcode String,
floor String)
row format delimited fields terminated by ','
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:bcode,info:zcode,info:bname,info:author,info:publish,info:fcode,info:floor")
TBLPROPERTIES ("hbase.table.name" = "book_hbase");
第三步:插入数据
insert into book_hbase select * from book_hive;
create external table book_load (
id int,
bcode String,
zcode String,
bname String,
author String,
publish String,
fcode String,
floor String
) row format delimited fields terminated by ','
第二步:建book_hive和book_hbase数据同步表
CREATE TABLE book_hive(
id String,
bcode String,
zcode String,
bname String,
author String,
publish String,
fcode String,
floor String)
row format delimited fields terminated by ','
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:bcode,info:zcode,info:bname,info:author,info:publish,info:fcode,info:floor")
TBLPROPERTIES ("hbase.table.name" = "book_hbase");
第三步:插入数据
insert into book_hbase select * from book_hive;
0 0
- hive和hbase表数据同步
- 将hbase中的表同步到hive和impala中
- mysql数据导入hive和hbase
- Hive和Hbase的数据整合联系
- Hive表数据导入到Hbase
- 1008-Hive访问HBase表数据
- 用hive外部表访问hbase数据
- Hive表数据导入到Hbase
- Hive数据导入HBase
- hive处理hbase数据
- HBASE数据导入HIVE
- hive导出hbase数据
- hadoop生态系统学习之路(八)hbase与hive的数据同步以及hive与impala的数据同步
- Hbase和Hive整合
- hbase和hive整合
- Hive和Hbase整合
- HIVE和HBASE区别
- hive和hbase整合
- Java递归实例
- linux软件管理
- Q:suse 11.1上安装R 3.2.2
- LeetCode 310. Minimum Height Trees(最小高度树)
- C# 矩形面积 0002
- hive和hbase表数据同步
- Rule of Three
- 正则表达式引擎实现体会
- 扩展欧几里得算法
- hbase集群安装(1)-ssh安装及配置
- Android的Touch系统简介(一)
- hbase集群安装(2)-ubuntu下jdk安装
- hbase集群安装(3)-安转Hadoop
- 安卓开发中一些小问题