<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Tomas_White的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Tomas_White</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Tomas_White]]></copyright><item><title><![CDATA[Ollama+deepseek+AnythingLLM 本地部署完全指南创建本地知识库]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/145844500</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/145844500</guid><author>Tomas_White</author><pubDate>Tue, 25 Feb 2025 09:40:29 +0800</pubDate><description><![CDATA[Ollama+deepseek+AnythingLLM 本地部署完全指南创建本地知识库]]></description><category></category></item><item><title><![CDATA[IDEA创建spring项目提示“Cannot download “https://start.spring.io‘: connect timed out”解决]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/143887323</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/143887323</guid><author>Tomas_White</author><pubDate>Tue, 19 Nov 2024 16:02:44 +0800</pubDate><description><![CDATA[输入地址https://start.spring.io或者https://start.spring.io/或者http://start.spring.io三选一。创建spring项目时提示连接超时Cannot download "https://start.spring.io’: connect timed out。三、还可以在创建的过程中修改地址。二、在设置中进行配置。]]></description><category></category></item><item><title><![CDATA[Hive练习题，持续更新！！！！]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/126890580</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/126890580</guid><author>Tomas_White</author><pubDate>Fri, 16 Sep 2022 17:24:07 +0800</pubDate><description><![CDATA[hive练习题]]></description><category></category></item><item><title><![CDATA[Hive常用操作持续更新！！！学习笔记]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/126452248</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/126452248</guid><author>Tomas_White</author><pubDate>Sun, 21 Aug 2022 16:29:32 +0800</pubDate><description><![CDATA[个人学习hive的笔记]]></description><category></category></item><item><title><![CDATA[数据仓库项目——业务数据生成]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106923589</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106923589</guid><author>Tomas_White</author><pubDate>Tue, 23 Jun 2020 15:02:13 +0800</pubDate><description><![CDATA[使用MySQL链接工具链接MySQL（我使用的是Navicat）

创建一个名为gmall的数据库
导入SQL脚本生成对应的表以及数据

文件已分享，可自行下载
链接: https://pan.baidu.com/s/1rrbM4FGChktr3wQxm8QN7g
提取码: 5x8e
生成业务数据

在/opt/module/创建一个db_log文件夹

mkdir db_log/


上传gmall-mock-db-2020-03-16-SNAPSHOT.jar 和 application.propert]]></description><category></category></item><item><title><![CDATA[SQL语法]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106690203</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106690203</guid><author>Tomas_White</author><pubDate>Thu, 11 Jun 2020 15:45:22 +0800</pubDate><description><![CDATA[联合

union和union all
连接俩个sql语句的结果
union语法：如果表二中查出的数据与表一中的数据重复则去重
SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;
union all语法：表一与表二中的数据全连接
SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;
minus
minus函数]]></description><category></category></item><item><title><![CDATA[INNER JOIN，LEFT JOIN，RIGHT JOIN，FULL OUTER JOIN]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106492603</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106492603</guid><author>Tomas_White</author><pubDate>Tue, 02 Jun 2020 11:26:33 +0800</pubDate><description><![CDATA[INNER JOIN：交集连接，取出俩个表交集的数据
LEFT JOIN：左外连接，取出俩个表中左表的数据
RIGHT JOIN：右外连接，取出俩个表中右表的数据
FULL OUTER JOIN：全连接，取出俩个表中所有数据

]]></description><category></category></item><item><title><![CDATA[hive]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106478096</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106478096</guid><author>Tomas_White</author><pubDate>Mon, 01 Jun 2020 17:32:41 +0800</pubDate><description><![CDATA[启动hiveserver2
./hiveserver2
beeline连接
启动beeline
!connect jdbc:hive2://hdp-1:10000


]]></description><category></category></item><item><title><![CDATA[虚拟机中搭建FTP服务器]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106465604</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106465604</guid><author>Tomas_White</author><pubDate>Mon, 01 Jun 2020 08:50:18 +0800</pubDate><description><![CDATA[1. 下载

yum -y install vsftpd

yum -y install ftp

2. 启动FTP服务器

systemctl start vsftpd.service

// 查看服务器状态

systemctl status vsftpd.service

3.配置vsftpd.conf

4.外部访问

ftp://hadoop104/
]]></description><category></category></item><item><title><![CDATA[Yarn的执行流程]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106175764</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106175764</guid><author>Tomas_White</author><pubDate>Sun, 17 May 2020 16:04:02 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[Flume拦截器]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106091236</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106091236</guid><author>Tomas_White</author><pubDate>Wed, 13 May 2020 09:48:32 +0800</pubDate><description><![CDATA[LogETLInterceptor
package com.atguigu.flume.interceptor;

import org.apache.flume.Context;
import org.apache.flume.Event;
import org.apache.flume.interceptor.Interceptor;

import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.List;.]]></description><category></category></item><item><title><![CDATA[数据仓库项目——数据准备]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106091153</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106091153</guid><author>Tomas_White</author><pubDate>Wed, 13 May 2020 09:45:30 +0800</pubDate><description><![CDATA[使用idea编写，模拟数据产生



pom.xml


 &lt;!--版本号统一--&gt;
    &lt;properties&gt;
        &lt;slf4j.version&gt;1.7.20&lt;/slf4j.version&gt;
        &lt;logback.version&gt;1.0.7&lt;/logback.version&gt;
    &lt;/properties&gt;

    &lt;dependencies&gt;
        &lt;!--]]></description><category></category></item><item><title><![CDATA[数据仓库项目——集群搭建]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/106031557</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/106031557</guid><author>Tomas_White</author><pubDate>Sun, 10 May 2020 08:38:17 +0800</pubDate><description><![CDATA[1.虚拟机三台
2.jdk环境变量
jdk版本：jdk-8u144-linux-x64.tar
环境变量配置/etc/profile.d/env.sh
#JAVA_HOME 
export JAVA_HOME=/opt/module/jdk1.8.0_144 
export PATH=$PATH:$JAVA_HOME/bin
配置完需要source /etc/profile.d/env.sh

Hadoop环境变量
Hadoop版本：hadoop-2.7.2.tar
环境变量配置/etc/profile.d]]></description><category></category></item><item><title><![CDATA[Flink 数据读取api]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/104266091</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/104266091</guid><author>Tomas_White</author><pubDate>Tue, 11 Feb 2020 17:12:33 +0800</pubDate><description><![CDATA[读取数据
1.创建一个实例用于数据存储
case class SensorReading(id: String, timestamp: Long, temperrture: Double)

1.从数组中读取数据
object SourceDemo {
  def main(args: Array[String]): Unit = {
    val env: StreamExecutionEnv...]]></description><category></category></item><item><title><![CDATA[Flink俩个入门实例]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/104265769</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/104265769</guid><author>Tomas_White</author><pubDate>Tue, 11 Feb 2020 17:03:12 +0800</pubDate><description><![CDATA[Flink处理数据

目录结构



pom文件


     &lt;dependency&gt;
            &lt;groupId&gt;org.apache.flink&lt;/groupId&gt;
            &lt;artifactId&gt;flink-scala_2.12&lt;/artifactId&gt;
            &lt;version...]]></description><category></category></item><item><title><![CDATA[Eureka注册中心搭建]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/103715793</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/103715793</guid><author>Tomas_White</author><pubDate>Thu, 26 Dec 2019 15:11:42 +0800</pubDate><description><![CDATA[Eureka注册中心搭建

总目录结构






#### eureka-server : Eureka服务

目录结构





pom依赖


        &lt;!-- springboot web --&gt;
     &lt;dependency&gt;
       &lt;groupId&gt;org.springframework.boot&lt;/gr...]]></description><category></category></item><item><title><![CDATA[binlog]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/103608277</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/103608277</guid><author>Tomas_White</author><pubDate>Thu, 19 Dec 2019 09:01:17 +0800</pubDate><description><![CDATA[binlog

基本认识

Mysql的二进制日志文件

查看日志文件命令

mysqlbinlog --no-defaults /usr/

查看mysql是否开启binlog，为OFF为未开启


mysql&gt; show variables like '%log_bin%';
+---------------------------------+-------+
| Variable_n...]]></description><category></category></item><item><title><![CDATA[大数据项目]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/103459690</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/103459690</guid><author>Tomas_White</author><pubDate>Mon, 09 Dec 2019 16:05:27 +0800</pubDate><description><![CDATA[大数据实训项目
数据流程图

离线处理数据
需求
手机App log：统计一周内用户版本分布比例
思路

实时处理数据
需求

]]></description><category></category></item><item><title><![CDATA[Azkaban安装配置]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/103394818</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/103394818</guid><author>Tomas_White</author><pubDate>Wed, 04 Dec 2019 21:26:44 +0800</pubDate><description><![CDATA[Azkaban安装与配置

1.将Azkaban压缩包上传

2.解压unzip azkaban.zip

3.在/root/apps/azkaban/azkaban-web-2.5.0目录下生成 keystore 的密码及相应信息


keytool -keystore keystore -alias jetty -genkey -keyalg RSA

4.生成时区文件


tzselect
...]]></description><category></category></item><item><title><![CDATA[Flink安装及配置]]></title><link>https://blog.youkuaiyun.com/Tomas_White/article/details/103350060</link><guid>https://blog.youkuaiyun.com/Tomas_White/article/details/103350060</guid><author>Tomas_White</author><pubDate>Mon, 02 Dec 2019 15:47:38 +0800</pubDate><description><![CDATA[Flink安装及配置

搭建单机模式

1.下载Flink，要匹配自己的hadoop版本和Scala版本

2.将Flink上传到虚拟机中解压


tar -zxvf flink-1.7.2-bin-hadoop28-scala_2.11.tgz

3.配置环境变量 vi /etc/profile


#Filnk-1.7.2
export FLINK_HOME=/root/apps/flink-...]]></description><category></category></item></channel></rss>