Navicat Premium 8.1.12激活(hive+mysql的伪分布式数据仓库搭建)

<!-- 描述集群中NameNode结点的URI(包括协议、主机名称、端口号) --> <property> <name>fs.defaultFS</name> <value>hdfs://vm-ubuntu:9000</value> </property> <property> <name>hadoop.tmp.dir</name> <value>/home/nqp/Documents/hadoop/hadoop-3.3.6/tmp</value> </property>

<configuration> <property> <name>dfs.replication</name> <value>1</value> </property> <property> <name>dfs.namenode.name.dir</name> <value>/home/nqp/Documents/hadoop/hadoop-3.3.6/tmp/dfs/name</value> </property> <property> <name>dfs.datanode.data.dir</name> <value>/home/nqp/Documents/hadoop/hadoop-3.3.6/tmp/dfs/data</value> </property> <property> <name>dfs.http.address</name> <value>0.0.0.0:50070</value> </property> </configuration>

 #MapReduce的执行模式，默认是本地模式
 <property> <name>mapreduce.framework.name</name> <value>yarn</value> </property> <property>#当开启后，小作业会在一个JVM上顺序运行，而不需要额外申请资源 <name>mapreduce.job.ubertask.enable</name> <value>true</value> </property> <property> <name>yarn.app.mapreduce.am.env</name> <value>HADOOP_MAPRED_HOME=/home/nqp/Documents/hadoop/hadoop-3.3.6</value> </property> <property> <name>mapreduce.map.env</name> <value>HADOOP_MAPRED_HOME=/home/nqp/Documents/hadoop/hadoop-3.3.6</value> </property> <property> <name>mapreduce.reduce.env</name> <value>HADOOP_MAPRED_HOME=/home/nqp/Documents/hadoop/hadoop-3.3.6</value> </property>

<!-- Site specific YARN configuration properties --> <property> <name>yarn.resourcemanager.hostname</name> <value>vm-ubuntu</value> </property> <property>#NodeManager上运行的附属服务 <name>yarn.nodemanager.aux-services</name> <value>mapreduce_shuffle</value> </property> <property> <name>yarn.nodemanager.pmem-check-enabled</name> <value>false</value> </property> <property> <name>yarn.nodemanager.vmem-check-enabled</name> <value>false</value> </property> <!-- 是否开启聚合日志 --> <property> <name>yarn.log-aggregation-enable</name> <value>true</value> </property> <!-- 存储容器日志的地方 --> <property> <name>yarn.nodemanager.log-dirs</name> <value>/home/nqp/Documents/hadoop/hadoop-3.3.6/logs</value> </property>

export HADOOP_COMMON_HOME=/home/nqp/Documents/hadoop/hadoop-3.3.6

export HADOOP_MAPRED_HOME=/home/nqp/Documents/hadoop/hadoop-3.3.6

export HIVE_HOME=/home/nqp/Documents/hive/hive-3.1.3

#测试链接mysql

/home/nqp/Documents/sqoop/sqoop-1.4.7/bin/sqoop Navicat Premium 8.1.12激活 list-databases –connect jdbc:mysql://localhost:3306/ –username root –password