vah101的专栏

命令行执行如下操作：curl -o /etc/yum.repos.d/scylla.repo -L http://downloads.scylladb.com.s3.amazonaws.com/rpm/centos/scylla-4.1.repoyum install -y gcc gcc-c++yum install scylla -ymkdir -p /home/scylla/workmkdir -p /home/scylla/datamkdir -p /home/scylla/com

docker run -i -t --network host -p 50070:50070 -p 9000:9000 -p 8088:8088 -p 8040:8040 -p 8042:8042 -p 49707:49707 -p 50010:50010 -p 50075:50075 -p 50090:50090 sequenceiq/hadoop-docker:2.6.0 /etc/bootstrap.sh -bash

Storage Error: part: xx error: E_RPC_FAILURE(-3).IndexScanExecutor failed, error E_RPC_FAILURE, part xx可能是由于数据量太大，处理超时了，可以在graphd的配置文件里面添加storage_client_timeout_ms, storage_client_timeout_ms默认为60秒，你可以增大。修改nebula-graphd.conf，将超时时间改为：--storage_cli.

hdfs使用kerberos以后，执行hadoop fs -ls命令，报错如下：Failed on local exception: java.io.IOException: javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]; Ho

vxbox导入虚拟机报错如下：Failed to load R0 module C:\Program Files\Oracle\VirtualBox/VMMR0.r0: Signature #2/3: Expected at least 2 valid paths, not 1.: \Device\HarddiskVolume2\Program Files\Oracle\VirtualBox\VMMR0.r0 (VERR_SUP_VP_UNEXPECTED_VALID_PATH_COUNT).Fai

执行psql -Upostgres，使用管理员账号登录pg执行如下脚本，其中database为需要修改owner的库，username为需要修改的新owner名称，schema1可以去掉：\c database;DO $$DECLARE r record; i int; v_schema text[] := '{public,schema1}'; v_new_owner varchar := 'username';BEGIN FOR r IN

使用管理员账号登录psql -U postgres按提示输入密码创建用户执行CREATE USER testUser WITH PASSWORD 'xxxx';为该用户创建数据库，注意要设置ownercreate database testUserDatabase with owner=testUser;输入exit退出psql使用新创建的用户登录数据库psql -U testUser -d testUserDatabase按提示输入密码，就可以创建数据表.

进入greenplum的命令行，重置gpmon的密码：gpadmin@master-0:~$ psqlpsql (9.4.24)Type "help" for help.gpadmin=# alter user gpmon with password '123456';ALTER ROLEgpadmin=# \q

http://greenplum-kubernetes.docs.pivotal.io/2-3/index.html部署监控程序GPCChttps://greenplum-kubernetes.docs.pivotal.io/2-3/gpcc.html

pytorch查看GPU信息import torchtorch.cuda.is_available()#cuda是否可用；torch.cuda.device_count()#返回gpu数量；torch.cuda.get_device_name(0)#返回gpu名字，设备索引默认从0开始；torch.cuda.current_device()tensorflow查看GPU信息：import tensorflow as tffrom tensorflow.python.

登录resource manager所在服务器，进入/var/log/hadoop-yarn/yarntail rm-audit.log  读取日志，找到如下内容：2018-10-31 07:11:27,148 INFO resourcemanager.RMAuditLogger: USER=admin    OPERATION=Application Finished - Succe...

https://community.hortonworks.com/articles/74370/snmp-alert.htmlhttps://community.hortonworks.com/articles/92687/ambari-snmp-notifications-opennms.htmlhttps://github.com/apache/ambari/tree/trunk/c...

修改配置文件elasticsearch.yml，增加http.cors.allow-headers: Authorization访问head时，url如下所示：http://192.168.100.100:9100/?auth_user=elastic&auth_password=changeme

ERROR: DISABLED: Security features are not availablehttp://dy.163.com/v2/article/detail/DDB8IVJ10511E4FG.html

修改log4j.properties文件中的：# Define the root logger to the system property "plsql.root.logger".log4j.rootLogger=./sql.log# Logging Threshold to INFO for queryserver. root logger still at WARN for sqlline ...

import com.sun.org.apache.xerces.internal.impl.dv.util.*;import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; import java.util.Hashtable; import java.util.logging....

1. 下载安装python 3.6yum install sqlite-devel openssl-develwget https://www.python.org/ftp/python/3.6.5/Python-3.6.5.tgztar zxvf Python-3.6.5.tgzcd Python-3.6.5./configuremake install2. 安装nodejscd /usr/lo...

使用mount.nfs  $nfs_ip:/  /mnt/hdfs之后，向/mnt/hdfs拷贝文件保存cp: 无法创建普通文件: 输入/输出错误于是，修改hdfs的配置项：dfs.namenode.accesstime.precision将其从默认的0，修改为3600000，重启hdfs后，问题解决。参考：http://www.itweet.cn/blog/2017/07/20/write-da...

https://henning.kropponline.de/2014/11/21/install-httpfs-gateway-kerberized-cluster/

客户端调用phoenix的jdbc接口，代码如下：    Connection conn = DriverManager.getConnection(url);    Statement statement = conn.createStatement();    ResultSet rset = statement.executeQuery("select a from test1"

参考：http://talat.uyarer.com/post/121179803796/how-to-connect-hbase-using-apache-phoenix-from1.  从http://phoenix.apache.org/download.html下载phoenix的源码包2.  拷贝phoenix-core-4.3.1.jar phoenix-4.3.1-c

下载Greenplum的postgis插件https://network.pivotal.io/products/pivotal-gpdb/#/releases/4540/file_groups/493执行：gppkg -i postgis-ossv2.0.3_pv2.0.1_gpdb4.3-rhel5-x86_64.gppkg即可完成安装执行如下测试例子：

[gpadmin@gp6 ~]$ gpstart20170511:17:26:46:005547 gpstart:gp6:gpadmin-[INFO]:-Starting gpstart with args: 20170511:17:26:46:005547 gpstart:gp6:gpadmin-[INFO]:-Gathering information and validating t

1. 如果是源码安装，需要进入源码的contib目录，进行make；make install2. CREATE EXTENSION  postgres_fdw;3. CREATE SERVER gp_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '10.20.100.60', dbname 'test', port '5432

参考https://my.oschina.net/Kenyon/blog/739351. pgbouncer.ini配置如下，其中连接postgresql的用户名为postgres密码为test：[databases]pgsql1 = host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test

参考：https://discuss.pivotal.io/hc/en-us/articles/202967503-Greenplum-Error-Interconnect-Error-writing-an-Outgoing-Packet-Operation-not-Permitted-检查防火墙是否关闭：service iptables status只要结果不是：

借鉴：http://www.cnblogs.com/scoter2008/p/5928972.html基于Centos 7编译前的准备工作：关闭防火墙systemctl start firewalld.service#启动firewallsystemctl stop firewalld.service#停止firewallsyst

下载postgresql，可以根据操作系统类型选择二进制包，解压后直接可以使用https://github.com/begriffs/postgrest其次，在postgresql中创建账户，并赋予select权限stock=# create role tester login password '111111';stock=# create user name passwo

参考http://airbnb.io/superset/installation.html1. 安装环境基于python 2.7或3.4，2. 安装所需的包sudo yum upgrade python-setuptoolssudo yum install gcc gcc-c++ libffi-devel python-devel python-pip python-wheel

同比：Iif(IsEmpty(([table_profit].[报告期].CurrentMember.Parent.PrevMember, [Measures].[净利率(%)])) OR IsEmpty([Measures].[净利率(%)]) OR ([table_profit].[报告期].CurrentMember.Parent.PrevMember, [Measures].[净利率(

安装hue之前，要首先安装其依赖的库：yum -y install ant gcc g++ krb5-devel mysql openssl-devel cyrus-sasl-devel cyrus-sasl-gssapi sqlite-devel libtidy libxml2-devel libxslt-devel openldap-devel python-devel python2-s

from pyspark import SparkContextfrom pyspark.sql import SQLContextfrom pyspark.sql.types import *def parse(line):    items = line.split(",")    return (long(items[0]), items[1], float(it

http://blog.youkuaiyun.com/hj7jay/article/details/60127995——增大/dev/random的熵池。问题的原因是由于熵池不够大，所以增大它是最彻底的方法。 通过 cat /proc/sys/kernel/random/entropy_avail 我们可以查看现在的熵池大小；我们需要找到一种方式来提高这个值就行了。如果你的CPU带有DRNG特

ambari安装oozie时报错，resource_management.core.exceptions.ExecutionFailed: Execution of '/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.102-4.b14.el7.x86_64//bin/java -cp '/var/lib/ambari-agent/cred/lib/*' org.ap

配置好hue+kerberos后，启动报错：[19/Jan/2018 07:10:08 +0000] kt_renewer INFO Renewing kerberos ticket to work around kerberos 1.8.1: /usr/bin/kinit -R -c /var/run/hue/hue_krb5_ccachekinit: KDC can't fulf...

在hbase的命令行import org.apache.hadoop.hbase.filter.CompareFilterimport org.apache.hadoop.hbase.filter.SingleColumnValueFilterimport org.apache.hadoop.hbase.filter.SubstringComparatorimport org.apa