用docker搭建hadoop、hive环境

小小小小小小满

已于 2022-04-13 18:10:51 修改

阅读量1.7k

点赞数

文章标签：大数据

于 2022-04-12 17:57:27 首次发布

本文链接：https://blog.csdn.net/qq_35602407/article/details/124130227

版权

git clone https://github.com/big-data-europe/docker-hive.git

cd docker-hive

docker-compose up -d

docker-compose exec hive-server bash

/opt/hive/bin/beeline -u jdbc:hive2://localhost:10000

CREATE TABLE pokes (foo INT, bar STRING);

LOAD DATA LOCAL INPATH '/opt/hive/examples/files/kv1.txt' OVERWRITE INTO TABLE pokes;

hsql练习：

CREATE DATABASE cost;

show databases;

DROP DATABASE IF EXISTS cost;

create table cost.cost (id int, type String, `date` String, `user` String, cost float, note String, `state` int, clear_date String, alipay_uid String, type2 String) comment 'cost' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

use cost;

show tables;

LOAD DATA LOCAL INPATH '/tmp/cost.csv' OVERWRITE INTO TABLE cost.cost;

select * from cost.cost;