<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cmoaai42662的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cmoaai42662</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cmoaai42662]]></copyright><item><title><![CDATA[postgis 地理数据]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356138</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356138</guid><author>cmoaai42662</author><pubDate>Tue, 12 May 2015 10:59:48 +0800</pubDate><description><![CDATA[[postgres@cdh3 ~]$ vi /data/postgresql-9.3.5/data/pg_hba.conf 
host all all 0.0.0.0/0 trust

[postgres@cdh3 ~]$...]]></description><category></category></item><item><title><![CDATA[postgres install + postgis install（二）]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356140</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356140</guid><author>cmoaai42662</author><pubDate>Sat, 09 May 2015 09:56:21 +0800</pubDate><description><![CDATA[续上篇 postgres install + postgis install（一），继续介绍安装过程以及问题处理。

2、安装 proj-4.8.0

[root@cdh3 data]# tar -xvzf /root...]]></description><category></category></item><item><title><![CDATA[postgres install + postgis install（-）]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356136</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356136</guid><author>cmoaai42662</author><pubDate>Sat, 09 May 2015 08:41:32 +0800</pubDate><description><![CDATA[postgres 安装+gis安装，以下采用 tarball 作为安装介质（rpm包不好用，可控性太小），由于需要配置gis，依赖非常多，且版本要求严格，搞了好久终于搞定了所有错误，记录下安装过程遇到的所有问题，不然下次又不记得...]]></description><category></category></item><item><title><![CDATA[impala下的string vs timestamp]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356139</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356139</guid><author>cmoaai42662</author><pubDate>Tue, 24 Mar 2015 13:35:58 +0800</pubDate><description><![CDATA[以下试验证明各自特点。

create table t1_t ( start_time timestamp ,cdr_id decimal(14,1)) stored as parquet;
create table t1...]]></description><category></category></item><item><title><![CDATA[impala下的表查询测试(refresh)]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356134</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356134</guid><author>cmoaai42662</author><pubDate>Mon, 23 Mar 2015 14:04:45 +0800</pubDate><description><![CDATA[测试：
create table c (n1 int) PARTITIONED by (hour int) row format delimited fields terminated by ',' stored as ...]]></description><category></category></item><item><title><![CDATA[sparksql限制一（多表join问题）]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356164</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356164</guid><author>cmoaai42662</author><pubDate>Tue, 10 Mar 2015 15:08:46 +0800</pubDate><description><![CDATA[1、sqlContext中3个表不能同时join，需要两两join后再join一次；---经验证，此版本没这个限制（cdh5.3）
scala&gt; sqlContext.sql("select a.name,a.age,b...]]></description><category></category></item><item><title><![CDATA[sparksql应用样例]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356125</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356125</guid><author>cmoaai42662</author><pubDate>Thu, 05 Mar 2015 11:37:49 +0800</pubDate><description><![CDATA[参考其它技术帖子内容试验后贴在这里，作为备注

1、sqlContext
--数据以people.txt为例
[root@cdh0 ~]# vi people.txt 
mechel,29
andy,30
jusd...]]></description><category></category></item><item><title><![CDATA[spark检索hdfs记录]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356194</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356194</guid><author>cmoaai42662</author><pubDate>Fri, 27 Feb 2015 10:45:50 +0800</pubDate><description><![CDATA[注：以下用的是CDH5.3版本。

[root@cdh0 ~]# hadoop dfs -ls /user/hive/warehouse/db1.db/tab1
DEPRECATED: Use of this script...]]></description><category></category></item><item><title><![CDATA[impala数据导入汇总]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356159</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356159</guid><author>cmoaai42662</author><pubDate>Fri, 23 Jan 2015 12:05:58 +0800</pubDate><description><![CDATA[数据进入到表中的几种不同方式：

1. put/distcp
hdfs dfs -put 从本地上传到hdfs

2.load data
[cdh2:21000] &gt; select count(*) from ...]]></description><category></category></item><item><title><![CDATA[oracle的compress功能历史变迁--11gr2]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356207</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356207</guid><author>cmoaai42662</author><pubDate>Mon, 08 Dec 2014 17:37:04 +0800</pubDate><description><![CDATA[压缩技术发展到了11gr2版本。(word里的格式到这里有点乱）


	 


	table_compression 


	Thetable_compressionclauseisvalidonl...]]></description><category></category></item><item><title><![CDATA[oracle的compress功能历史变迁--11gr1]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356124</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356124</guid><author>cmoaai42662</author><pubDate>Mon, 08 Dec 2014 17:19:12 +0800</pubDate><description><![CDATA[接下来，谈谈oracle版本到了r1版本。


	


	


	


	table_compression


	Thetable_compressionclauseisvalid...]]></description><category></category></item><item><title><![CDATA[oracle的compress功能历史变迁--10g]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356122</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356122</guid><author>cmoaai42662</author><pubDate>Mon, 08 Dec 2014 17:07:51 +0800</pubDate><description><![CDATA[oracle的压缩功能经历了这么多年以来，都有哪些演变，以下一点点介绍。

10.2版本
以下内容均来自于官方文档。

	


	table_compression


	Thetable_compre...]]></description><category></category></item><item><title><![CDATA[（转载）hbase性能调优]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356121</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356121</guid><author>cmoaai42662</author><pubDate>Mon, 13 May 2013 12:57:57 +0800</pubDate><description><![CDATA[因官方Book Performance Tuning部分章节没有按配置项进行索引，不能达到快速查阅的效果。所以我以配置项驱动，重新整理了原文，并补充一些自己的理解，如有错误，欢迎指正。
配置优化
zookeeper.sess...]]></description><category></category></item><item><title><![CDATA[oracle 10gr2 中 clob 字段原理浅析]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356117</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356117</guid><author>cmoaai42662</author><pubDate>Tue, 29 Jan 2013 16:28:57 +0800</pubDate><description><![CDATA[前段时间生产库的数据文件出了点问题，导致部分数据丢失，其中包括log segment，当时想通过常规手段将丢失的log数据清除掉，但由于文件offline了，所以没办法了。以下是通过bbed在测试库上所作的更改，目的就...]]></description><category></category></item><item><title><![CDATA[（转载） 澄清EMC Clariion盘阵Snapview之clone的几个问题]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356115</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356115</guid><author>cmoaai42662</author><pubDate>Mon, 31 Dec 2012 17:11:33 +0800</pubDate><description><![CDATA[以下是实际工作中遇到的问题，不正确之处，敬请指正。

1、EMC 
Clariion盘阵的lun在双SP下有tresspass的功能，以保证在一个SP发生故障时盘阵仍可以正常工作。但Snapview的clone 
lun...]]></description><category></category></item><item><title><![CDATA[（转载）Oracle 10g RAC中的DRM]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356195</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356195</guid><author>cmoaai42662</author><pubDate>Mon, 31 Dec 2012 10:17:39 +0800</pubDate><description><![CDATA[在RAC环境中，Oracle使用GRD（GlobalResourceService）来记录各个RAC节点的资源信息，具体通过GCS（GlobalCacheService）和GES（GlobalEnqueueServi...]]></description><category></category></item><item><title><![CDATA[DRM - Dynamic Resource management [ID 390483.1]]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356112</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356112</guid><author>cmoaai42662</author><pubDate>Mon, 31 Dec 2012 09:25:01 +0800</pubDate><description><![CDATA[Applies to: 
Oracle Server - Standard Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information  i...]]></description><category></category></item><item><title><![CDATA[RHEL5上的11gr2 RAC在线添加一个节点]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356109</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356109</guid><author>cmoaai42662</author><pubDate>Wed, 12 Dec 2012 10:56:09 +0800</pubDate><description><![CDATA[前提：已经在rhel5上部署了一套rac系统（本文中存储部分使用的是iscsi服务，单独用一台服务器做了存储）；之前的部署环境（RHEL5.8）：iscsi服务器端 : 192.168.8.214 RAC端：192.168.8....]]></description><category></category></item><item><title><![CDATA[infobright入库时的参数设置导致的不能入库]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356182</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356182</guid><author>cmoaai42662</author><pubDate>Thu, 08 Nov 2012 15:26:20 +0800</pubDate><description><![CDATA[infobright入库时，一般情况下为了效率考虑，都会采用dlp工具入库，然后在使用这个工具时，有2个参数需要留意一下，-r 和 -t ，这2个参数的意思：-r 错误数据的存放文件-t 忽略错误数据百分比在入库时，一旦文件中的...]]></description><category></category></item><item><title><![CDATA[转载--oracle中constraint的4属性]]></title><link>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356272</link><guid>https://blog.youkuaiyun.com/cmoaai42662/article/details/100356272</guid><author>cmoaai42662</author><pubDate>Mon, 26 Mar 2012 15:04:23 +0800</pubDate><description><![CDATA[约束的四对属性: Deferrable/not deferrable, Deferred/immediate, enalbe/disable, validate/novalidate,以及如何应用这些属性灵活应对相关问题
...]]></description><category></category></item></channel></rss>