220617, data warehouse DWD,

alt+enter No response after pressing

Total quantity （ take ）, How to get it ,

Cover （ save ）,

  Never modify the original , Original copy ,

It's not just code , All the documents are like this

Important files are backed up by four or five layers , Multiple cloud disks , Hard disk

Set non strict mode

Local large query , Step by step ,

a+ Modify the original （left join）+b newly added （union）,

Partition , zipper , Faster query ,

Effective annotation rate

Dimension reduction The number of dimensions decreases abbreviation Dimension reduction

anhui

alt+ Mouse drag , Input multiple lines at the same time ,

alt+enter,exp, Take out the field comparison ,

  What are the fields of the screenshot reserved on

Create table fields

Core fields related to topic analysis

First query select, Then perform the insertion ,

Half day

The current step is to associate the table first and then filter the core fields ,

Then use the field select Extract the corresponding table created in advance ,

Then integrate and reuse hiveSQL Insert statements into the table we created in advance , Combined into a new table  

DWB The layer table is reduced , It's dimension reduction

Are the inserted field names consistent with the fields in the table ?

insert+select, Corresponding to , type ,

dwb Are layers all dimensionality reduction of the fact table

It depends on people , Sweet mouth , A small gift ,

Technical innocence Technology is not evil

The guilty are all product managers