<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[conglong8674的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/conglong8674</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; conglong8674]]></copyright><item><title><![CDATA[visio 方向键 对象不能移动]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420638</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420638</guid><author>conglong8674</author><pubDate>Thu, 17 Mar 2016 04:07:24 +0800</pubDate><description><![CDATA[转载网址：http://blog.sina.com.cn/s/blog_601cbd070100xd4d.html


	
		visio方向键对象不能移动
	
(2012-03-06 17:19:45)
...]]></description><category></category></item><item><title><![CDATA[visio premium 2010 产品密钥]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420633</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420633</guid><author>conglong8674</author><pubDate>Wed, 16 Mar 2016 21:04:31 +0800</pubDate><description><![CDATA[http://blog.sina.com.cn/s/blog_4e0869690100z9m3.html

Visio Premium 2010
VOL版：
 =========================

F...]]></description><category></category></item><item><title><![CDATA[instance client]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420636</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420636</guid><author>conglong8674</author><pubDate>Sun, 14 Dec 2014 17:05:58 +0800</pubDate><description><![CDATA[1. 下载相应服务器端数据库版本的instance client basic
2. 解压到D:\oracle\instantclient_11_2
3. 配置环境变量：
 ORACLE_HOME   D:\or...]]></description><category></category></item><item><title><![CDATA[Hive建非分区表]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420634</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420634</guid><author>conglong8674</author><pubDate>Thu, 13 Nov 2014 13:04:08 +0800</pubDate><description><![CDATA[CREATE TABLE IF NOT EXISTS u1.t1
( MONTH_ID STRING, -- 月份
 NAME STRING, -- 姓名
 SALARYDOUBLE, -- 薪资
) PA...]]></description><category></category></item><item><title><![CDATA[rm]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420615</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420615</guid><author>conglong8674</author><pubDate>Sun, 12 Oct 2014 00:39:46 +0800</pubDate><description><![CDATA[删除指定文件(夹)之外的文件(夹)：


	ls | grep -v linux.x64_11gR2_grid.zip| xargsrm -rf


	注意：必须是 ls 不能是 ll...]]></description><category></category></item><item><title><![CDATA[NULL LASTS 在 Hive 里的实现]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420613</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420613</guid><author>conglong8674</author><pubDate>Tue, 30 Sep 2014 15:52:03 +0800</pubDate><description><![CDATA[Hive：

SELECT B.*,
 ROW_NUMBER() OVER(DISTRIBUTE BY CUSTOMER_ID SORT BY B.CERT_TYPE, B.IS_CERT_REAL DESC,...]]></description><category></category></item><item><title><![CDATA[UDF UDAF UDTF]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420612</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420612</guid><author>conglong8674</author><pubDate>Mon, 29 Sep 2014 10:26:32 +0800</pubDate><description><![CDATA[UDF:
一进一出（输入一行输出一行 On-to-one maping ）

UDAF:
多进一出（输入多行输出一行 Many-to-one maping）

UDTF:
一进多出（输入一行输出多行 ...]]></description><category></category></item><item><title><![CDATA[Hive求差集]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420616</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420616</guid><author>conglong8674</author><pubDate>Mon, 29 Sep 2014 09:24:17 +0800</pubDate><description><![CDATA[SELECT 
 BB.ID,BB.NAME 
FROM
(SELECT A.* FROM A ) AA
RIGHT OUTER JOIN
(SELECT B.* FROM B) BB
ON (...]]></description><category></category></item><item><title><![CDATA[log4j:ERROR Could not instantiate class [...log.metrics.EventCounter].]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420631</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420631</guid><author>conglong8674</author><pubDate>Mon, 15 Sep 2014 00:29:48 +0800</pubDate><description><![CDATA[Hive 报下面的错： 我的 Hive 版本是 hive-0.9.0.tar.gz
[root@hadoop lib]# hive
log4j:ERROR Could not instantiate class [org.a...]]></description><category></category></item><item><title><![CDATA[PL/SQL DEVELOPER查询结果复制出来中文乱码的解决办法]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420632</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420632</guid><author>conglong8674</author><pubDate>Fri, 05 Sep 2014 23:39:39 +0800</pubDate><description><![CDATA[PL/SQL DEVELOPER中查询结果导出到EXCEL时中文显示正常，但直接复制出来中文显示为乱码，如何？


	解决方案：切换到中文输入法状态，再复制，即可。


	中文输入法状态图如下：（ctrl+c）...]]></description><category></category></item><item><title><![CDATA[regexp-MySQL]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420611</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420611</guid><author>conglong8674</author><pubDate>Wed, 03 Sep 2014 22:27:34 +0800</pubDate><description><![CDATA[regexp
regexp 匹配字串
like 匹配整串
tname regexp '1000'等于tname like '%1000%'
tname regexp '^1000$'等于tname li...]]></description><category></category></item><item><title><![CDATA[匹配-字符类-重复元字符-定位元字符]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420609</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420609</guid><author>conglong8674</author><pubDate>Wed, 03 Sep 2014 22:11:37 +0800</pubDate><description><![CDATA[...]]></description><category></category></item><item><title><![CDATA[NULL 和 '']]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420610</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420610</guid><author>conglong8674</author><pubDate>Mon, 01 Sep 2014 10:25:33 +0800</pubDate><description><![CDATA[NULL 和 ''


	create table t1(a int,b varchar2(10));


	insert into t1 values(1,'F');
insert into t1 values(...]]></description><category></category></item><item><title><![CDATA[like 通配符]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420607</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420607</guid><author>conglong8674</author><pubDate>Mon, 01 Sep 2014 10:20:25 +0800</pubDate><description><![CDATA[create table t1(a int,b varchar2(10));


	insert into t1 values(1,'F');
insert into t1 values(2,' F');
ins...]]></description><category></category></item><item><title><![CDATA[关闭 selinux]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420603</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420603</guid><author>conglong8674</author><pubDate>Fri, 29 Aug 2014 21:43:16 +0800</pubDate><description><![CDATA[一般安装linux课程时都把SELinux与iptables安排在后面，使初学者配置linux服务器时不成功，却没有头绪，那是因为在RedHat linux操作系统中默认开启了防火墙，SELinux也处于启动状态，一般状态为en...]]></description><category></category></item><item><title><![CDATA[Hive建分区表语句]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420606</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420606</guid><author>conglong8674</author><pubDate>Tue, 19 Aug 2014 20:26:47 +0800</pubDate><description><![CDATA[** 客户资料表（日） *************************************************************
CREATE TABLE ZB_DWD.DWD_D_CUS_AL_CUS...]]></description><category></category></item><item><title><![CDATA[Hive和Oracle正则表达式对应表]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420608</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420608</guid><author>conglong8674</author><pubDate>Tue, 19 Aug 2014 20:24:19 +0800</pubDate><description><![CDATA[OracleHive
 regexp_like...]]></description><category></category></item><item><title><![CDATA[Hive和Oracle函数对照表]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420600</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420600</guid><author>conglong8674</author><pubDate>Tue, 19 Aug 2014 20:21:44 +0800</pubDate><description><![CDATA[字符函数：
OracleHive
|| concat
...]]></description><category></category></item><item><title><![CDATA[Oracle11gR2打补丁]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420604</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420604</guid><author>conglong8674</author><pubDate>Mon, 16 Jun 2014 23:21:24 +0800</pubDate><description><![CDATA[1、备份/oracle和/grid目录
root用户执行
tar -cvf /appview/oracle.tar /oracle
tar -cvf /appview/grid.tar  /grid


2、更新Or...]]></description><category></category></item><item><title><![CDATA[rhel5.8上安装Oracle11gR2]]></title><link>https://blog.youkuaiyun.com/conglong8674/article/details/100420605</link><guid>https://blog.youkuaiyun.com/conglong8674/article/details/100420605</guid><author>conglong8674</author><pubDate>Mon, 16 Jun 2014 23:18:43 +0800</pubDate><description><![CDATA[安装流程
1.OS版本和kernel限制
2.空间限制
内存和磁盘空间
3.软件包需求
4.内核参数
5.用户和资源限制
6.运行安装命令
7.安装流程

1.OS版本限制

...]]></description><category></category></item></channel></rss>