<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[comecheer.com]]></title><description><![CDATA[大数据 数据开发]]></description><link>https://blog.youkuaiyun.com/moxpeter</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; moxpeter]]></copyright><item><title><![CDATA[Gbase使用jdbc调存储过程错误]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/17440063</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/17440063</guid><author>moxpeter</author><pubDate>Fri, 20 Dec 2013 13:55:52 +0800</pubDate><description><![CDATA[最近系统添加对gbase的支持，调用存储过程的时候出现问题
java.sql.SQLException: Parameter index of 1 is out of range (1, 0)
    at com.gbase.jdbc.SQLError.createSQLException(SQLError.java:1075)
    at com.gbase.jdbc.SQLError]]></description><category></category></item><item><title><![CDATA[javascript 鼠标定位]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/9313909</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/9313909</guid><author>moxpeter</author><pubDate>Fri, 12 Jul 2013 17:38:38 +0800</pubDate><description><![CDATA[//鼠标的绝对定位
function mousePosition(ev){
if(!ev) ev=window.event;
    if(ev.pageX || ev.pageY){
        return {x:ev.pageX, y:ev.pageY};
    }
    return {
        x:ev.clientX + document.document]]></description><category></category></item><item><title><![CDATA[greenplum 之sysdate]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/9292325</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/9292325</guid><author>moxpeter</author><pubDate>Wed, 10 Jul 2013 16:37:18 +0800</pubDate><description><![CDATA[在Greenplum里面没有Oracle里面的sysdate，很多时候使用to_timestamp(current_timestamp,'yyyy-mm-dd hh24:mi:ss')代替;
但是在GP的函数中使用current_timestamp来记录日志，并不能达到效果
因为在同一个事务中current_timestamp这个值是不变的，取而代之使用clock_timestamp();]]></description><category></category></item><item><title><![CDATA[Greenplum中使用regexp_like]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/9163791</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/9163791</guid><author>moxpeter</author><pubDate>Mon, 24 Jun 2013 17:15:14 +0800</pubDate><description><![CDATA[CREATE OR REPLACE FUNCTION regexp_like(str character, reg character)
  RETURNS boolean AS
$BODY$
declare
v_match  text;
begin
select regexp_matches(str,reg) into v_match;
if v_match is not NULL then
r]]></description><category></category></item><item><title><![CDATA[shell读取文本到数组]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8969073</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8969073</guid><author>moxpeter</author><pubDate>Fri, 24 May 2013 11:16:57 +0800</pubDate><description><![CDATA[文件内容
checkfile,12312,22 


files=`cat $filename |awk -F ',' '{printf("%s %d %d",$1,$2,$3)}'`
file_content=($files);]]></description><category></category></item><item><title><![CDATA[mysql ERROR 1045 (28000)]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8671436</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8671436</guid><author>moxpeter</author><pubDate>Thu, 14 Mar 2013 09:04:38 +0800</pubDate><description><![CDATA[ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# /etc/init.d/mysql stop
# /usr/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u ro]]></description><category></category></item><item><title><![CDATA[hbase shell命令]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/7963796</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/7963796</guid><author>moxpeter</author><pubDate>Tue, 12 Mar 2013 17:48:38 +0800</pubDate><description><![CDATA[alter 修改列族模式
count 统计表中行的数量
describe显示表的相关详细信息
enable  使表有效
exists  测试表是否存在
get  获取cell的value
incr 增加指定表、列的值
put 向指定的表单元增加值
tools列出hbase所支持的工具
scan 通过对表的扫描来获取对应的值
status 返回hbase集群的状态信息
trun]]></description><category></category></item><item><title><![CDATA[eclipse 4.2  svn]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8502065</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8502065</guid><author>moxpeter</author><pubDate>Mon, 14 Jan 2013 18:11:49 +0800</pubDate><description><![CDATA[http://www.polarion.com/products/svn/subversive/download.php



svn connector   http://community.polarion.com/projects/subversive/download/eclipse/3.0/juno-site/]]></description><category></category></item><item><title><![CDATA[Concurrency Control in Greenplum Database]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8494240</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8494240</guid><author>moxpeter</author><pubDate>Fri, 11 Jan 2013 16:46:12 +0800</pubDate><description><![CDATA[Unlike traditional database systems which use locks for concurrency control, Greenplum Database (as does PostgreSQL) maintains data consistency by using a multiversion model (Multiversion Concurrency]]></description><category></category></item><item><title><![CDATA[Missing artifact com.sun.jdmk:jmxtools:jar:1.2.1]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8482526</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8482526</guid><author>moxpeter</author><pubDate>Tue, 08 Jan 2013 18:29:33 +0800</pubDate><description><![CDATA[遇到Missing artifact com.sun.jdmk:jmxtools:jar:1.2.1问题
在http://dist.wso2.org/maven2/com/sun/jdmk/jmxtools/1.2.1/jmxtools-1.2.1.jar 下载后执行
mvn install:install-file -DgroupId=com.sun.jdmk
 -DartifactId=]]></description><category></category></item><item><title><![CDATA[Master-Slave通用基础框架]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8442511</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8442511</guid><author>moxpeter</author><pubDate>Thu, 27 Dec 2012 11:11:35 +0800</pubDate><description><![CDATA[Master-Slave通用基础框架

一、设计目的

       
设计出一个通用的Master-Slave基础框架，然后可以基于这个框架来实现特定的业务需求，比如实现多节点并行计算等。




二、设计理念

       基于经典的命令模式，Master和Slave之间通过相互发送命令(Command)实现交互，命令是一个抽象的概念，Command可以用来分发任务,]]></description><category></category></item><item><title><![CDATA[intel hadoop manager安装配置]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8235809</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8235809</guid><author>moxpeter</author><pubDate>Thu, 29 Nov 2012 11:44:37 +0800</pubDate><description><![CDATA[1      准备工作：

支持的操作系统包括：RedHat Enterprise Linux、CentOS、Oracle Linux
要求系统至少为64位系统，版本6以上。
软件安装包     intelhadoop-2.1.1+8483-el6.x86_64.tar.gz
系统安装包    
 CentOS-6.3-x86_64-bin-DVD1.iso，CentOS-6.3-x8]]></description><category></category></item><item><title><![CDATA[oozie postgresql]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8027667</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8027667</guid><author>moxpeter</author><pubDate>Fri, 28 Sep 2012 11:15:02 +0800</pubDate><description><![CDATA[oozie.service.StoreService.jdbc.driver
        org.postgresql.Driver
    
    
        oozie.service.StoreService.jdbc.url
        jdbc:postgresql://localhost:5432/oozie
    
    
        oozie.servic]]></description><category></category></item><item><title><![CDATA[sqoop  mysql Last packet sent to the server was 1 ms ago]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/8023729</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/8023729</guid><author>moxpeter</author><pubDate>Thu, 27 Sep 2012 09:57:16 +0800</pubDate><description><![CDATA[sqoop import --connect jdbc:mysql://localhost:3306/ptx --username hadoop --password ha
doop --table testsqoop -m 1 --num-mappers 5 --append



** BEGIN NESTED EXCEPTION ** 

java.net.ConnectExc]]></description><category></category></item><item><title><![CDATA[thrift 访问hive]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/7962151</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/7962151</guid><author>moxpeter</author><pubDate>Mon, 10 Sep 2012 09:54:52 +0800</pubDate><description><![CDATA[编译hive_service



/hadoop/hive-0.7.1-cdh3u5/src/service/if

修改hive_service.thrift中

include "/home/peter/libs/thrift-0.8.0/contrib/fb303/if/fb303.thrift"

include "/hadoop/hive-0.7.1-cdh3u5/]]></description><category></category></item><item><title><![CDATA[cloudera hue]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/7949537</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/7949537</guid><author>moxpeter</author><pubDate>Thu, 06 Sep 2012 10:22:17 +0800</pubDate><description><![CDATA[下载hue 1.2
以前叫cloudera desktop，使用django作为web框架
1. 安装
                    HADOOP_HOME=/hadoop/hadoop0.20.2 PREFIX=/hadoop/hue make install


waiting  .. .. ..
执行完会在PREFIX指定的路径下生成hue的服务程序


2.配]]></description><category></category></item><item><title><![CDATA[mongodb base]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/7891065</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/7891065</guid><author>moxpeter</author><pubDate>Tue, 21 Aug 2012 14:30:22 +0800</pubDate><description><![CDATA[下载   http://fastdl.mongodb.org/linux/mongodb-linux-i686-2.0.7.tgz
tar  zvxf  mongodb-linux-i686-2.0.7.tgz
cd  mongodb-linux-i686-2.0.7/bin
./mongod

>>> import pymongo
>>> conn = pymongo.Connecti]]></description><category></category></item><item><title><![CDATA[mongodb base]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/84276394</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/84276394</guid><author>moxpeter</author><pubDate>Tue, 21 Aug 2012 14:30:00 +0800</pubDate><description><![CDATA[下载 http://fastdl.mongodb.org/linux/mongodb-linux-i686-2.0.7.tgz
tar zvxf mongodb-linux-i686-2.0.7.tgz
cd mongodb-linux-i686-2.0.7/bin
./mongod

&amp;gt;&amp;gt;&amp;gt; import pymongo
&amp;gt;&amp;gt;&amp;gt; conn = pym...]]></description><category></category></item><item><title><![CDATA[hadoop ssh 配置]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/84275752</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/84275752</guid><author>moxpeter</author><pubDate>Mon, 20 Aug 2012 13:03:00 +0800</pubDate><description><![CDATA[$:   ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa
-t 密钥类型  
-P 密语  the passphrase
-f 密钥文件
cat ~/.ssh/id_dsa.pub &amp;gt;&amp;gt;~/.ssh/authorized_keys
chmod 775 ~/.ssh
chmod 600 ~/.ssh/authorized_keys
...]]></description><category></category></item><item><title><![CDATA[redis base]]></title><link>https://blog.youkuaiyun.com/moxpeter/article/details/7869516</link><guid>https://blog.youkuaiyun.com/moxpeter/article/details/7869516</guid><author>moxpeter</author><pubDate>Wed, 15 Aug 2012 15:53:35 +0800</pubDate><description><![CDATA[$ wget http://redis.googlecode.com/files/redis-2.4.16.tar.gz
$ tar xzf redis-2.4.16.tar.gz
$ cd redis-2.4.16
$ make
 
$ src/redis-server $ src/redis-cliredis> set foo barOKredis> get foo"bar"]]></description><category></category></item></channel></rss>