- 博客(75)
- 资源 (5)
- 收藏
- 关注
RSS订阅原创 Gbase使用jdbc调存储过程错误
最近系统添加对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
2013-12-20 13:55:52
4577
2
原创 javascript 鼠标定位
//鼠标的绝对定位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
2013-07-12 17:38:38
975
原创 greenplum 之sysdate
在Greenplum里面没有Oracle里面的sysdate，很多时候使用to_timestamp(current_timestamp,'yyyy-mm-dd hh24:mi:ss')代替;但是在GP的函数中使用current_timestamp来记录日志，并不能达到效果因为在同一个事务中current_timestamp这个值是不变的，取而代之使用clock_timestamp();
2013-07-10 16:37:18
1936
原创 Greenplum中使用regexp_like
CREATE OR REPLACE FUNCTION regexp_like(str character, reg character) RETURNS boolean AS$BODY$declarev_match text;beginselect regexp_matches(str,reg) into v_match;if v_match is not NULL thenr
2013-06-24 17:15:14
7079
原创 shell读取文本到数组
文件内容checkfile,12312,22 files=`cat $filename |awk -F ',' '{printf("%s %d %d",$1,$2,$3)}'`file_content=($files);
2013-05-24 11:16:57
4386
原创 mysql ERROR 1045 (28000)
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
2013-03-14 09:04:38
970
原创 hbase shell命令
alter 修改列族模式count 统计表中行的数量describe显示表的相关详细信息enable 使表有效exists 测试表是否存在get 获取cell的valueincr 增加指定表、列的值put 向指定的表单元增加值tools列出hbase所支持的工具scan 通过对表的扫描来获取对应的值status 返回hbase集群的状态信息trun
2013-03-12 17:48:38
534
原创 eclipse 4.2 svn
http://www.polarion.com/products/svn/subversive/download.phpsvn connector http://community.polarion.com/projects/subversive/download/eclipse/3.0/juno-site/
2013-01-14 18:11:49
689
转载 Concurrency Control in Greenplum Database
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
2013-01-11 16:46:12
1235
原创 Missing artifact com.sun.jdmk:jmxtools:jar:1.2.1
遇到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=
2013-01-08 18:29:33
2997
转载 Master-Slave通用基础框架
Master-Slave通用基础框架一、设计目的 设计出一个通用的Master-Slave基础框架，然后可以基于这个框架来实现特定的业务需求，比如实现多节点并行计算等。二、设计理念 基于经典的命令模式，Master和Slave之间通过相互发送命令(Command)实现交互，命令是一个抽象的概念，Command可以用来分发任务,
2012-12-27 11:11:35
1805
原创 intel hadoop manager安装配置
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
2012-11-29 11:44:37
2592
1
原创 oozie postgresql
oozie.service.StoreService.jdbc.driver org.postgresql.Driver oozie.service.StoreService.jdbc.url jdbc:postgresql://localhost:5432/oozie oozie.servic
2012-09-28 11:15:02
772
原创 sqoop mysql Last packet sent to the server was 1 ms ago
sqoop import --connect jdbc:mysql://localhost:3306/ptx --username hadoop --password hadoop --table testsqoop -m 1 --num-mappers 5 --append** BEGIN NESTED EXCEPTION ** java.net.ConnectExc
2012-09-27 09:57:16
2672
原创 thrift 访问hive
编译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/
2012-09-10 09:54:52
1489
原创 cloudera hue
下载hue 1.2以前叫cloudera desktop，使用django作为web框架1. 安装 HADOOP_HOME=/hadoop/hadoop0.20.2 PREFIX=/hadoop/hue make installwaiting .. .. ..执行完会在PREFIX指定的路径下生成hue的服务程序2.配
2012-09-06 10:22:17
4587
原创 mongodb base
下载 http://fastdl.mongodb.org/linux/mongodb-linux-i686-2.0.7.tgztar zvxf mongodb-linux-i686-2.0.7.tgzcd mongodb-linux-i686-2.0.7/bin./mongod>>> import pymongo>>> conn = pymongo.Connecti
2012-08-21 14:30:22
670
mongodb base
下载 http://fastdl.mongodb.org/linux/mongodb-linux-i686-2.0.7.tgztar zvxf mongodb-linux-i686-2.0.7.tgzcd mongodb-linux-i686-2.0.7/bin./mongod>>> import pymongo>>> conn = pym...
2012-08-21 14:30:00
105
hadoop ssh 配置
$: ssh-keygen -t dsa -P '' -f ~/.ssh/id_dsa-t 密钥类型 -P 密语 the passphrase-f 密钥文件cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keyschmod 775 ~/.sshchmod 600 ~/.ssh/authorized_keys...
2012-08-20 13:03:00
103
原创 redis base
$ 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"
2012-08-15 15:53:35
635
redis base
$wgethttp://redis.googlecode.com/files/redis-2.4.16.tar.gz$tarxzfredis-2.4.16.tar.gz$cdredis-2.4.16$make$src/redis-server$src/redis-cliredis>setfoobarOKredis>getfoo"bar"
2012-08-15 15:53:00
103
原创 hive mysql config
cp hive-default.xml.template hive-site.xmlhive.metastore.local truejavax.jdo.option.ConnectionURL jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=truejavax.j
2012-08-15 15:03:46
717
hive mysql config
cphive-default.xml.template hive-site.xmlhive.metastore.local truejavax.jdo.option.ConnectionURL jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=truejavax.jdo.option.Connect...
2012-08-15 15:03:00
102
原创 ubuntu config default java
update-alternatives --install /usr/bin/javac javac /home/pt/hadoop/jdk1.6.0_24/bin/javac 300update-alternatives --install /usr/bin/java java /home/pt/hadoop/jdk1.6.0_24/bin/java 300
2012-08-15 10:38:01
854
ubuntu config default java
update-alternatives --install /usr/bin/javac javac /home/pt/hadoop/jdk1.6.0_24/bin/javac 300update-alternatives --install /usr/bin/java java /home/pt/hadoop/jdk1.6.0_24/bin/java 300
2012-08-15 10:38:00
97
原创 tornado
官网：http://www.tornadoweb.org/import tornado.ioloopimport tornado.webclass MainHandler(tornado.web.RequestHandler): def get(self): self.write("Hi,Peter")application = tornado.w
2012-08-06 15:28:33
592
tornado
官网：http://www.tornadoweb.org/import tornado.ioloopimport tornado.webclass MainHandler(tornado.web.RequestHandler): def get(self): self.write("Hi,Peter")application = tornado.w...
2012-08-06 15:28:00
95
原创 You could try using --skip-broken to work around the problem
You could try using --skip-broken to work around the problemYou could try running: package-cleanup --problemspackage-cleanup --dupesrpm -Va --nofiles --nodigestThe program package-cleanup is f
2012-07-26 09:57:21
3094
1
You could try using --skip-broken to work around the problem
You could try using --skip-broken to work around the problemYou could try running: package-cleanup --problemspackage-cleanup --dupesrpm -Va --nofiles --nodigestThe program package-cleanup is...
2012-07-26 09:57:00
8330
原创 python 访问oracle
驱动：cx_oracle(python 2.7+oracle10g)点击打开链接,http://cx-oracle.sourceforge.net/示例：import timeimport cx_Oraclecon = cx_Oracle.connect('user/passwd@127.0.0.1/orcl')start = time.time()cur =
2012-07-17 15:05:51
2169
python 访问oracle
驱动：cx_oracle(python 2.7+oracle10g)点击打开链接,http://cx-oracle.sourceforge.net/示例：import timeimport cx_Oraclecon = cx_Oracle.connect('user/passwd@127.0.0.1/orcl')start = time.time()cur = co...
2012-07-17 15:05:00
88
原创 fedora 17 php环境配置
安装所需模块#yum install httpd php php-common#yum install php-pecl-apc php-cli php-pear php-pdo php-mysql php-pgsql php-pecl-mongo php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcryptlet t
2012-07-13 09:19:02
621
fedora 17 php环境配置
安装所需模块#yum install httpd php php-common#yum install php-pecl-apc php-cli php-pear php-pdo php-mysql php-pgsql php-pecl-mongo php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcryptlet t...
2012-07-13 09:19:00
157
原创 fedora alternatives --config java
first type alternatives --config javaalternatives --install /usr/bin/java java /usr/java/jdk1.6.0_26/jre/bin/java 3alternatives --install /usr/bin/javac javac /usr/java/jdk1.6.0_26/bin/javac 3
2012-06-14 08:49:50
999
fedora alternatives --config java
first type alternatives --config javaalternatives --install /usr/bin/java java /usr/java/jdk1.6.0_26/jre/bin/java 3alternatives --install /usr/bin/javac javac /usr/java/jdk1.6.0_26/bin/javac 3al...
2012-06-14 08:49:00
120
原创 datax测试 读mysql 写hdfs
安装配置ant：下载 解压后配置环境变量ANT_HOME 同时将ANT_HOME/bin添加到PATH安装配置mysql\yum install mysql-server，安装完成后 执行mysqladmin -u root password 'root';grant all privileges on *.* to peter@'localhost' ident
2012-06-11 14:16:58
6756
4
datax测试 读mysql 写hdfs
安装配置ant：下载解压后配置环境变量ANT_HOME 同时将ANT_HOME/bin添加到PATH安装配置mysql\yum install mysql-server，安装完成后执行mysqladmin -u root password 'root';grant all privileges on *.* to peter@'localhost' identified by ...
2012-06-11 14:16:00
389
原创 hadoop base config
$: ssh-keygen -t rsacat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keyschmod 775 ~/.sshchmod 600 ~/.ssh/authorized_keyscore-site.xmlfs.default.name hdfs://ip:porthadoop.tmp.dir /d
2012-06-07 19:42:29
625
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人