<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LookDreamGo的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/LookDreamGo</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; LookDreamGo]]></copyright><item><title><![CDATA[比较全的时间日期维表sql]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/122089585</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/122089585</guid><author>LookDreamGo</author><pubDate>Wed, 22 Dec 2021 16:43:25 +0800</pubDate><description><![CDATA[--日期维表基本信息
       with  tmp_es_date_00 as 
       (
        select  
        regexp_replace(predict_date_day,'-','')                                                           as date_id             -- 日(yyyymmdd)
       ,predict_date_day                   ]]></description><category></category></item><item><title><![CDATA[hive如何生成数据字典]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/122089010</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/122089010</guid><author>LookDreamGo</author><pubDate>Wed, 22 Dec 2021 16:39:15 +0800</pubDate><description><![CDATA[一、连接hive元数据库
执行下面sql即可
-- 查看hive里表和字段字典信息
-- 如果是用create table 的方式建的表，这里是查不到的。
-- 建的表必须要有表注释，否则查不出来。
select 
	 d.name as db_name               -- 数据库名
	,c.tbl_name                     -- 表名
	,e.param_value as tbl_name_desc -- 表中文注释
	,a.integer_idx as column]]></description><category></category></item><item><title><![CDATA[Azkaban3.38安装步骤——亲测]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/102683972</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/102683972</guid><author>LookDreamGo</author><pubDate>Tue, 22 Oct 2019 16:14:03 +0800</pubDate><description><![CDATA[Azkaban安装步骤
1.下载Azkaban的源码
  wget https://github.com/azkaban/azkaban/archive/3.38.0.tar.gz
  tar -zxvf azkaban-3.38.0.tar.gz -C /opt/source/
  cd azkaban-3.38.0/
  wget https://services.gradle.org/dis...]]></description><category></category></item><item><title><![CDATA[Mycat读写分离、主从切换、分库分表的操作记录]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/102524917</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/102524917</guid><author>LookDreamGo</author><pubDate>Sat, 12 Oct 2019 17:48:33 +0800</pubDate><description><![CDATA[非常好的一片文章，已实践，请大家查看
文章原创地址

]]></description><category></category></item><item><title><![CDATA[Linux-----mysql双机同时备份方法]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/100915503</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/100915503</guid><author>LookDreamGo</author><pubDate>Tue, 17 Sep 2019 09:12:52 +0800</pubDate><description><![CDATA[参考百度链接    https://jingyan.baidu.com/article/8275fc869f110c46a03cf6e6.html
主mysql 服务器ip 192.168.13.177    备mysql服务器ip 192.168.13.187
实现两台mysql同时备份
首先两台服务器能互通，设置mysql能远程连接
1、在主mysql（ip192.168.13.177） 切换...]]></description><category></category></item><item><title><![CDATA[mysql数据库用户权限设置以及如何进行数据库定时备份步骤]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/97900412</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/97900412</guid><author>LookDreamGo</author><pubDate>Wed, 31 Jul 2019 12:01:38 +0800</pubDate><description><![CDATA[一、用户权限步骤
创建新用户

create user ‘gggg’@‘hostlocal’ identified by ‘123’;

#在本机上创建一个密码为123的用户，只可在本机进行操作

create user ‘alex’@’%’ identified by ‘123’;

#创建一个密码为123的alex用户，%表示所有人都可在任何机器上登陆

create user ‘eva’@‘...]]></description><category></category></item><item><title><![CDATA[内网环境NTP服务及时间同步(CentOS6.x)配置和部署]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/97522503</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/97522503</guid><author>LookDreamGo</author><pubDate>Sat, 27 Jul 2019 16:01:44 +0800</pubDate><description><![CDATA[1、NTP时间同步方式选择
NTP同步方式在linux下一般两种：使用ntpdate命令直接同步和使用NTPD服务平滑同步
2、安装配置
CentOS 6.3系统已经自带了NTPD服务，一般默认是按照了的，如果没有安装，先检查下，然后配置好yum仓库，yum方式安装下就OK，具体如下：
# rpm -q ntp
ntp-4.2.4p8-2.el6.x86_64    // 这表示已安装了，如果没有...]]></description><category></category></item><item><title><![CDATA[kettle8.2-win7安装步骤]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/90749437</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/90749437</guid><author>LookDreamGo</author><pubDate>Mon, 03 Jun 2019 11:29:33 +0800</pubDate><description><![CDATA[一:在win7搭建Kettle 8.2的使用环境
二：  提前下载好下面的两个包
pdi-ce-8.2.0.0-342.zip
jdk-8u181-windows-x64
三：步骤
1.安装jdk，具体步骤百度即可，网上有很多步骤
2.配置jdk的环境变量
右击桌面上的计算机，选择属性-高级系统设置；
在系统属性界面，选择高级-环境变量；
在环境变量界面中选择系统变量下的新建，建立如下的变量；
J...]]></description><category></category></item><item><title><![CDATA[如何快速生成数据库字典]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/90480192</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/90480192</guid><author>LookDreamGo</author><pubDate>Thu, 23 May 2019 14:40:37 +0800</pubDate><description><![CDATA[一：采用Navicat数据库连接工具
二：点击进入想要生成的数据库中

三：将下面的SQL语句在新建查询中进行查询即可


SELECT
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
DATA_TYPE 字段类型,
CHARACTER_MAXIMUM_LENGTH 长度,
IS_NULLABLE 是否为空,
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT...]]></description><category></category></item><item><title><![CDATA[关于linux安装kettle的总结]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/90449219</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/90449219</guid><author>LookDreamGo</author><pubDate>Wed, 22 May 2019 18:09:57 +0800</pubDate><description><![CDATA[一.部署准备
1.1 JDK安装配置


命令行键入“cd /etc”进入etc目录



命令行键入“vi profile”打开profile文件



敲击键盘ctrl+F到文件末尾



在末尾处，即第一个~的地方，敲击键盘将以下内容输入到文件

export JAVA_HOME=/usr/java/jre1.8.0_45
export PATH=JAVAHOME/bin:JAVA_HOME...]]></description><category></category></item><item><title><![CDATA[关于数据库mysql遇到的一些乱码的坑]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/90413140</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/90413140</guid><author>LookDreamGo</author><pubDate>Tue, 21 May 2019 19:08:45 +0800</pubDate><description><![CDATA[一、关于遇到数据库出现乱码问题解决方法
linux上进人  vi/etc/my.cnf
如果找不到my.cnf    —请执行find  / -name my.cnf   即可找到my.cnf位置
进入此文件后添加
character-set-server=utf8
collation-server=utf8_general_ci
[client]
default-character-set=ut...]]></description><category></category></item><item><title><![CDATA[mysql详细安装步骤]]></title><link>https://blog.youkuaiyun.com/LookDreamGo/article/details/90412262</link><guid>https://blog.youkuaiyun.com/LookDreamGo/article/details/90412262</guid><author>LookDreamGo</author><pubDate>Tue, 21 May 2019 18:11:06 +0800</pubDate><description><![CDATA[**本文链接：(https://mp.youkuaiyun.com/mdeditor#)
切换目录
cd /usr
创建目录
mkdir mysql
cd mysql
下载 Mysql Yum
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
安装 Yum
rpm -ivh mysql57-community-relea...]]></description><category></category></item></channel></rss>