- 博客(96)
- 资源 (3)
- 收藏
- 关注
RSS订阅转载 主机和虚拟机共享文件设置
查看 （注意：挂载后必须要再次进入/mnt/hgfs才能查看到共享的文件夹）用此方法添加全部需要共享的文件夹，添加完成后如下图所示，点击“确定”“名称”即虚拟机中显示的名称，点击“下一步”->“完成”点击“添加”，进入共享文件夹向导。打开 “设置 -> 选项 -> 共享文件夹”选择需要共享的文件夹，点击确定。最后一个重要步骤：挂载操作。
2023-12-20 18:10:46
196
转载 NAT模式虚拟机上网配置
以上是Vmware网络配置的全部，本文简单的介绍了虚拟机网络配置的相关问题。还有很多不全面的问题，欢迎个位大佬指点；如果觉得笔者不易，请给予一些支持，给予我记录更多文章的动力。Vmware虚拟机Centos7系统如何连接网络？ping不通百度？_虚拟机ping不通百度-CSDN博客。
2023-12-20 17:24:23
419
原创 Oracle 19c 可插拔数据库PDB的创建方式
1.有且仅有一个CDB Root(CDB$ROOT)，它包含了Root和所有PDB数据库的元数据和数据字典信息。2.有且仅有一个Seed PDB(PDB$SEED),它的作用是创建其他PDB的模板，它是只读库，不能做任何修改。3.0个或多个应用程序容器Application Container，每个Application Container包含一个Application Root，以及插在这个root上的Application PDBs，Application Root属于CDB Root。
2023-11-02 22:39:24
3112
原创 ORA-00333
7、mount状态下调整SCN号，执行alter session set events '10015 trace name ADJUST_SCN level 1'2、从pfile中启动，执行recover database until cancel，选择cancel。1、在pfile中增加隐藏参数_allow_resetlogs_corruption=TRUE。6、原因是数据块SCN号小于当前SCN号，用ADJUST_SCN调整SCN号。4、执行alter database open resetlogs。
2023-09-09 18:43:15
272
转载 Oracle 11g的自动统计信息收集
Oracle收集失效的统计信息的策略：自上次自动统计信息收集作业完成之后，如果DBA_TAB_MODIFICATIONS中记录的INSERT+UPDATE+DELETE所影响的行记录之和超过了DBA_TABLES中目标表记录数的10%，或者是自上次统计信息收集完成之后目标表执行过truncate操作，那么Oracle会认为目标表的统计信息已经失效，自动统计信息收集作业就会对目标表重新收集统计信息。在某些情况下，需要禁用自动统计信息的收集，可以使用以下3种方法，每种方法禁用范围不同。
2023-08-11 16:07:18
992
原创 Hive表实现一次查询多次插入需要注意的点
Hivesql里，为了提高查询效率，我们可以将通用的功能模块微服务化，除了可以使用with..as这种优化方式外，本文记录另外一种方式:如果目标表是普通表，则需要插入不同的表（tableA和tableB）from（select xx from tableA where xxx）sourcetable --需要起一个别名sourcetableinsert into tableBselect xx where xx --从sourcetable取数insert into tableCs
2020-06-17 18:15:24
4135
原创 HIVE外部表删除重建指定HDFS目录后查询不到数据
HIVE外部表删除重建指定HDFS目录后查询不到数据，怎么办删除了外部表，没有删除hdfs文件 重建了外部表又关联到之前的hdfs目录之后，select查询却没有数据 需要MSCK REPAIR TABLE+tablename，之后查询，数据就回来了。MSCK REPAIR TABLE命令是做啥的MSCK REPAIR TABLE命令主要是用来解决通过hdfs dfs -put或者hdfs api写入hive分区表的数据在hive中无法被查询到的问题。hive有个服务叫metastore，
2020-05-22 15:13:01
4286
原创 Groupings sets实现一次查询多种分组模式
这篇文章描述了 SELECT 语句 GROUP BY 子句的增强聚合功能 GROUPING SETS。GROUPING SETS 子句是 SELECT 语句的 GROUP BY 子句的扩展。通过 GROUPING SETS 子句，你可采用多种方式对结果分组，而不必使用多个 SELECT 语句来实现这一目的。这就意味着，能够减少响应时间并提高性能。在Hive 0.10.0版本中添加了 Grou...
2019-10-09 15:29:42
1803
1
转载 excel绘制气泡图步骤
1.选择数据源2.点击“插入”，选择“图表”中的“气泡图”3.选择图表，右键选择“选择数据”4.弹出界面中，选择“删除”，把里面的项全部删除5.点击“添加”，并按照图示，将数据源一一对应6.重复上一步骤，添加完所有数据，点击确定7.对图表进行优化装饰，完成气泡图...
2019-02-12 15:59:43
11684
1
转载 vlookup使用案例
如图所示，我们要在A2:F12区域中提取工号为100003、100004、100005、100007、100010五人的全年总计销量，并对应的输入到I4:I8中。一个一个的手动查找在数据量大的时候十分繁琐，因此这里使用VLOOKUP函数演示：首先在I4单元格输入“=Vlookup(”，此时Excel就会提示4个参数。第一个参数，显然，我们要让100003对应的是H4，这里就输入...
2019-01-16 16:35:47
920
原创 如何用Tableau绘制涂色地图
做数据分析的地域分析时，用地图的方式呈现出来更为直观一些，下面记录用Tableau10.5的地图功能做一个涂色的地图。 新建数据源连接要绘制地图的源数据表格 数据源导入后点击右下角的转到工作表 左侧列表出现两个模块：维度和度量，所谓的维度就是指的对分析角度的描述，也就是数据源表里的地址字段，而度量就是对分析角度的量化，也就是数据源表里的人口字段。 单击”省份“左上角...
2019-01-16 15:25:35
17039
3
转载 numpy的dtype得到U7是什么意思
解决方案: <表示字节顺序，小端（最小有效字节存储在最小地址中） U表示Unicode，数据类型 7表示元素位长，数据大小 Unicode & String
2018-12-28 10:24:35
5598
原创 Codility经典算法题之三十四：Ladder
Task description：You have to climb up a ladder. The ladder has exactly N rungs, numbered from 1 to N. With each step, you can ascend by one or two rungs. More precisely:with your first step you can st...
2018-04-24 20:57:18
1089
1
转载 Codility经典算法题之三十三：FibFrog
Task Description：The Fibonacci sequence is defined using the following recursive formula: F(0) = 0 F(1) = 1 F(M) = F(M - 1) + F(M - 2) if M >= 2A small frog wants to get to the other side ...
2018-04-24 20:12:04
879
转载 Codility经典算法题之三十二：CommonPrimeDivisors
Task description：A prime is a positive integer X that has exactly two distinct divisors: 1 and X. The first few prime integers are 2, 3, 5, 7, 11 and 13.A prime D is called a prime divisor of a positi...
2018-04-24 16:03:56
640
原创 Codility经典算法题之三十一：ChocolatesByNumbers
Task Description：Two positive integers N and M are given. Integer N represents the number of chocolates arranged in a circle, numbered from 0 to N − 1.You start to eat the chocolates. After eating a c...
2018-04-24 15:56:10
682
原创 Codility经典算法题之二十九：CountSemiprimes
Task description：Aprimeis a positive integer X that has exactly two distinct divisors: 1 and X. The first few prime integers are 2, 3, 5, 7, 11 and 13.Asemiprimeis a natural number that is the pro...
2018-04-23 17:17:11
827
1
转载 Codility经典算法题之二十八：peaks
Task description：A non-empty array A consisting of N integers is given.A peak is an array element which is larger than its neighbors. More precisely, it is an index P such that 0 < P < N − 1, A...
2018-04-23 16:06:05
787
原创 Codility经典算法题之二十七：MinPerimeterRectangle
Task description:An integer N is given, representing the area of some rectangle.Theareaof a rectangle whose sides are of length A and B is A * B, and theperimeteris 2 * (A + B).The goal is to find...
2018-04-23 15:19:31
332
原创 Codility经典算法题之二十六：CountFactors
Task description：A positive integer D is afactorof a positive integer N if there exists an integer M such that N = D * M.For example, 6 is a factor of 24, because M = 4 satisfies the above condition...
2018-04-23 15:08:54
722
转载 Codility经典算法题之二十四：MaxSliceSum
Task description：A non-empty array A consisting of N integers is given. A pair of integers (P, Q), such that 0 ≤ P ≤ Q < N, is called a slice of array A. The sum of a slice (P, Q) is the total of A...
2018-04-23 11:19:33
586
原创 Codility经典算法题之二十三：MaxProfit
Task description：An array A consisting of N integers is given. It contains daily prices of a stock share for a period of N consecutive days. If a single share was bought on day P and sold on day Q, wh...
2018-04-22 21:33:14
868
转载 Codility经典算法题之二十二：EquiLeader
Task description：A non-empty array A consisting of N integers is given.The leader of this array is the value that occurs in more than half of the elements of A.An equi leader is an index S such that 0...
2018-04-22 20:57:36
585
原创 Codility经典算法题之二十一：Dominator
Task description:An array A consisting of N integers is given. Thedominatorof array A is the value that occurs in more than half of the elements of A.For example, consider array A such that A[0] = 3...
2018-04-22 19:15:58
1400
1
转载 Codility经典算法题之二十：Fish
Task description:You are given two non-empty arrays A and B consisting of N integers. Arrays A and B represent N voracious fish in a river, ordered downstream along the flow of the river.The fish are ...
2018-04-22 18:12:45
817
转载 Codility经典算法题之十九：Brackets
Task description:A string S consisting of N characters is considered to be properly nested if any of the following conditions is true:S is empty;S has the form "(U)" or "[U]" or "{U}" where U is a pro...
2018-04-22 17:25:04
1375
原创 Codility经典算法题之十七：Distinct
Task Description:Write a functionclass Solution { public int solution(int[] A); }that, given an array A consisting of N integers, returns the number of distinct values in array A.Assume that:N is an i...
2018-04-22 15:57:00
601
1
转载 Codility经典算法题之十六：MaxProductOfThree
Task description:A non-empty array A consisting of N integers is given. The product of triplet (P, Q, R) equates to A[P] * A[Q] * A[R] (0 ≤ P < Q < R < N).For example, array A such that: A[0...
2018-04-22 15:50:55
620
原创 Codility经典算法题之十五：Triangle
Task description：An array A consisting of N integers is given. A triplet (P, Q, R) istriangularif 0 ≤ P < Q < R < N and:A[P] + A[Q] > A[R],A[Q] + A[R] > A[P],A[R] + A[P] > A[Q].For...
2018-04-22 15:35:03
1374
原创 Codility经典算法题之十四：GenomicRangeQuery
Task descriptionA DNA sequence can be represented as a string consisting of the lettersA,C,GandT, which correspond to the types of successive nucleotides in the sequence. Each nucleotide has ani...
2018-04-22 15:08:29
629
原创 Codility经典算法题之十三：MinAvgTwoSlice
Task description:A non-empty array A consisting of N integers is given. A pair of integers (P, Q), such that 0 ≤ P < Q < N, is called asliceof array A (notice that the slice contains at least ...
2018-04-22 10:44:01
473
原创 Python解算法题之十一：CountDiv
Task description:Write a function:class Solution { public int solution(int A, int B, int K); }that, given three integers A, B and K, returns the number of integers within the range [A..B] that are div...
2018-04-21 22:43:14
656
1
原创 Python解算法题：MissingInteger
Task description:This is a demo task.Write a function:class Solution { public int solution(int[] A); }that, given an array A of N integers, returns the smallest positive integer (greater than 0) that ...
2018-04-21 21:48:34
2543
1
原创 python经典算法题之八：FrogRiverOne
Task description:A small frog wants to get to the other side of a river. The frog is initially located on one bank of the river (position 0) and wants to get to the opposite bank (position X+1). Leave...
2018-04-21 21:29:38
645
1
原创 python经典算法题之七：PermCheck
Task description:A non-empty array A consisting of N integers is given.Apermutationis a sequence containing each element from 1 to N once, and only once.For example, array A such that: A[0] = 4 ...
2018-04-21 21:08:45
704
1
原创 python经典算法题之六：FrogJmp
Task description:A small frog wants to get to the other side of the road. The frog is currently located at position X and wants to get to a position greater than or equal to Y. The small frog always j...
2018-04-21 21:00:49
331
原创 Python经典算法题之五：TapeEquilibrium
Task description:A non-empty array A consisting of N integers is given. Array A represents numbers on a tape.Any integer P, such that 0 < P < N, splits this tape into two non-empty parts: A[0], ...
2018-04-21 20:55:56
652
1
原创 python经典算法题之四：PermMissingElem
Task description:An array A consisting of N different integers is given. The array contains integers in the range [1..(N + 1)], which means that exactly one element is missing.Your goal is to find tha...
2018-04-21 20:20:11
628
1
linux上安装oralce11g文档
2014-08-17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人