[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