导入，互导操作hive,hbase

Elik-hb

已于 2024-04-21 12:27:04 修改

阅读量673

点赞数 13

分类专栏：大数据/hive/hbase 文章标签： hive hbase hadoop

于 2024-04-21 11:56:57 首次发布

本文链接：https://blog.csdn.net/qq_65099052/article/details/138029451

版权

本文介绍了如何在Hive和HBase之间进行数据导入和导出，包括创建Hive表、加载数据、数据类型转换以及HBase与Hive之间的映射操作。同时，讨论了处理数据类型不匹配的方法，如使用Hive函数进行转换。

摘要由CSDN通过智能技术生成

title: 导入，互导操作
date: 2023-10-31 00:35:49
categories:

大数据技术
tags:

CREATE TABLE test (
province STRING,
month STRING,
city STRING,
county STRING,
year STRING,
vehicle_model STRING,
manufacturer STRING,
brand STRING,
vehicle_type STRING,
ownership STRING,
usage STRING,
quantity STRING,
engine_model STRING,
displacement STRING,
power STRING,
fuel_type STRING,
length STRING,
width STRING,
height STRING,
cargo_length STRING,
cargo_width STRING,
cargo_height STRING,
axle_count STRING,
wheelbase STRING,
front_wheel_spacing STRING,
tire_specification STRING,
tire_count STRING,
total_weight STRING,
curb_weight STRING,
approved_load STRING,
approved_passenger_count STRING,
traction_weight STRING,
chassis_company STRING,
chassis_brand STRING,
chassis_model STRING,
engine_company STRING,
vehicle_name STRING,
age STRING,
gender STRING
)ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘,’
STORED AS TEXTFILE
TBLPROPERTIES (“skip.header.line.count”=“1”);

id name
1 zhang3
2 li4
3 wang5

CREATE TABLE poke (
id INT,
name STRING
)ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘,’
STORED AS TEXTFILE
TBLPROPERTIES (“skip.header.line.count”=“1”);

create ‘sanguo’, ‘info’

load data local inpath ‘/home/hadoop/Documents/sanguo.csv’ into table poke;

insert overwrite table sanguo select * from poke;

CREATE TABLE test (
province STRING,
month STRING,
city STRING,
district STRING,
year STRING,
vehicle_model STRING,
manufacturer STRING,
brand STRING,
vehicle_type STRING,
ownership STRING,
usage STRING,
quantity STRING,
engine_model STRING,
displacement STRING,
power STRING,
fuel_type STRING,
length STRIN