cd /usr/local/hadoop ./bin/hadoop jar ./share/hadoop/mapreduce/hadoop-mapreduce-examples-2.7.4.jar grep /user/hadoop/input /user/hadoop/output 'dfs[a-z.]+'
Harbor is an open source container image registry that secures images with role-based access control, scans images for vulnerabilities, and signs images as trusted. A CNCF Incubating project, Harbor delivers compliance, performance, and interoperability to help you consistently and securely manage images across cloud native compute platforms like Kubernetes and Docker.
[root@k8s-master ~]# etcdctl -C http://192.168.11.21:2379 cluster-health member 8e9e05c52164694d is healthy: got healthy result from http://192.168.11.21:2379 cluster is healthy
[root@k8s-master ~]# kubectl get componentstatus NAME STATUS MESSAGE ERROR etcd-0 Healthy {"health":"true"} scheduler Healthy ok controller-manager Healthy ok
为Node节点安装Kubernetes
在k8s-node1& k8s-node2节点分别执行以下命令：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
yum install kubernetes-node.x86_64 -y # 安装k8s
vim /etc/kubernetes/config :set nu # 修改kubernetes配置文件 KUBE_MASTER="--master=http://192.168.11.21:8080"
IF TO_NUMBER(ASCII(FILED_VAL4)) = 90 THEN FILED_VAL4 := '0'; IF TO_NUMBER(ASCII(FILED_VAL3)) = 90 THEN FILED_VAL3 := '0'; IF TO_NUMBER(ASCII(FILED_VAL2)) = 90 THEN FILED_VAL2 := '0'; IF TO_NUMBER(ASCII(FILED_VAL1)) = 57 THEN FILED_VAL1 := 'A'; ELSE FILED_VAL1 := CHR(TO_NUMBER(ASCII(FILED_VAL1)) + 1); END IF; ELSE IF TO_NUMBER(ASCII(FILED_VAL2)) = 57 THEN FILED_VAL2 := 'A'; ELSE FILED_VAL2 := CHR(TO_NUMBER(ASCII(FILED_VAL2)) + 1); END IF; END IF; ELSE IF TO_NUMBER(ASCII(FILED_VAL3)) = 57 THEN FILED_VAL3 := 'A'; ELSE FILED_VAL3 := CHR(TO_NUMBER(ASCII(FILED_VAL3)) + 1); END IF; END IF; ELSE IF TO_NUMBER(ASCII(FILED_VAL4)) = 57 THEN FILED_VAL4 := 'A'; ELSE FILED_VAL4 := CHR(TO_NUMBER(ASCII(FILED_VAL4)) + 1); END IF; END IF; /*拼接处理结果 RETURN*/ RTN_FIELD := FILED_VAL1||FILED_VAL2||FILED_VAL3||FILED_VAL4; END IF; /*DBMS_OUTPUT.PUT_LINE('RETURN-:' || RTN_FIELD);*/ RETURN RTN_FIELD; END FN_CTPK_INCREASE; /
测试调用
1 2 3 4 5 6 7 8 9 10 11
/* 测试： 循环插入数据 查看主键的变化*/ BEGIN FOR i IN 1 .. 1000 LOOP INSERT INTO SCOTT.CITY (CID, CNAME, CTYCODE, DISTRICT, INFO) VALUES (FN_CTPK_INCREASE(), 'Shanghai', 'CHN', 'Shanghai', '{"Population": 9696300}'); END LOOP; END;
PS：原主键生成方式：
1 2 3
SELECT NVL((SELECT CID +1FROM CITY WHERE CID >' 'AND ROWNUM =1 ), '1000') FROM DUAL;
set serveroutput on; begin INSERT INTO SCOTT.EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (7986, 'Nathan', 'SYSDBA', 7698, TO_DATE('2019-09-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 18621.00, null, 20); DBMS_OUTPUT.PUT_LINE('INSERT:EMP=>受影响的行数是'||SQL%ROWCOUNT||'行'); end;
--执行结果: [2019-09-04 11:38:57] completed in 24 ms [2019-09-04 11:38:57] INSERT:EMP=>受影响的行数是1行
SELECT INTO使用游标：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
set serveroutput on; declare ename varchar2(20); sal number; begin select emp.ename, emp.sal into ename , sal from emp where emp.empno = 7986; DBMS_OUTPUT.PUT_LINE('SELECT:EMP=>'||ename||'的薪水是'||sal); exception when NO_DATA_FOUND then DBMS_OUTPUT.PUT_LINE('SELECT:EMP=>没有找到数据！'); end;
-- 执行结果: [2019-09-04 11:39:54] completed in 6 ms [2019-09-04 11:39:54] SELECT:EMP=>Nathan的薪水是18621
UPDATE使用游标：
1 2 3 4 5 6 7 8 9
set serveroutput on; begin update emp set emp.sal = 8000 where emp.empno = 7986; DBMS_OUTPUT.PUT_LINE('UPDATE:EMP=>受影响的行数是'||SQL%ROWCOUNT||'行'); end;
-- 执行结果: [2019-09-04 11:40:28] completed in 168 ms [2019-09-04 11:40:28] UPDATE:EMP=>受影响的行数是1行
DELETE使用游标：
1 2 3 4 5 6 7 8 9
set serveroutput on; begin delete from emp where emp.empno = 7986; DBMS_OUTPUT.PUT_LINE('DELETE:EMP=>受影响的行数是'||SQL%ROWCOUNT||'行'); end;
--执行结果: [2019-09-04 11:41:48] completed in 10 ms [2019-09-04 11:41:48] DELETE:EMP=>受影响的行数是1行
-- 游标的 declare -- 声明游标 cursor cur is select emp.ENAME,emp.SAL from emp; ename emp.ename%type; sal emp.sal%type; begin -- 打开游标 open cur; loop -- 检索数据 fetch cur into ename,sal; -- 当游标中没有数据的时候退出 exit when cur%notfound; DBMS_OUTPUT.PUT_LINE(ename|| '的薪水是'|| sal); end loop; -- 关闭游标 close cur; end;