当前位置：首页 > news >正文

大数据相关积累

news 来源：原创 2024/4/26 22:14:40

HIVE

hive元数据
hive --service metastore -p 9083 &

修改元数据的hive-site

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
 <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>root@123</value>
    </property>
   <property>
        <name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEnconding=UTF-8</value>       
</property>
    <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>
<property>  
  <name>hive.metastore.local</name> 
  <value>true</value>  
</property> 
</configuration>

hive服务./hive --service hiveserver2 &

修改hive服务的hive-site

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
    <property>  
        <name>hive.metastore.uris</name> 
        <value>thrift://ctyun7:9083</value>  
    </property>
<property>  
  <name>hive.metastore.local</name>
  <value>false</value>  
</property>  
<!-- 这是hiveserver2 -->
        <property>
                 <name>hive.server2.thrift.port</name>
                 <value>10238</value>
        </property>

        <property>
                <name>hive.server2.thrift.bind.host</name>
                <value>ctyun9</value>
        </property>
</configuration>

hive数据库初始化
schematool -dbType mysql -initSchema

hive基础语句
create database txt1;
Show databases;
describe database txt1;
drop database txt1;
desc database extended 库名;
查看数据库创建的详细信息，包括配置的参数

namenode启动命令
namenode启动命令 ./hadoop-daemon.sh start namenode

hive连接
beeline -u jdbc:hive2://master:10000 -n root
参考
🐎🐎hive安装配置 Mysql 安装
https://blog.csdn.net/weixin_49471910/article/details/110786293
Hive MetaStore 启动配置
https://blog.csdn.net/qq_35260875/article/details/124731725
NameNode在安全模式safe mode
https://blog.csdn.net/weixin_41986096/article/details/109525886
Hadoop端口8020 9000 50070
https://blog.csdn.net/qq_46416934/article/details/124247205
HIVE修改默认端口指定端口
https://blog.csdn.net/weixin_43159039/article/details/122080027
Hive概念、架构、启动方式、基本命令
https://blog.csdn.net/weixin_52923290/article/details/124084012
Hive 学习笔记（启动方式，内置服务）
https://blog.51cto.com/u_14286115/3324890
Hive常用命令详解
https://www.modb.pro/db/491762
处理Linux中大量ESTABLISHED进程
https://blog.csdn.net/qq_40907977/article/details/103878127
https://blog.csdn.net/Molianna/article/details/118069525
https://blog.csdn.net/bluetjs/article/details/80965967/
linux中tcp连接不释放怎么办
https://www.php.cn/linux-493794.html