Programming VIP

1, Definition of HIVE Hive is a data warehouse tool based on Hadoop, which can map structured data files into a data table, and can read, write and manage data files in a way similar to SQL. This Hive SQL is abbreviated as HQL. Hive's execution engines can be MR, Spark and Tez. essence The essence of Hive is to convert HQL into MapReduce task ...

Flight information management system Now, in order to improve the user experience, an airline hopes to build a flight information system, and users can operate the flight information according to their needs. The team leader assigned this task to programmer Zhao Dan. Zhao Dan found that the database needs to be operated through Java code, ...

The second bullet in the series of software implementation Interview articles, the interview summary of MySQL and Oracle joint query and aggregate function. If you look at mysql, can't you have some oracle? In front of it, many companies have done many written test questions, and now there are few written test questions. How much ink do you hav ...

preface This paper introduces the principle of master-slave synchronization and demonstrates the actual operation. Based on the above, this paper studies the separation of reading and writing based on mycat database and table MyCat Example architecture diagram: 192.168.43.110: database test01 and database test02 have student tables resp ...

Preface: Hudi series: Flinkcdc Hudi: introduction to MySQL data entering the lake in real time 1: preliminary test Flinkcdc Hudi: full introduction to MySQL data entering the lake in real time II: exceptions and solutions encountered during the integration of Hudi and Spark 1, Background In the production environment, mysql is generally eq ...

preface It can't be said that you have fully understood the logic and problems inside, but the methods you have mastered so far can make the view in browser output and phpmyadmin free of garbled code. Specific operation Create a table Worker after linking the database through php code <?php $mysql=mysqli_connect("localhost","root","12345 ...

query Query all data select * from emp; Query the specified data select column / function select column_name1, column_name2, ... from table_name; select mgr from emp; +------+ | mgr | +------+ | 7902 | | 7698 | | 7698 | | 7839 | | 7698 | | 7839 | | 7566 | | NULL | | 7566 | +------+ Query to remove duplicate records The default search ...

Integration of spring and MyBatista in spring learning (1) 1. Integration of spring and MyBatista 1.1 integration process and ideas 1.1.1 Mybatis As we all know, mybatis evolved from ibatis of Apache and is a persistence layer framework based on Java. Mybatis annotation 𞓜 xml file is used for configuration or original mapping. Mybatis refe ...

zabbix4.0 deployment zabbix server needs LAMP or LNMP environment, so there are many installation methods here. We choose a relatively simple installation method and install it directly with the source provided by the official. Deployment preparation [root@zabbix-server ~]# uname -a Linux zabbix-server 3.10.0-1062.18.1.el7.x86_64 #1 SMP Tue ...

1. Data types in MySQL typeType exampleInteger typeTINYINT, SMALLINT, MEDIUMINT, int (or INTEGER), BIGINTFloating point typeFLOAT,DOUBLEFixed point number typeDECIMALBit typeBITDate time typeYEAR,TIME,DATE,DATETIME,TIMESTAMPText string typeCHAR,VARCHAR,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXTEnumeration typeENUMCollection typeSETBinary string typeBIN ...