[hard Hive] Hive Foundation: Hive syntax DDL data definition (create database / query database / modify database / delete database / create table / modify table / delete table)
12 articles 1 subscription
Welcome to the blog home page: Wechat search: Import_ Bigdata, hard core original author in big data field_ import_bigdata_ CSDN blog Welcome to like, collect, leave messages, and exchange messages!This article was originally written by [Wang Zhiwu] and started on CSDN blog!This article is the first CSDN forum. It ...
Added by mark103 on Sat, 11 Sep 2021 07:38:33 +0300
JAVA - Oracle Database
introduction
1. Start the server
My computer – right click – service – select X2 – start
2. Users existing after installation
SYSTEM
SYS
SCOTT
3.Oracle Database
4. Listener
1. A background process running independently on the server 2. When the server is not started, the listener can also run independently 3. ...
Added by thomashw on Sat, 11 Sep 2021 05:26:07 +0300
[hard Hive] Hive Foundation (18): Hive syntax DDL partition table and bucket table
Welcome to the blog home page: Wechat search: Import_ Bigdata, hard core original author in big data field_ import_bigdata_ CSDN blog Welcome to like, collect, leave messages, and exchange messages!This article was originally written by [Wang Zhiwu] and started on CSDN blog!This article is the first CSDN forum. It is strictly prohibited to repr ...
Added by jsschmitt on Sat, 11 Sep 2021 04:27:01 +0300
hadoop pseudo-distributed installation process
1. Create a virtual machine memory settings first It's best to be larger or not to have fun My settings are 100g and then the memory threads are configured on their own computer.
2. Then configure the file to install jdk What is preceded by a written shell script that you can use directly or configure yourself
3. Download the hadoop installat ...
Added by chris_2001 on Thu, 09 Sep 2021 19:41:34 +0300
What exactly is the ScodendaryNameNode for HDFS
0-Preface
What does HDFS Secondary NameNode do?
This is a classic basic interview question, and the interviewer has asked the interviewer many times (and of course many times). From the impression, about half of the interviewees can't answer correctly, and even give the answer "is not NameNode's hobby". In order to save spa ...
Added by samusk on Thu, 09 Sep 2021 19:31:11 +0300
[hard Hive] the four sorts in Hive are explained in detail, and the usage will no longer be confused
Welcome to the blog home page: https://blog.csdn.net/u013411339 Welcome to like, collect, leave messages, and exchange messages!This article was originally written by [Wang Zhiwu] and started on CSDN blog!This article is the first CSDN forum. It is strictly prohibited to reprint without the permission of the official and myself!
This artic ...
Added by mshen on Tue, 07 Sep 2021 00:19:08 +0300
MySQL Database - Advanced [Advanced] SQL Statements - SQL Advanced Statements, Functions
1. SQL Advanced Statements
1, SELECT
Displays all data for one or more columns in a table
Syntax: SELECT "field" FROM "table name"; Example:
select * from infol;
select name from infol;
2,DISTINCT
Do not show duplicate content
Syntax: SELECT DISTINCT "field" FROM "table name"; Example:
s ...
Added by markster on Mon, 06 Sep 2021 19:23:45 +0300
MySQL database addition, deletion, modification, cloning, foreign keys and other operations
catalogue
1. SQL field data type
2. View database information statement
3. SQL statement
Create and delete database data tablesAdd, delete and query records to the tableModify the table name, add, modify, delete fields, and add unique constraintsView, delete and add indexes in tablesExtension function, field value self increment, etc
4. Da ...
Added by Pyro4816 on Mon, 06 Sep 2021 02:22:08 +0300
Flink's best practice is to stream TiDB data into Flink through TiCDC
Background introduction
This article will introduce the case of how to import the data in TiDB into Kafka through TiCDC and then consumed by Flink.
In order to quickly verify the functionality of the whole process, all components are deployed in a single machine. If you need to deploy in a production environment, it is recommended to replace ...
Added by disconne on Sat, 04 Sep 2021 21:44:21 +0300
Using terminal operation database MySQL
Using terminal to operate MySQL
MySQL installation tutorial reference rookie tutorial: https://www.runoob.com/mysql/mysql-install.html Content reference website: https://github.com/hjzCy/sql_node/blob/master/mysql/MySQL%E5%AD%A6%E4%B9%A0%E7%AC%94%E8%AE%B0.md
1, Basic operation
cmd entry method under win: mysql -uroot -p
See what da ...
Added by nediaz on Sat, 04 Sep 2021 03:22:06 +0300