- 博客(134)
- 资源 (111)
- 收藏
- 关注
原创 WIN10左侧导航栏磁盘重复显示的解决方案
1、如下图:2、解决方法运行regedit,找到:HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/CurrentVersion/Explorer/Desktop/NameSpace/DelegateFolders/把{F5FB2C77-0E2F-4A16-A381-3E560C68BC83} 项重命名为:-{F5FB2C77-0E2F-4A16-A381-3E560C68BC83} (前面加"-")...
2022-05-26 14:36:11
1747
原创 centos安装配置nginx
1、yum安装nginxsudo yum -y install nginx2、启动并设置开机自动运行nginxsudo systemctl start nginxsudo systemctl enable nginx3、查看nginx状态sudo systemctl status nginx
2022-05-22 18:59:48
513
原创 ORACLE之存储过程异常捕获并抛出
create or replace proceduce "PROC_MY_TEST"(IN_P1 IN VARCHAR2, IN_P2 IN VARCHAR2) AS V_SQL VARCHAR2(4000); V_ERRCODE VARCHAR2(10); V_ERRMSG VARCHAR2(3000); MY_EXP EXCEPTION;BEGIN -- test RAISE MY_EXP; .
2021-11-16 14:25:55
2357
原创 Oracle杀死正在运行的SQL
1、查询正在运行的SQLSELECT b.sid oracleID, b.username, b.serial#, spid, paddr, sql_text, b.machineFROM v$session bLEFT JOIN v$process a ON a.addr = b.paddrLEFT JOIN v$sqlarea c ON b.sql_hash_value = c.hash_valueWHERE sql_text IS NOT NULL;2、杀死进程AL
2021-05-08 09:15:08
4023
原创 [MySQL] -- row_number功能实现
1. 栗子:SELECT username, password, age, row_number() over(partition by username order by age desc) as rnFROM tb_userWHERE rn = 12. 实现:SELECT username, password, ageFROM ( SELECT @rowno:=@rowno+1 AS rowno, username, password, age FROM tb_use
2021-01-29 09:20:37
196
原创 [Spark/Hive] -- Spark执行jar包
./spark-submit \--master yarn \--deploy-mode client \--num-executors 10 \--executor-memory 2g \--executor-cores 2 \--driver-memory 1g \--conf spark.default.parallelism=1000 \--conf spark.suffle.memoryFaction=0.3 \--hiveconf hive.cli.print.header=.
2020-12-11 11:04:54
453
原创 [MySQL] -- 新增索引
创建表CREATE TABLE tb_user ( id int primary key auto_increment, user_name varchar(50), password varchar(20), pkfields varchar(100)) ENGINE=InnoDB DEFAULT CHARSET=utf8;1、唯一索引ALTER TABLE tb_user ADD UNIQUE (user_name, pkfields);...
2020-12-11 10:59:33
168
原创 [Spark/Hive] -- Hive启停命令
1、启动命令#!/bin/bashnohup hive --service metastore >> $HIVE_HOME/log/metasotre.log 2>&1 &nohup hive --service hiveserver2 >> $HIVE_HOME/log/hiveserver.log 2>&1 &2、停止命令#!/bin/bashprocess="hive"PID=$(ps x | grep
2020-12-11 10:45:45
1095
原创 [Oracle] -- Oracle导入TXT数据到Table
1、创建TB_USER.ctl文件load datacharacterset utf8infile '/data/ctl_file/tb_user.1.txt'infile '/data/ctl_file/tb_user.2.txt'append into table TB_USERfields terminated by '\t'TRAILING NULLCOLS( ID, USER_NAME, PASSWORD)2、导入命令sqlldr userid="user/pa
2020-12-11 10:37:59
310
原创 [Oracle] -- 创建表空间、用户、授权
./sqlplus user/password@ip/db# 创建表空间SQL> create tablespace myspace datafile '/data/oracle/myspace.dbf' size 600M autoextend on;# 创建用户SQL> create user root identified by 'root' default tablespace myspace;# 授权SQL> grant connect, resource, .
2020-12-11 10:26:17
148
原创 [Oracle] -- Oracle之导入 & 导出
1、EXP---- 单表导出exp user/password@ip/ORACLE_SID file=/data/sampleDB.dmp tables=TB_USER[root@ip ~] sed -n 1p sampleDB.dmpTEXPORT:V11.02.00[root@ip ~] sed -n 2p sampleDB.dmpDNK_POC[root@ip ~] sed -n 3p sampleDB.dmpRTABLESimp user/password@ip/OR
2020-12-11 10:18:48
181
原创 [Oracle] -- Oracle创建表、删除表、新增序列、主键自增
1、创建过程create or replace procedure proc_dropifexists( p_table in varchar2) isv_count number(10);begin select count(*) into v_count from user_tables where upper(table_name)=upper(p_table); if v_count > 0 then execute immediate 'dr
2020-12-11 10:00:58
366
原创 [Oracle] -- 配置Oracle环境变量
1、Oracle客户端source /root/.cshrc# .cshrc#alias rm 'rm -i'#alias cp 'cp -i'#alias mv 'mv -i'export LANG=en_USexport ORACLE_HOME=/usr/lib/oracle/11.2/client64export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH:.export TNS_ADMI
2020-12-11 09:37:37
1044
原创 [Spark/Hive] -- Spark UDF
1、定义UDFimport java.util.Randomdef randomPrefixUDF(value: String): String = { new Random().nextInt(10).toString() + "_" + value.toInt}def removePrefixUDF(value: String): String = { value.split("_")(1)}2、注册UDFspark.udf.register("random_pre
2020-12-11 09:20:12
259
原创 [Nginx] -- 504 Gateway Time-out的解决方法
1、代理超时proxy_send_timeout 300;proxy_read_timeout 300;send_timeout 300;2、fastcgi超时fastcgi_connect_timeout 300;fastcgi_send_timeout 300;fastcgi_read_timeout 300;3、重启./nginx -s reload
2020-12-10 16:51:17
1460
原创 [Oracle] -- 修改用户名、密码
[oracle@hostname ~]$ export ORACLE_SID=eastdb[oracle@hostname ~]$ sqlplus / as sysdbaSQL*PLUS: Release 12.2.0.1.0 Production on FriCopyright (c) 1982, 2016, Oracle.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Prod.
2020-12-08 17:06:57
280
原创 [MySQL] -- 中文乱码
1、查看mysql字符编码show variables like '%char%';2、修改my.cnf配置[mysqld]character-set-server=utf8[client]default-character-set=utf8[mysql]default-character-set=utf83、重启mysql,然后查看编码4、修改数据库和表的字符编码alter database mydb character set UTF8;show create.
2020-11-20 17:35:22
129
原创 [SHELL] -- 常用命令及实例
1、判断字符串是否以a-zA-Z字母开始hive_table="tb_user"table="${hive_table:0:2}" # 截取echo "table=$table"if [[ $hive_table == tb* || $hive_table == TB* ]]then echo "$hive_table 以TB开头"else echo "$hive_table 不符合..."fi...
2020-11-20 17:23:58
509
原创 [GIT] -- 命令备忘
1、配置用户名、邮件git config --global user.name="xxx"git config --global user.email="xxx@163.com"2、查看配置git config -l
2020-11-20 17:14:08
109
原创 [MySQL] -- update inner join的使用(子查询更新)
1、建表语句CREATE TABLE `tb_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `age` int(11) DEFAULT NULL, `sex` varchar(10) DEFAULT NULL, `datatype` varchar(2) DEFAULT NULL, `pkfields` int(11) DEFAULT NULL, PRIMARY K...
2020-11-20 15:24:43
2893
1
原创 [Spark/Hive] -- Load CSV File to Hive
1、创建表CREATE TABLE t_user ( id INT, username STRING, password STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'WITH SERDEPROPERTIES ("separatorChar"=",", "quotechar"="\"")...
2019-11-20 14:54:29
494
原创 [Spark/Hive] -- Spark操作Hive
1、下载spark并解压wget http://mirrors.tuna.tsinghua.edu.cn/apache/spark/spark-2.3.4/spark-2.3.4-bin-hadoop2.6.tgztar zxvf spark-2.3.4-bin-hadoop2.6.tgz2、配置1)将hive-site.xml拷贝到$SPARK_HOME/conf目录下。2...
2019-11-06 11:45:39
171
原创 Apache Ranger安装部署
1、下载$ git clone https://github.com/apache/incubator-ranger.git$ cd incubator-ranger$ git checkout ranger-1.22、编译$ mvn -DskipTests -Drat.skip=true -DskipJSTests clean compile package install ...
2019-09-03 16:55:35
2460
4
原创 DBeaver访问不了kerberos环境的hive
1、错误:unsupported key type found the default TGT: 18GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]* 原因:这个是AES256加密算法,...
2019-08-30 10:31:19
3507
原创 CentOS 7 中 YUM安装桌面环境
我的Centos7是最小化安装的1、首先要先安装XWindows:# yum upgrade# yum -y groupinstall "X Window System"2、安装KDE环境:# yum -y groups install "KDE Plasma Workspaces"3、启动:# startx4、桌面截图:...
2019-08-30 09:27:22
1224
原创 Hive无法读取Parquet
查询Hive表,报错:Failed with exception java.io.IOException:parquet.io.ParquetDecodingException: Can not read value at 0 in block -1 in file hdfs://xxx:8020/user/hive/warehouse/tmp.db/table1/part-00000.snapp...
2019-08-02 10:01:50
3530
原创 CentOS 常用命令整理
1、网络命令:(1)网卡地址[spark@master~]$ ip add1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00...
2019-07-09 09:37:09
245
原创 Centos7 配置ISO镜像文件为本地YUM源
1)创建挂载路径sudo mkdir /media/iso2)挂载ISO镜像到目录sudo mount -o loop CentOS-7-x86_64-Minimal-1708.iso /media/iso3)验证挂载df -h4)创建本地yum源配置文件sudo touch /etc/yum.repos.d/local.repo5)编辑local.re...
2019-07-05 10:11:40
5890
原创 Centos7 使用阿里云的YUM源
1)备份yum源mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak2)下载阿里云的CentOS-Base.repowget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo...
2019-07-05 09:36:47
353
原创 docker swarm集群搭建以及安装shipyard
1)docker安装https://blog.youkuaiyun.com/kanaka10/article/details/945523232)配置swarm集群$ sudo docker swarm init --advertise-addr [ip_addr]3)查看节点$ sudo docker node ls4)查看manager节点$ sudo docker ...
2019-07-03 17:21:59
492
1
原创 Docker 安装部署
1) 使用yum 安装yum-utilssudo yum install -y yum-utils2)增加docker源sudo yum-config-manager \--add-repo \https://download.docker.com/linux/centos/docker-ce.repo3)查看docker源是否可用sudo yum-config...
2019-07-03 10:24:00
1121
原创 Spark保存到Phoenix错误:org.apache.phoenix.mapreduce.PhoenixOutputFormat not found
1)Hadoop集群: cdh5.13.02)Phoenix版本: 4.14.0-cdh5.13.23)Spark版本: SPARK2-2.4.0.cloudera1-1.cdh5.13.33)代码: df.saveToPhoenix(Map("table" -> table_name, "zkUrl" -> zkUrl))4)...
2019-06-27 13:57:11
1021
原创 Container is running beyond physical memory limits
1、Hive执行SQL语句,出现如下错误:Container is running beyond physical memory limits. Current usage: 4.3 GB of 4 GB physical memory used; 8.9 GB of 8.4 GB virtual memory used. Killing container. 2、错误分析:4....
2019-06-19 09:53:22
2876
原创 java.lang.NoSuchMethodError: com.lmax.disruptor.dsl.Disruptor.<init>
spark操作HBase:19/06/14 16:08:22 ERROR executor.Executor: Exception in task 2.0 in stage 1.0 (TID 5)com.google.common.util.concurrent.ExecutionError: java.lang.NoSuchMethodError: com.lmax.disruptor....
2019-06-14 16:33:40
3442
1
kindEditor
2011-07-04
kindeditor-3.5.5中文版
2011-07-01
zinherit 库
2009-04-13
ASP.NET绑定DataSet中的多个表收藏
2009-03-07
很酷的时钟 (跟随鼠标飘动的双层时钟!).
2009-02-26
页面转向的进度条 代码
2009-02-26
开发和使用Web用户控件
2009-02-26
Bind和Eval的区别详解
2009-02-26
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人