HouYing

Hive数据去重举例：Hql代码 INSERT overwrite TABLE store SELECT t.p_key, t.sort_wordFROM ( SELECT p_key, sort_word, row_number () over ( distribute BY p_key sort BY sort_word ...

建立个测试表CREATE TABLE nj_stat_composite ( id bigint, name string, org_id string, deal_count int, deal_count_ratio float, abnormal_count int, abnormal_count_ratio float, deal_cost int, avg_count int, avg_count_ratio float, create_time

create table test_table ( test_string string, test_int int, test_array array<string>, test_struct struct<test_struct_string:string, test_struct_int:int>, test_map map<string,...

hive 安装过程：1.修改主机名hostnamectl set-hostname master2，做IP和主机名的映射vim /etc/hosts192.168.31.27 master3，关闭防火墙systemctl stop firewalld.service3，时间设置查看当前时间输入:date查看服务器时间是否一致，若不一致则更改更改时间...

服务器环境是Centeros71.安装mysql rpm -qa|grep mariadb rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86_64rpm -e --nodeps mariadb-5.5.56-2.el7.x8...

docker ps -a 查看所有容器docker start containerID 启动容器docker rm containerIDdocker stop containerIDdocker rmi imageIDdocker imagesdocker rmi 31ca583bc130docker rm af8496cf032egzip ...