<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congwei4288</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congwei4288]]></copyright><item><title><![CDATA[SAS 实例proc means]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374445</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374445</guid><author>congwei4288</author><pubDate>Sun, 10 Sep 2017 18:17:26 +0800</pubDate><description><![CDATA[1. 实例proc means



	调用means过程对变量进行分析，得到各变量的非缺失观测数N，均值MEAN，标准差STD DEV，最大值Max和最小值Mi。


	by语句要求数据集按by后的变量...]]></description><category></category></item><item><title><![CDATA[SAS  input 语句]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374444</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374444</guid><author>congwei4288</author><pubDate>Sun, 10 Sep 2017 16:51:21 +0800</pubDate><description><![CDATA[data test;
 infile
 cards ;
 input x @;
 input y;
 input z @@;
 cards;
 1 2 3 4 5 6
 7 8 9 10 11 12
 13 ...]]></description><category></category></item><item><title><![CDATA[使用闪回删除来回退DROP TABLE操作]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374443</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374443</guid><author>congwei4288</author><pubDate>Fri, 08 Sep 2017 23:23:16 +0800</pubDate><description><![CDATA[--闪回
SELECT * FROM AA AS OF TIMESTAMP(sysdate-1/24/60) --查看2个小时以前的数据
1/2就是12小时
1/24就是1小时
1/24/60就是1分钟

alte...]]></description><category></category></item><item><title><![CDATA[EXCEL中字符串连接或合并函数]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374440</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374440</guid><author>congwei4288</author><pubDate>Wed, 06 Sep 2017 23:38:27 +0800</pubDate><description><![CDATA[一、 EXCEL中字符串连接或合并函数（CONCATENATE）
	
		1. 将每一个单元 格用“&amp;”连接 下来 
	
=A2&amp;B2
将下列用"-"连接起来. 如果遇到字符 串间还要加上其它 字...]]></description><category></category></item><item><title><![CDATA[Oracle sequence]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374437</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374437</guid><author>congwei4288</author><pubDate>Sun, 18 Jun 2017 15:34:57 +0800</pubDate><description><![CDATA[sequence是用来在多用户环境下产生唯一整数的数据库对象。序列产生器顺序生成数字，它可用于自动生成主键值，并能协调多行或者多表的主键操作。


	


	CREATE SEQUENCE SEQTEST
...]]></description><category></category></item><item><title><![CDATA[Oracle DBLINk的使用]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374499</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374499</guid><author>congwei4288</author><pubDate>Sun, 18 Jun 2017 13:50:13 +0800</pubDate><description><![CDATA[OracleDBLINK


	作用:将多个不同地点的服务器的oracle数据库逻辑上看成一个数据库,也就是说在一个数据库中可以操作另一个远程的数据库中的对象。
语法:
CREATE [PUBLIC] DAT...]]></description><category></category></item><item><title><![CDATA[shell脚本中逻辑判断|| 和-o的使用及区别]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374434</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374434</guid><author>congwei4288</author><pubDate>Mon, 17 Apr 2017 15:16:34 +0800</pubDate><description><![CDATA[(1) shell脚本中逻辑判断|| 和-o的使用及区别


	-a　与


	-o　或

!　非echo "init_mv begin..."

if [ "$SrcPath" == '/' ...]]></description><category></category></item><item><title><![CDATA[shell变量$#,$@,$0,$1,$2的含义解释]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374433</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374433</guid><author>congwei4288</author><pubDate>Mon, 17 Apr 2017 11:19:40 +0800</pubDate><description><![CDATA[load.sh脚本如下：

#!/bin/bash
set -u
current_dir=$(cd `dirname $0`; pwd)
python ${current_dir}/curl.py
hive -f...]]></description><category></category></item><item><title><![CDATA[shell  $? -ne 0]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374432</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374432</guid><author>congwei4288</author><pubDate>Mon, 17 Apr 2017 11:09:26 +0800</pubDate><description><![CDATA[#!/bin/bash
hive -f /opt/schedule/schedule-deploy/gfboss/gfjys/hive/1gfjys_order_snatched_inc.sql

if [ $? -ne...]]></description><category></category></item><item><title><![CDATA[（R语言）有序因子和无序因子]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374448</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374448</guid><author>congwei4288</author><pubDate>Fri, 31 Mar 2017 14:59:56 +0800</pubDate><description><![CDATA[因子是一种向量对象，它给自己的组件指定了一个离散的分类（分组），它的组件由其他等长的向量组成。R提供了有序因子和无序因子。
通俗点说，因子就是将对象的值分成不同的组（levels）。
用函数factor()创建...]]></description><category></category></item><item><title><![CDATA[R包安装不上]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374431</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374431</guid><author>congwei4288</author><pubDate>Thu, 30 Mar 2017 14:12:59 +0800</pubDate><description><![CDATA[问题描述：
Warning in install.packages : 


	InternetOpenUrl failed: '无法与服务器建立连接'
	
		解决方法：
	
	
		进入到R的安装...]]></description><category></category></item><item><title><![CDATA[Hive null的用法]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374475</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374475</guid><author>congwei4288</author><pubDate>Wed, 02 Nov 2016 10:05:40 +0800</pubDate><description><![CDATA[(17)	Hive null的用法
Hive中有种假NULL，它看起来和NULL一摸一样，但是实际却不是NULL。空值NULL在底层默认是用'\N'来存储的，Hive中'\'是转义字符，需要对'\'进行一次转义，...]]></description><category></category></item><item><title><![CDATA[mongoDB VUE问题]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374430</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374430</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:29:54 +0800</pubDate><description><![CDATA[1.mongoDBVUE问题 
但是不能打开数据库，出现异常： 


	 


	[mongo@localhostdata]$wc-lsocialRelation.json
73224soc...]]></description><category></category></item><item><title><![CDATA[Mongo  Window启动命令]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374426</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374426</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:04:40 +0800</pubDate><description><![CDATA[1. Window启动命令 


	启动mongodb 


	C:\mongodb_no_fix\bin\mongod --dbpath=C:\mongodb_no_fix\data
--logpath=C...]]></description><category></category></item><item><title><![CDATA[pg建索引]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374422</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374422</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:04:01 +0800</pubDate><description><![CDATA[https://www.postgresql.org/docs/9.6/static/indexes-partial.html
	

createindexa indexon**ealthdb_...]]></description><category></category></item><item><title><![CDATA[分区表循环函数]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374428</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374428</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:02:48 +0800</pubDate><description><![CDATA[CREATE OR REPLACE FUNCTION lw.loop_create_table(


	 beg_date date,


	 days integer)


	 RETUR...]]></description><category></category></item><item><title><![CDATA[Pg实现add_month]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374472</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374472</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:02:07 +0800</pubDate><description><![CDATA[SELECT(date_trunc('MONTH',now())+INTERVAL'0MONTH-1day')::date;
select date '2016-01_03' +interval '1 ...]]></description><category></category></item><item><title><![CDATA[PG的字符串反转函数]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374423</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374423</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 17:01:28 +0800</pubDate><description><![CDATA[CREATEORREPLACEFUNCTIONlw.str_fz(strcharactervarying)
RETURNScharactervaryingAS
$BODY$
...]]></description><category></category></item><item><title><![CDATA[hive Union和union all]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374462</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374462</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 16:52:51 +0800</pubDate><description><![CDATA[Union和union all 


	总结分析 


	1.子查询相当于表名，使用 from 关键字需要指定真实表名或表别名。 


	2. hive 不支持union ，只支持union all...]]></description><category></category></item><item><title><![CDATA[导出分区表]]></title><link>https://blog.youkuaiyun.com/congwei4288/article/details/100374415</link><guid>https://blog.youkuaiyun.com/congwei4288/article/details/100374415</guid><author>congwei4288</author><pubDate>Tue, 01 Nov 2016 16:41:30 +0800</pubDate><description><![CDATA[expdp bi/bi@orcl directory=DATA_DIR dumpfile=bi%U.dmp tables=Bi_Fact_Aidsreports,Bi_Fact_Aidsreportsq,Bi_Fact_Aids...]]></description><category></category></item></channel></rss>