2020年06月_杨鑫newlfe

11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创数据仓库Build The Data Warehouse（William H.Inmon）学习笔记 --- 第三章、设计数据仓库

零、建设企业数据仓库主要两个方面？与操作型系统接口的设计数据仓库本身的设计建造数据仓库时发生了什么？首先载入一部分数据，供DSS分析员使用和查看。然后根据最终用户的反馈，在数据仓库中修改、增添一些数据；这种反馈循环贯穿于整个数据仓库的开发过程；仅仅用过去曾用的设计方法就可以满足需求的想法是错误的。部分需求是不可能预..

2020-06-30 22:21:29 679

原创 LeetCode --- 746. Min Cost Climbing Stairs 解题报告

On a staircase, thei-th step has some non-negative costcost[i]assigned (0 indexed).Once you pay the cost, you can either climb one or two steps. You need to find minimum cost to reach the top of the floor, and you can either start from the step with i...

2020-06-29 15:19:34 273

原创 LeetCode --- 744. Find Smallest Letter Greater Than Target 解题报告

Given a list of sorted charactersletterscontaining only lowercase letters, and given a target lettertarget, find the smallest element in the list that is larger than the given target.Letters also wrap around. For example, if the target istarget = 'z'...

2020-06-28 16:34:17 240

原创误删了Crontab调度信息怎么办？如何找回调度时间？

最近最近的某天发现Crontab日常的调度信息不见了。那么这种很棘手并没有没有备份的情况下怎么办呢？解决办法： 1.找到调度的脚本； 2.找到调度的日期/频率； 1.我们先去找到crontab的默认日志路径（Centos6/7中，其余版本百度查找）：/var/log 。我们找到如上图类似 cron- 开头的文件，会根据周或者其余频率定期的保留近期的日志快照。我们切换到文件的读写权限对应用户，然后查看vim/cat均可。然后找到对应的命令调度脚...

2020-06-28 16:23:47 411

原创 LeetCode --- 733. Flood Fill 解题报告

Animageis represented by a 2-D array of integers, each integer representing the pixel value of the image (from 0 to 65535).Given a coordinate(sr, sc)representing the starting pixel (row and column) of the flood fill, and a pixel valuenewColor, "floo...

2020-06-24 00:48:37 283

原创 LeetCode --- 728. Self Dividing Numbers 解题思路

Aself-dividing numberis a number that is divisible by every digit it contains.For example, 128 is a self-dividing number because128 % 1 == 0,128 % 2 == 0, and128 % 8 == 0.Also, a self-dividing number is not allowed to contain the digit zero.Give...

2020-06-22 23:42:34 245

原创 LeetCode --- 724. Find Pivot Index 解题报告

Given an array of integersnums, write a method that returns the "pivot" index of this array.We define the pivot index as the index where the sum of all the numbers to the left of the index is equal to the sum of all the numbers to the right of the index.

2020-06-20 21:09:58 279

原创 LeetCode --- 720. Longest Word in Dictionary 解题报告

Given a list of stringswordsrepresenting an English Dictionary, find the longest word inwordsthat can be built one character at a time by other words inwords. If there is more than one possible answer, return the longest word with the smallest lexicog...

2020-06-20 00:34:05 250

原创 Python 实现不使用语言自带的函数计算两个日期的差值

题目：写一个函数，输入是两个日期，输出是这两个日期的日差。例如：输入是20190102和20190103，输出是1要求：1、不能使用系统自带函数直接减2、不能使用时间戳3、日期格式是字符串类似2019-01-02格式，只考虑四位字符年份所有代码均可在Github中找到：下载链接# -*- coding:utf-8 -*-__author__ = 'yangxin_ryan'"""Solutions:题目：写一个函数，输入是两个日期，输出是这两个日期的日差。例如：输入

2020-06-17 17:23:32 645

原创数据仓库Build The Data Warehouse（William H.Inmon）学习笔记 --- 第二章、数据仓库环境

一、数据仓库是体系结构设计环境的核心，是决策系统DSS处理的基础；数据仓库是一个面向主题的、集成的、非易失的且随时间变化的数据集合，用来支持员工的决策；如下是一个数据面向应用（操作型环境）和面向主题（数据仓库）的例子操作型环境数据仓库汽车顾客人寿保险单健康保险费 ..

2020-06-14 00:36:20 665

原创 LeetCode --- 717. 1-bit and 2-bit Characters 解题报告

We have two special characters. The first character can be represented by one bit0. The second character can be represented by two bits (10or11).Now given a string represented by several bits. Return whether the last character must be a one-bit charac...

2020-06-13 20:46:25 281 1

原创 LeetCode --- 709. To Lower Case 解题报告

Implement function ToLowerCase() that has a string parameter str, and returns the same string in lowercase.Example 1:Input: "Hello"Output: "hello"Example 2:Input: "here"Output: "here"Example 3:Input: "LOVELY"Output: "lovely"所有代码均可在.

2020-06-12 09:15:06 237

原创 LeetCode --- 706. Design HashMap 解题报告

Design a HashMapwithout using any built-in hash table libraries.To be specific, your design should include these functions:put(key, value):Insert a (key, value) pair into the HashMap. If the value already exists in the HashMap, update the value. ge...

2020-06-11 00:40:49 253

原创 LeetCode --- 705. Design HashSet 解题报告

Design a HashSetwithout using any built-in hash table libraries.To be specific, your design should include these functions:add(value):Insert a value into the HashSet. contains(value): Return whether the value exists in the HashSet or not. remove(...

2020-06-10 01:15:07 290

原创 LeetCode --- 704. Binary Search 解题报告

Given asorted(in ascending order) integer arraynumsofnelements and atargetvalue, write a function to searchtargetinnums. Iftargetexists, then return its index, otherwise return-1.Example 1:Input: nums = [-1,0,3,5,9,12], target = 9Output...

2020-06-08 09:36:50 234

原创 LeetCode --- 703. Kth Largest Element in a Stream 解题报告

Design a class to findthekth largest element in a stream. Note that it is the kth largest element in the sorted order, not the kth distinct element.YourKthLargestclass will have a constructor which accepts an integerkand an integer arraynums, whic...

2020-06-06 13:21:12 265

原创 Sqoop导出Mysql报错主键冲突

2020-06-03 22:28:07,801 ERROR [Thread-12] org.apache.sqoop.mapreduce.AsyncSqlOutputFormat: Got exception in update thread: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1109883-2020-05-31 00:00:00' for key...

2020-06-04 12:54:02 1003 2

原创 LeetCode --- 700. Search in a Binary Search Tree 解题报告

Given the root node of a binary search tree (BST) and a value. You need to find the node in the BST that the node's value equals the given value. Return the subtree rooted with that node. If such node doesn't exist, you should return NULL.For example,.

2020-06-04 09:13:41 241

原创 LeetCode --- 697. Degree of an Array 解题报告

Given a non-empty array of non-negative integersnums, thedegreeof this array is defined as the maximum frequency of any one of its elements.Your task is to find the smallest possible length of a (contiguous) subarray ofnums, that has the same degree ...

2020-06-02 14:27:03 254

原创 LeetCode --- 696. Count Binary Substrings 解题报告

Give a strings, count the number of non-empty (contiguous) substrings that have the same number of 0's and 1's, and all the 0's and all the 1's in these substrings are grouped consecutively.Substrings that occur multiple times are counted the number of .

2020-06-01 23:48:07 235

原创 Flume能否代替Canal实时同步Mysql的Binlog数据？

零、不废话先说结论 1.Flume不能代替Canal实时同步Mysql的Binlog数据（内部机制不支持）； 2.Flume可以实现实时同步Mysql的数据（插件的方式）；下面是具体的结论理由推断；一、Canal在同步Mysql的Binary log的作用功能上看 1.master将改变记录到二进制日志（binary log）中（这些记录叫做二进制日志事件，binary log events, ..

2020-06-01 00:03:19 3694