<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ye_chen_的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ye_chen_</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ye_chen_]]></copyright><item><title><![CDATA[atlas rest api - 使用rdb类型创建实例]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142873388</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142873388</guid><author>ye_chen_</author><pubDate>Sat, 12 Oct 2024 11:19:20 +0800</pubDate><description><![CDATA["description": "dwd_sale_saleorderd_i的数据来自ods_sga_saleorderdtl,ods_sga_saleorder, ods_bd_customer,ods_t_sys_org",//dwd_sale_saleorderd_i的guid，创建实体从返回的信息中获取。//rdbms_instance的guid，创建实体从返回的信息中获取。//rdbms_instance的guid，创建实体从返回的信息中获取。--删除entity。]]></description><category></category></item><item><title><![CDATA[hive建表解决中文乱码]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142873351</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142873351</guid><author>ye_chen_</author><pubDate>Sat, 12 Oct 2024 11:17:59 +0800</pubDate><description><![CDATA[1.2 在 mysql 修改hive元数据表注释和字段注释的编码为 utf-8。修改表字段注解和表注解。]]></description><category></category></item><item><title><![CDATA[Sqoop导入数据至hive卡死在hive.HiveImport: Connecting to jdbc:hive2不执行...]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859480</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859480</guid><author>ye_chen_</author><pubDate>Sat, 12 Oct 2024 11:17:07 +0800</pubDate><description><![CDATA[添加配置user=hdfs;暂时未找到永久的解决办法。]]></description><category></category></item><item><title><![CDATA[数据中台部署-Oracle数据库版本不支持DBLOGREADER抽取数据]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859419</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859419</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:29:51 +0800</pubDate><description><![CDATA[需要Oracle 10.2.0.5或11.2.0.2或更新的库版本才能使用DBLOGREADER方式。]]></description><category></category></item><item><title><![CDATA[数据中台部署-zk启动正常，但是连不上Factory method ‘zkService‘ threw exception； nested exception is java.lang.Excepti]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859400</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859400</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:29:20 +0800</pubDate><description><![CDATA[原因分析：zk连接数过多。]]></description><category></category></item><item><title><![CDATA[数据中台部署-storm启动Topology 无工作节点]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859376</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859376</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:28:18 +0800</pubDate><description><![CDATA[原因：storm配置里面的端口被用完了。解决办法：配置中增加端口号。]]></description><category></category></item><item><title><![CDATA[数据中台部署-dbus启动拓补异常]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859354</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859354</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:27:46 +0800</pubDate><description><![CDATA[解决办法：配置中心-重新初始化storm。问题原因：storm包获取异常。]]></description><category></category></item><item><title><![CDATA[数据中台部署-zk报错zookeeper.ClientCnxn: Socket connection established，Will not attempt to authenticate]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859324</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859324</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:27:03 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[数据中台部署-resource manage无法启动，Connection failed to http://djt-0001:8088 ([Errno 104] Connection res]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859308</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859308</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:26:25 +0800</pubDate><description><![CDATA[使用指定配置文件启动，更新配置influxd -config /etc/influxdb/influxdb.conf。/etc/influxdb/influxdb.conf中没有reporting相关端口配置8088，手工打开注释。原因：8088端口与influxdb冲突。解决办法：修改influxdb端口。]]></description><category></category></item><item><title><![CDATA[数据中台部署-KeeperErrorCode = NoNode for /atsv2-hbase-unsecure/meta-region-server]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859283</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859283</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:25:31 +0800</pubDate><description><![CDATA[前段时间在虚拟机安装ambari之后一直也没有做测试，今天起来将集群启动发现有些组件启动时遇见一些问题，在这里记录一下。1. DataNode 无法启动DataNode启动成功后就死掉了。需要将YARN中的配置 YARN>CONFIGS>ADVANCED>yarn-hbase-site>zookeeper.znode.parent 的值修改为 HBase 中的配置的值ZooKeeper Znode Parent。Ambari 环境启动时遇到的一些问题记录 | hnbian。]]></description><category></category></item><item><title><![CDATA[数据中台部署-DBus心跳异常]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859258</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859258</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:24:36 +0800</pubDate><description><![CDATA[2.修改配置文件中相关占位符，匹配dbus的conf.properties配置。检查init的时候 dbus-heartbeat是否正常解压及修改配置项。1.修改conf文件夹名称。看日志发现心跳插入数据异常。]]></description><category></category></item><item><title><![CDATA[数据中台部署-DBus初始化storm配置报错]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859237</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859237</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:23:59 +0800</pubDate><description><![CDATA[解决办法：]]></description><category></category></item><item><title><![CDATA[数据中台部署-DBus登录不了，nginx访问500报错]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859225</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859225</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:23:27 +0800</pubDate><description><![CDATA[问题原因：教程中的build文件解压目录有问题，导致无法找到文件。修改build解压路径到正确的安装路径，我的是。]]></description><category></category></item><item><title><![CDATA[数据中台部署-init Dbus时出现文件找不到]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859198</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859198</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:22:21 +0800</pubDate><description><![CDATA[Exception in thread "main" java.io.FileNotFoundException: ./dbus-heartbeat-0.5.0/conf/consumer.properties (没有那个文件或目录)直接创建文件夹 给文件夹授权。]]></description><category></category></item><item><title><![CDATA[数据中台部署-Nginx启动失败 nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address already in use)与httpd冲突]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859176</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859176</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:21:50 +0800</pubDate><description><![CDATA[解决办法：修改httpd监听端口，# 修改httpd服务的监听端口。# 打开httpd配置文件。]]></description><category></category></item><item><title><![CDATA[数据中台部署-Permission denied: user=root, access=WRITE, inode=“/user“:hdfs:hdfs:drwxr-xr-x]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859119</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859119</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:21:04 +0800</pubDate><description><![CDATA[解决方案：切换hdfs用户 给hadoop用户操作权限 或修改hdfs目录权限。]]></description><category></category></item><item><title><![CDATA[数据中台部署-（sudo ambari-server start）Ambari启动报错：]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142859010</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142859010</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:16:16 +0800</pubDate><description><![CDATA[当客户端连接服务端超时(超过connect_timeout), 服务端就会给这个客户端记录一次error，当出错的次数达到max_connect_errors的时候，这个客户端就会被锁定。所以根据业务来尽量把这个值设置大一点，mysql默认值为10，我们可以根据具体需要设置大一点，这里设置为1000.（并非越大越好，越大被攻击时安全性越低）。同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞；到这一步，就解决了问题了。]]></description><category></category></item><item><title><![CDATA[数据中台部署-安装mysql报错 The GPG keys listed for the “MySQL5.7 Community Server“ repository are already inst]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/142858955</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/142858955</guid><author>ye_chen_</author><pubDate>Fri, 11 Oct 2024 17:14:36 +0800</pubDate><description><![CDATA[找到[mysql5.7-community] 修改：gpgcheck参数为0，即不校验gpg。解决办法：禁用GPG验证检查。]]></description><category></category></item><item><title><![CDATA[Oracle数据库分页查询出现重复数据的解决办法]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/103068933</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/103068933</guid><author>ye_chen_</author><pubDate>Thu, 14 Nov 2019 15:58:14 +0800</pubDate><description><![CDATA[优化过一次SQL，结果生产环境上出了问题，分页查询有重复数据。原SQL使用order by 进行分页查询，出现数据重复的问题，排查后发现是数据库没有唯一字段导致。

暂时能想到的解决办法是：

1.order by 后面条件需要加上数据库里的唯一字段做区分。

2.若数据库不存在可区分的唯一字段，就只能根据row_id进行排序 ，因为这样跟业务没有联系，所以一般不推荐
...]]></description><category></category></item><item><title><![CDATA[sql笔记]]></title><link>https://blog.youkuaiyun.com/ye_chen_/article/details/84314531</link><guid>https://blog.youkuaiyun.com/ye_chen_/article/details/84314531</guid><author>ye_chen_</author><pubDate>Wed, 21 Nov 2018 10:24:00 +0800</pubDate><description><![CDATA[1、----------------------where和having------------------------

2、where

      where子句的作用是在对查询结果进行分组前，将不符合where条件的行去掉，即在分组之前过滤数据，条件中不能包含聚合函数，使用where条件显示特定的行。

 

3、having

      having子句的作用是筛选满足条件的组，即在分...]]></description><category></category></item></channel></rss>