<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[china_demon的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/china_demon</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; china_demon]]></copyright><item><title><![CDATA[股票选股SQL脚本-pg数据库]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/142966719</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/142966719</guid><author>china_demon</author><pubDate>Tue, 15 Oct 2024 23:16:16 +0800</pubDate><description><![CDATA[where a.ts_code <> 'ts_code' and a.list_status='L' and t.ts_code=a.ts_code and a.name not like '%退%' and a.name not like '%ST%'and b.industry not in ('全国地产','证券','多元金融')and a.name not like '%银行%'and a.name not like '%商行%'and a.market <> '科创板']]></description><category></category></item><item><title><![CDATA[股票日数据处理-pg数据库]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/142966350</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/142966350</guid><author>china_demon</author><pubDate>Tue, 15 Oct 2024 22:50:41 +0800</pubDate><description><![CDATA[清空表dw_stock_base_d_ dm_stock_base_d dm_stock_base_fex_d。# 执行 /root/stock/run_stock.sh /data/2023/202311/echo "文件处理：逗号分隔，增加日期、股票字段"echo "数据日期"$dirfile_date。#插入分析表da_stock_base_fex1_d。#插入分析表da_stock_base_fex_d。#插入分析表dm_stock_base_d。#2、补充日期和股票代码。]]></description><category></category></item><item><title><![CDATA[VM虚拟机使用蓝屏处理——拯救者笔记本]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/142436026</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/142436026</guid><author>china_demon</author><pubDate>Sun, 22 Sep 2024 13:50:52 +0800</pubDate><description><![CDATA[vm虚拟机蓝屏处理方法]]></description><category></category></item><item><title><![CDATA[pg数据库存储过程]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/140915013</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/140915013</guid><author>china_demon</author><pubDate>Mon, 05 Aug 2024 00:50:44 +0800</pubDate><description><![CDATA[- 打印当前迭代的值。]]></description><category></category></item><item><title><![CDATA[更换yum 阿里]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/135432752</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/135432752</guid><author>china_demon</author><pubDate>Sat, 06 Jan 2024 21:51:11 +0800</pubDate><description><![CDATA[下载新的阿里的yum源仓库，阿里的开源镜像站https://developer.aliyun.com/mirror/]]></description><category></category></item><item><title><![CDATA[股票 SQL]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/133534398</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/133534398</guid><author>china_demon</author><pubDate>Wed, 04 Oct 2023 01:46:27 +0800</pubDate><description><![CDATA[-------------------------------两年。]]></description><category></category></item><item><title><![CDATA[linux 配置静态ip地址]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/133526746</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/133526746</guid><author>china_demon</author><pubDate>Tue, 03 Oct 2023 19:39:32 +0800</pubDate><description><![CDATA[# Generated by dracut initrd
TYPE=Ethernet
NAME="ens33"
DEVICE="ens33"
UUID="277f3501-5ece-41e8-9201-1cf5f984f9ff"
IPV6INIT=yes
BOOTPROTO="static"    
ONBOOT="yes"
IPADDR=192.168.3.38
GATEWAY=192.168.3.1
NETMASK=255.255.255.0
DNS1=114.114.114.114]]></description><category></category></item><item><title><![CDATA[hive beeline]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/133504933</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/133504933</guid><author>china_demon</author><pubDate>Tue, 03 Oct 2023 01:58:11 +0800</pubDate><description><![CDATA[beeline -u "jdbc:hive2://192.168.3.38:10000/stock"  -n hive -p hive]]></description><category></category></item><item><title><![CDATA[linux下python连接oracle数据库]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/133501992</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/133501992</guid><author>china_demon</author><pubDate>Tue, 03 Oct 2023 00:11:20 +0800</pubDate><description><![CDATA[否则报错：cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libmql1.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help。]]></description><category></category></item><item><title><![CDATA[hive 字符串截取]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/133442216</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/133442216</guid><author>china_demon</author><pubDate>Sat, 30 Sep 2023 21:25:07 +0800</pubDate><description><![CDATA[1232]]></description><category></category></item><item><title><![CDATA[Progresql数据库安装--安装]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/132746448</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/132746448</guid><author>china_demon</author><pubDate>Thu, 07 Sep 2023 21:20:54 +0800</pubDate><description><![CDATA[progresql]]></description><category></category></item><item><title><![CDATA[ETL开发常用shell文件操作]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/132746292</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/132746292</guid><author>china_demon</author><pubDate>Thu, 07 Sep 2023 21:11:21 +0800</pubDate><description><![CDATA[【代码】ETL开发常用shell文件操作。]]></description><category></category></item><item><title><![CDATA[GaussDB(DWS)与Hive在功能上存在一定的差异]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/124240355</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/124240355</guid><author>china_demon</author><pubDate>Mon, 18 Apr 2022 02:06:07 +0800</pubDate><description><![CDATA[GaussDB(DWS)与Hive在功能上存在一定的差异，主要体现在以下几个方面：

Hive是基于Hadoop MapReduce的数据仓库，GaussDB(DWS)是基于Postgres的MPP的数据仓库。

Hive的数据在HDFS中存储，GaussDB(DWS)的数据可以在本地存储，也可以通过外表的形式通过OBS进行存储。

Hive不支持索引，GaussDB(DWS)支持索引，所以查询速度GaussDB(DWS)更快。

Hive不支持存储过程，GaussDB(DWS)支持存储过程，使用场景更广泛]]></description><category></category></item><item><title><![CDATA[筛选股票代码]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/123956184</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/123956184</guid><author>china_demon</author><pubDate>Mon, 04 Apr 2022 16:46:18 +0800</pubDate><description><![CDATA[--start--v1.0
drop table stock_temp;
create temporary table stock_temp as
select
t.ts_code
,t.st_price
,t.week_total
,t.week_high_total
,t.week_low_total
,t.month_total
,t.month_high_total
,t.month_low_total
,t.year_high
,t.year_total
,t.year_high_total...]]></description><category></category></item><item><title><![CDATA[Tomcat内存溢出的三种情况及解决办法分析]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/109817739</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/109817739</guid><author>china_demon</author><pubDate>Thu, 19 Nov 2020 16:59:31 +0800</pubDate><description><![CDATA[Tomcat内存溢出的原因　　在生产环境中tomcat内存设置不好很容易出现内存溢出。造成内存溢出是不一样的，当然处理方式也不一样。　　这里根据平时遇到的情况和相关资料进行一个总结。常见的一般会有下面三种情况：1.OutOfMemoryError： Java heap space2.OutOfMemoryError： PermGen space3.OutOfMemoryError： unable to create new native thread.Tomcat内存溢出解决方案　　对于前两种情况，在...]]></description><category></category></item><item><title><![CDATA[xitrum工程搭建]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/107123668</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/107123668</guid><author>china_demon</author><pubDate>Sat, 04 Jul 2020 14:04:13 +0800</pubDate><description><![CDATA[xitrum工程搭建
1、建议用idea工具，eclipse我是没下载完。
2、sbt一定要更换，不然慢的无法完成。
不管在Windows还是linux要在当前用户的根目录.sbt下新建repositories文件
内容：阿里的地址库
[repositories]
#local
public: http://maven.aliyun.com/nexus/content/groups/public/#这个maven
typesafe:http://dl.bintray.com/typesafe/ivy-rel]]></description><category></category></item><item><title><![CDATA[JMeter从入门到精通]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/106178991</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/106178991</guid><author>china_demon</author><pubDate>Sun, 17 May 2020 19:04:46 +0800</pubDate><description><![CDATA[《JMeter从入门到精通》之一——开始你的第一个JMeter脚本

JMeter是一款在国外非常流行和受欢迎的开源性能测试工具，像LoadRunner 一样，它也提供了一个利用本地Proxy Server（代理服务器）来录制生成测试脚本的功能，但是这个功能并不好用。所以在本文中介绍一个更为常用的方法——使用Badboy录制生成JMeter脚本。

简单的介绍一下Badboy。Badboy是一款不错的Web自动化测试工具，如果你将它用于非商业用途，或者用于商业用途但是安装Badboy的机器数量不超过5...]]></description><category></category></item><item><title><![CDATA[筛选60天内好的机会股]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/105609176</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/105609176</guid><author>china_demon</author><pubDate>Sun, 19 Apr 2020 01:34:35 +0800</pubDate><description><![CDATA[drop table dm_stock_d;
create table dm_stock_d as
select
date_d
,open     
,high   
,close     
,low    
,volume    
,price_change 
,p_change    
,ma5          
,...]]></description><category></category></item><item><title><![CDATA[Python连接Oracle配置过程]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/80948067</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/80948067</guid><author>china_demon</author><pubDate>Sat, 07 Jul 2018 01:25:28 +0800</pubDate><description><![CDATA[今天用python连接Oracle，这已经是第二次配置了，这次配的时候忘记了以前是怎么弄的，配置完后写点东西吧第一步：安装Anaconda2-4.0.0-Windows-x86_64.exe第二步：安装Oracle Client64第三步：安装cx_Oracle-5.1.2-11g.win-amd64-py2.7.msi第四步：安装vcredist_x64.exe第六步：安装pip install...]]></description><category></category></item><item><title><![CDATA[hive股票数据脚本]]></title><link>https://blog.youkuaiyun.com/china_demon/article/details/79606578</link><guid>https://blog.youkuaiyun.com/china_demon/article/details/79606578</guid><author>china_demon</author><pubDate>Mon, 19 Mar 2018 02:32:23 +0800</pubDate><description><![CDATA[#! /bin/bash#===============#p_dm_stock_d.sh#===============DT=`date -d '-1 day' &quot;+%Y-%m-%d&quot;`DT_1=`date -d '-2 day' &quot;+%Y-%m-%d&quot;`if[$1];then    DT=$1fiSQL=&quot;insert overwrite table dm_stock_dselect t.dat...]]></description><category></category></item></channel></rss>