On the analysis of 8 kinds of SQL errors

Execution order of SQL statement: FROM <left_table> ON <join_condition> <join_type> JOIN <right_table> WHERE <where_condition> GROUP BY <group_by_list> HAVING <having_condition> SELECT DISTINCT <select_list> ORDER BY <order_by_condition> LIMIT <limit_number> 1. LIMIT stateme ...

Posted by Notoriouswow on Tue, 22 Oct 2019 03:12:33 +0200

Java serialization 43 - other considerations for accessing static methods, static keywords

I. other precautions 1. For methods with static, we said that we need to use the method of "class name", but in fact, we can use the method of "reference" to access this method.   package com.bjpowernode.java_learning; ​ public class D43_ { public static void main(String[] args) { Test3.test3(); ...

Posted by hrichman on Sun, 20 Oct 2019 20:16:43 +0200

Java serialization 42 this can not be omitted, construction method setting default value method

I. When can't this be omitted? Let's give an example to illustrate class User2{ private int id; public int getId() { return id; } public void setId(int id) { this.id = id;//If it's written here id=id,Then according to the principle of proximity, the first id It's the formal parameter. The second one. id Als ...

Posted by juliston on Fri, 18 Oct 2019 20:29:47 +0200

go regular expression

In the first two lessons, we used a lot of regular expressions to match the city list, city and user information. In fact, in addition to regular expressions to match, we can also use goquery and xpath third-party library to match useful information. And I used more elegant regular expression matching. Let's talk about regular expressions. For ...

Posted by lilsim89 on Thu, 17 Oct 2019 20:48:22 +0200

Data cleaning, merging, transformation and reconstruction

Data cleaning Data cleaning is a key step in data analysis, which directly affects the subsequent processing work. Does the data need to be modified? Is there anything to change? How should the data be adjusted for the next analysis and mining? It is an iterative process, and the actual project may need to perform these cleaning operations mo ...

Posted by mooshuligan on Thu, 17 Oct 2019 13:14:30 +0200

2. hdfs architecture

[TOC] I. Overview of HDFS System Composition This is a distributed file system that is suitable for scenarios where multiple reads are written at one time. Contains the following roles: NameNode(nn): Store metadata of files, such as file name, file directory structure, file attributes and so on, as well as block list of each file and DataNode ...

Posted by Nilanka on Mon, 14 Oct 2019 05:24:03 +0200

Oracle RAC Application PSU

1. Backup databaseBoth RMAN and expdp can be used.2. Backup Software Directory (node1/2) tar -czvf /u01/grid.tar.gz /u01/app/11.2.0/grid --exclude=/u01/app/11.2.0/grid/rdbms/audit/* tar -czvf /u01/database.tar.gz /u01/app/oracle/ --exclude=/u01/app/oracle/admin/orcl/adump/* 3. Backup OCR (node1/2) [grid@vastdata01 ~]$ cd $ORACLE_HOME/bin [g ...

Posted by john8m on Wed, 02 Oct 2019 03:53:29 +0200

Kafka Producer Source Code Analysis

Common terms of Kafka Broker: Kafka's server is an instance of Kafka. The Kafka cluster consists of one or more Brokers, which are responsible for receiving and processing client requests. Topic: Topic, a logical container for messages in Kafka. Each message published to Kafka has a corresponding logical container, which is often used to differ ...

Posted by packland on Sun, 15 Sep 2019 15:52:30 +0200

ZooKeeper Series: Logging

Each write operation in Zookeeper maintains a transaction log dedicated to writing znode operations. Only the data changes confirmed by the transaction log will take effect throughout the cluster. 1,TxnLog TxnLog is a write transaction log interface, which mainly includes the following interfaces: rollLog: Log scroll to start a new log ap ...

Posted by jackofalltrades on Mon, 09 Sep 2019 14:17:49 +0200

ZooKeeper Series: Leader Call Chain

Leader receives client requests by starting Leader Zoo Keeper Server. First, we look at the definition of its processing chain. From the source code, we can see that the sequence of the processing chain of LeaderZoo Keeper Server is as follows:   LeaderRequestProcessor: Leader call chain begins PrepRequest Processor: Write action prepar ...

Posted by praxedis on Mon, 09 Sep 2019 08:13:55 +0200