Presto瀹炴垬 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
鐗堟潈褰掑嚭鐗堢ぞ鍜屽師浣滆€呮墍鏈夛紝閾炬帴宸插垹闄わ紝璇瘋喘涔版鐗?/b>
鐢ㄦ埛涓嬭澆璇存槑錛?/strong>
鐢?shù)瀛愮増浠呬緵棰勮锛屼笅铦插?4灝忔椂鍐呭姟蹇呭垹闄わ紝鏀寔姝ｇ増錛屽枩嬈㈢殑璇瘋喘涔版鐗堜功綾嶏細(xì)
http://product.dangdang.com/29220133.html
鐩稿叧鎴浘錛?br />
璧勬枡綆€浠嬶細(xì)
闅忕潃鍚勮鍚勪笟瀵瑰ぇ鏁版嵁瀹炴椂鏌ヨ鐨勯渶姹傛寔緇闀匡紝鏁版嵁鏌ヨ鍙?qiáng)鍒嗘瀽寮曟搸姝ｅ彉寰椾笉鍙垨缂恒€侾resto鏄敱Facebook寮€婧愮殑楂樻€ц兘鍒嗗竷寮廠QL鏌ヨ寮曟搸錛屽叾鐢ㄦ埛鍖呮嫭Netflix銆丄irbnb銆丩inkedIn銆乀witter銆乁ber絳夌煡鍚嶅叕鍙搞€傛湰涔︾敱P(pán)resto鐨勬牳蹇?jī)寮€鍙戜漢鍛樺弬涓庢挵鍐欙紝鏁欎綘緋葷粺鍦板涔?fàn)Presto鐨勭敤娉曘€備功涓唴瀹規(guī)兜鐩朠resto鐨勫畨瑁呫€佽璁＄悊蹇點(diǎn)€佹煡璇㈡搷浣溿€?瀹炶返銆佷笌涓昏浜戝鉤鍙扮殑緇撳悎絳夈€傛湰涔﹀垎涓轟笁澶ч儴鍒嗭細(xì)*閮ㄥ垎浠嬬粛Presto鐨勫熀紜€鐭ヨ瘑錛涚浜岄儴鍒嗘洿榪涗竴姝ワ紝浠嬬粛Presto鏋舵瀯銆侀泦緹ら儴緗層€佷笌鏁版嵁婧愮殑榪炴帴絳夛紱絎笁閮ㄥ垎璁茶В瀹夊叏閰嶇疆浠ュ強(qiáng)Presto鐨勫疄闄呯敤渚嬨€備綘鍙互閫氳繃鏈功瀛︿細(xì)閽堝涓嶅悓鐨勬暟鎹簮蹇€熸墽琛屼氦浜掑紡SQL鏁版嵁鍒嗘瀽錛屽茍鍒╃敤Presto綆＄悊鍜屼嬌鐢ㄦ搗閲忔暟鎹€?/span>
璧勬枡鐩綍錛?/strong>
璇戣€呭簭銆€xv
搴忋€€xvii
鍓嶈█銆€xix
絎?涓€閮ㄥ垎銆€Presto銆€鍏ラ棬
絎?1绔犮€€Presto銆€浠嬬粛銆€3
1.1銆€澶ф暟鎹甫鏉ョ殑闂銆€3
1.2銆€Presto鏉ユ晳鍦恒€€4
1.2.1銆€涓烘€ц兘鍜岃妯¤€岀敓銆€5
1.2.2銆€SQL-on-Anything銆€5
1.2.3銆€瀛樺偍涓庤綆楀垎紱匯€€6
1.3銆€Presto浣跨敤鍦烘櫙銆€6
1.3.1銆€鍗曚竴鐨凷QL鍒嗘瀽璁塊棶鐐廣€€7
1.3.2銆€鏁版嵁浠撳簱鍜屾暟鎹簮緋葷粺鐨勮闂偣銆€7
1.3.3銆€鎻愪緵瀵逛換浣曞唴瀹圭殑SQL璁塊棶銆€8
1.3.4銆€鑱旈偊鏌ヨ銆€9
1.3.5銆€铏氭嫙鏁版嵁浠撳簱鐨勮涔夊眰銆€9
1.3.6銆€鏁版嵁婀栨煡璇㈠紩鎿庛€€9
1.3.7銆€SQL杞崲鍜孍TL10
1.3.8銆€鏇村揩鐨勫搷搴斿甫鏉ユ洿濂界殑鏁版嵁瑙佽В銆€10
1.3.9銆€澶ф暟鎹€佹満鍣ㄥ涔?fàn)鍜屼汉宸ユ欨檭姐€€10
1.3.10銆€鍏朵粬浣跨敤鍦烘櫙銆€11
1.4銆€Presto銆€璧勬簮銆€11
1.4.1銆€瀹樻柟緗戠珯銆€11
1.4.2銆€鏂囨。銆€12
1.4.3銆€紺懼尯浜ゆ祦銆€12
1.4.4銆€婧愪唬鐮併€佽鍙瘉鍜岀増鏈€€12
1.4.5銆€璐＄尞銆€12
1.4.6銆€鏈功璧勬簮銆€13
1.4.7銆€楦㈠熬鑺辨暟鎹泦銆€13
1.4.8銆€鑸彮鏁版嵁闆嗐€€14
1.5銆€Presto綆€鍙層€€14
1.6銆€灝忕粨銆€15
絎?2绔犮€€瀹夎鍜岄厤緗甈resto銆€16
2.1銆€浣跨敤Docker瀹瑰櫒灝濊瘯Presto銆€16
2.2銆€浣跨敤褰掓。鏂囦歡瀹夎銆€17
2.2.1銆€JVM銆€17
2.2.2銆€Python銆€18
2.2.3銆€瀹夎銆€18
2.2.4銆€閰嶇疆銆€19
2.3銆€娣誨姞鏁版嵁婧愩€€20
2.4銆€榪愯Presto銆€21
2.5銆€灝忕粨銆€21
絎?绔犮€€浣跨敤Presto銆€22
3.1銆€Presto CLI銆€22
3.1.1銆€浣跨敤鍏ラ棬銆€22
3.1.2銆€鍒嗛〉銆€25
3.1.3銆€鍛戒護(hù)鍘嗗彶銆€25
3.1.4銆€棰濆璇婃柇銆€25
3.1.5銆€鎵ц鏌ヨ銆€25
3.1.6銆€杈撳嚭鏍煎紡銆€26
3.1.7銆€蹇界暐閿欒銆€26
3.2銆€Presto JDBC椹卞姩銆€27
3.2.1銆€涓嬭澆鍜屾敞鍐岄┍鍔ㄣ€€28
3.2.2銆€鍒涘緩鍒癙resto鐨勮繛鎺ャ€€29
3.3銆€Presto涓嶰DBC銆€31
3.4銆€瀹㈡埛绔簱銆€31
3.5銆€Presto Web UI銆€31
3.6銆€浣跨敤Presto鎵цSQL銆€32
3.6.1銆€姒傚康銆€33
3.6.2銆€鍏ラ棬妗堜緥銆€33
3.7銆€灝忕粨銆€36
絎簩閮ㄥ垎銆€娣卞叆鐞嗚ВPresto
絎?绔犮€€Presto鐨勬灦鏋勩€€39
4.1銆€闆嗙兢涓殑鍗忚皟鍣ㄥ拰宸ヤ綔鑺傜偣銆€39
4.2銆€鍗忚皟鍣ㄣ€€41
4.3銆€鑺傜偣鍙戠幇鏈嶅姟銆€41
4.4銆€宸ヤ綔鑺傜偣銆€42
4.5銆€鍩轟簬榪炴帴鍣ㄧ殑鏋舵瀯銆€42
4.6銆€catalog銆乻chema鍜岃〃銆€43
4.7銆€鏌ヨ鎵ц妯″瀷銆€44
4.8銆€鏌ヨ浼樺寲銆€47
4.8.1銆€瑙ｆ瀽鍜屽垎鏋愩€€48
4.8.2銆€鍒濆鏌ヨ璁″垝銆€49
4.9銆€浼樺寲瑙勫垯銆€50
4.9.1銆€璋撹瘝涓嬫帹銆€51
4.9.2銆€Cross Join銆€娑堥櫎銆€51
4.9.3銆€TopN銆€52
4.9.4銆€灞€閮ㄨ仛鍚堛€€52
4.10銆€瀹炵幇瑙勫垯銆€53
4.10.1銆€Lateral Join銆€鍘誨叧鑱斿寲銆€53
4.10.2銆€Semi-join錛圛N錛夊幓鍏寵仈鍖栥€€54
4.11銆€鍩轟簬浠ｄ環(huán)鐨勪紭鍖栧櫒銆€55
4.11.1銆€浠ｄ環(huán)鐨勬蹇點(diǎn)€€55
4.11.2銆€Join鐨勪唬浠楓€€57
4.11.3銆€琛ㄧ粺璁′俊鎭€€57
4.11.4銆€榪囨護(hù)緇熻淇℃伅銆€58
4.11.5銆€鍒嗗尯琛ㄧ殑緇熻淇℃伅銆€59
4.11.6銆€Join鏋氫婦銆€60
4.11.7銆€騫挎挱Join鍜屽垎甯冨紡Join銆€60
4.12銆€浣跨敤琛ㄧ粺璁′俊鎭€€62
4.12.1銆€Presto鐨凙NALYZE銆€鍛戒護(hù)銆€62
4.12.2銆€鍦ㄥ啓鍏ュ瓨鍌ㄦ椂鏀墮泦鏁版嵁銆€63
4.12.3銆€Hive鐨凙NALYZE銆€鍛戒護(hù)銆€63
4.12.4銆€鏄劇ず琛ㄧ粺璁′俊鎭€€63
4.13銆€灝忕粨銆€64
絎?绔犮€€鐢熶駭鐜閮ㄧ講銆€65
5.1銆€閰嶇疆緇嗚妭銆€65
5.2銆€鏈嶅姟绔厤緗€€65
5.3銆€鏃ュ織銆€66
5.4銆€鑺傜偣閰嶇疆銆€67
5.5銆€JVM閰嶇疆銆€68
5.6銆€鍚姩鍣ㄣ€€69
5.7銆€闆嗙兢瀹夎銆€70
5.8銆€浣跨敤RPM瀹夎銆€72
5.8.1銆€瀹夎鐩綍緇撴瀯銆€72
5.8.2銆€閰嶇疆銆€73
5.8.3銆€鍗歌澆Presto銆€73
5.9銆€鍦ㄤ簯涓婂畨瑁呫€€73
5.10銆€闆嗙兢瑙勬ā鐨勮€冮噺銆€74
5.11銆€灝忕粨銆€74
絎?绔犮€€榪炴帴鍣ㄣ€€75
6.1銆€閰嶇疆銆€76
6.2銆€RDBMS榪炴帴鍣ㄧず渚嬶細(xì)PostgreSQL銆€76
6.2.1銆€鏌ヨ涓嬫帹銆€78
6.2.2銆€騫惰鎬у拰騫跺彂鎬с€€79
6.2.3銆€鍏朵粬RDBMS榪炴帴鍣ㄣ€€80
6.2.4銆€瀹夊叏鎬с€€81
6.3銆€Presto TPC-H鍜孴PC-DS榪炴帴鍣ㄣ€€81
6.4銆€鐢ㄤ簬鍒嗗竷寮忓瓨鍌ㄦ暟鎹簮鐨凥ive銆€榪炴帴鍣ㄣ€€82
6.4.1銆€Apache Hadoop鍜孒ive銆€82
6.4.2銆€Hive榪炴帴鍣ㄣ€€83
6.4.3銆€Hive寮忚〃鏍煎紡銆€85
6.4.4銆€鍐呴儴琛ㄤ笌澶栭儴琛ㄣ€€85
6.4.5銆€鍒嗗尯鏁版嵁銆€87
6.4.6銆€鍔犺澆鏁版嵁銆€88
6.4.7銆€鏂囦歡鏍煎紡鍜屽帇緙┿€€90
6.4.8銆€MinIO紺轟緥銆€91
6.5銆€闈炲叧緋繪暟鎹簮銆€91
6.6銆€Presto JMX銆€榪炴帴鍣ㄣ€€92
6.7銆€榛戞礊榪炴帴鍣ㄣ€€94
6.8銆€鍐呭瓨榪炴帴鍣ㄣ€€94
6.9銆€鍏朵粬榪炴帴鍣ㄣ€€95
6.10銆€灝忕粨銆€95
絎?绔犮€€楂樼駭榪炴帴鍣ㄥ疄渚嬨€€96
7.1銆€鐢≒hoenix榪炴帴HBase銆€96
7.2銆€閿€煎瓨鍌ㄨ繛鎺ュ櫒紺轟緥錛欰ccumulo銆€97
7.2.1銆€浣跨敤Presto Accumulo榪炴帴鍣ㄣ€€100
7.2.2銆€Accumulo涓殑璋撹瘝涓嬫帹銆€102
7.3銆€Apache Cassandra銆€榪炴帴鍣ㄣ€€103
7.4銆€嫻佸紡緋葷粺榪炴帴鍣ㄧず渚嬶細(xì)Kafka銆€104
7.5銆€鏂囨。瀛樺偍榪炴帴鍣ㄧず渚嬶細(xì)Elasticsearch銆€106
7.5.1銆€姒傝堪銆€106
7.5.2銆€閰嶇疆鍜屼嬌鐢ㄦ柟娉曘€€106
7.5.3銆€鏌ヨ澶勭悊銆€107
7.5.4銆€鍏ㄦ枃鎼滅儲(chǔ)銆€107
7.5.5銆€鎬葷粨銆€108
7.6銆€Presto涓殑鑱旈偊鏌ヨ銆€108
7.7銆€ETL鍜岃仈鍚堟煡璇€€114
7.8銆€灝忕粨銆€114
絎?绔犮€€鍦≒resto涓嬌鐢⊿QL銆€115
8.1銆€Presto璇彞銆€116
8.2銆€Presto緋葷粺琛ㄣ€€118
8.3銆€catalog銆€120
8.4銆€schema銆€120
8.5銆€Information Schema銆€121
8.6銆€琛ㄣ€€122
8.6.1銆€琛ㄥ拰鍒楀睘鎬с€€124
8.6.2銆€澶嶅埗鐜版湁鐨勮〃銆€125
8.6.3銆€浠庢煡璇㈢粨鏋滀腑鏂板緩琛ㄣ€€126
8.6.4銆€淇敼琛ㄣ€€127
8.6.5銆€鍒犻櫎琛ㄣ€€127
8.6.6銆€榪炴帴鍣ㄥ琛ㄦ搷浣滅殑闄愬埗銆€127
8.7銆€瑙嗗浘銆€128
8.8銆€浼?xì)璇濅俊鎭拰閰嵕|€€128
8.9銆€鏁版嵁綾誨瀷銆€129
8.9.1銆€闆嗗悎鏁版嵁綾誨瀷銆€131
8.9.2銆€鏃舵€佹暟鎹被鍨嬨€€132
8.9.3銆€綾誨瀷杞崲銆€135
8.10銆€SELECT璇彞鍩虹銆€136
8.11銆€WHERE瀛愬彞銆€137
8.12銆€GROUP BY鍜孒AVING瀛愬彞銆€138
8.13銆€ORDER BY瀛愬彞鍜孡IMIT瀛愬彞銆€140
8.14銆€JOIN璇彞銆€140
8.15銆€UNION銆両NTERSECT鍜孍XCEPT瀛愬彞銆€141
8.16銆€鍒嗙粍鎿嶄綔銆€143
8.17銆€WITH瀛愬彞銆€144
8.18銆€瀛愭煡璇€€145
8.18.1銆€鏍囬噺瀛愭煡璇€€145
8.18.2銆€EXISTS瀛愭煡璇€€146
8.18.3銆€闆嗗悎姣旇緝瀛愭煡璇€€146
8.19銆€浠庤〃涓垹闄ゆ暟鎹€€147
8.20銆€灝忕粨銆€147
絎?绔犮€€楂樼駭SQL鐗規(guī)€с€€148
9.1銆€鍑芥暟鍜岃繍綆楃浠嬬粛銆€148
9.2銆€鏍囬噺鍑芥暟鍜岃繍綆楃銆€149
9.3銆€甯冨皵榪愮畻絎︺€€150
9.4銆€閫昏緫榪愮畻絎︺€€151
9.5銆€鐢˙ETWEEN璇彞閫夋嫨鑼冨洿銆€152
9.6銆€鐢↖S(NOT) NULL媯€(gè)嫻嬪€肩殑瀛樺湪銆€152
9.7銆€鏁板鍑芥暟鍜岃繍綆楃銆€152
9.8銆€涓夎鍑芥暟153
9.9銆€甯告暟鍜岄殢鏈哄嚱鏁般€€154
9.10銆€瀛楃涓插嚱鏁板拰榪愮畻絎︺€€154
9.11銆€瀛楃涓插拰鏄犲皠銆€155
9.12銆€Unicode銆€156
9.13銆€姝ｅ垯琛ㄨ揪寮忋€€158
9.14銆€瑙ｅ祵濂楀鏉傛暟鎹被鍨嬨€€160
9.15銆€JSON鍑芥暟銆€161
9.16銆€鏃ユ湡鍜屾椂闂村嚱鏁板強(qiáng)榪愮畻絎︺€€161
9.17銆€鐩存柟鍥俱€€164
9.18銆€鑱氬悎鍑芥暟銆€165
9.18.1銆€鏄犲皠鑱氬悎鍑芥暟銆€165
9.18.2銆€榪戜技鑱氬悎鍑芥暟銆€167
9.19銆€紿楀嚱鏁般€€168
9.20銆€lambda琛ㄨ揪寮忋€€169
9.21銆€鍦扮悊絀洪棿鍑芥暟銆€170
9.22銆€Prepared Statement銆€171
9.23銆€灝忕粨銆€173
絎笁閮ㄥ垎銆€Presto鐨勫疄闄呭簲鐢?br style="margin: 0px; padding: 0px;" />
絎?10绔犮€€瀹夊叏銆€177
10.1銆€璁よ瘉銆€178
10.2銆€鎺堟潈銆€181
10.2.1銆€緋葷粺璁塊棶鎺у埗銆€181
10.2.2銆€榪炴帴鍣ㄨ闂帶鍒躲€€184
10.3銆€鍔犲瘑銆€186
10.3.1銆€鍔犲瘑Presto瀹㈡埛绔笌鍗忚皟鍣ㄤ箣闂寸殑閫氫俊銆€188
10.3.2銆€鍒涘緩Java keystore鍜孞ava truststore銆€190
10.3.3銆€鍦≒resto闆嗙兢鍐呭姞瀵嗛€氫俊銆€192
10.4銆€CA涓庤嚜絳懼悕璇佷功銆€193
10.5銆€璇佷功璁よ瘉銆€194
10.6銆€Kerberos銆€197
10.6.1銆€鍓嶆彁鏉′歡銆€198
10.6.2銆€Kerberos瀹㈡埛绔璇併€€198
10.6.3銆€闆嗙兢鍐呴儴Kerberos銆€198
10.7銆€鏁版嵁婧愯闂拰瀹夊叏閰嶇疆銆€199
10.8銆€浣跨敤Hive榪炴帴鍣ㄨ繘琛孠erberos楠岃瘉銆€200
10.8.1銆€Hive Metastore Thrift鏈嶅姟璁よ瘉銆€201
10.8.2銆€HDFS璁よ瘉銆€201
10.9銆€闆嗙兢鍒嗙銆€202
10.10銆€灝忕粨銆€202
絎?11绔犮€€灝哖resto涓庡叾浠栧伐鍏烽泦鎴愩€€203
11.1銆€浣跨敤Apache Superset榪涜鏌ヨ銆佸彲瑙嗗寲鍜屾洿澶氭搷浣溿€€203
11.2銆€浣跨敤RubiX鎻愰珮鎬ц兘銆€204
11.3銆€浣跨敤Apache Airflow鐨勫伐浣滄祦銆€205
11.4銆€宓屽叆寮廝resto紺轟緥錛欰mazon Athena銆€205
11.5銆€Starburst浼佷笟鐗圥resto銆€208
11.6銆€鍏朵粬闆嗘垚妗堜緥銆€208
11.7銆€鑷畾涔夐泦鎴愩€€209
絎?12绔犮€€鐢熶駭鐜涓殑Presto銆€211
12.1銆€浣跨敤Presto Web UI鐩戞帶銆€211
12.1.1銆€闆嗙兢綰х殑緇嗚妭銆€212
12.1.2銆€鏌ヨ鍒楄〃銆€213
12.1.3銆€鏌ヨ緇嗚妭瑙嗗浘銆€215
12.2銆€Presto SQL鏌ヨ璋冧紭銆€221
12.3銆€鍐呭瓨綆＄悊銆€223
12.4銆€浠誨姟騫跺彂鎬с€€226
12.5銆€宸ヤ綔鑺傜偣璋冨害銆€227
12.5.1銆€鏍規(guī)嵁浠誨姟鎴栬妭鐐硅皟搴﹀垏鐗囥€€227
12.5.2銆€鏈湴璋冨害絳栫暐銆€227
12.6銆€緗戠粶鏁版嵁浜ゆ崲銆€228
12.6.1銆€騫跺彂鎬с€€228
12.6.2銆€緙撳啿鍖哄ぇ灝忋€€228
12.7銆€JVM璋冧紭銆€228
12.8銆€璧勬簮緇勩€€230
12.8.1銆€璧勬簮緇勭殑瀹氫箟銆€231
12.8.2銆€璋冨害絳栫暐銆€232
12.8.3銆€閫夋嫨鍣ㄨ鍒欏畾涔夈€€233
12.9銆€灝忕粨銆€233
絎?13绔犮€€鐪熷疄涓栫晫鐨勬渚嬨€€234
13.1銆€閮ㄧ講鍜岃繍琛屾椂騫沖彴銆€234
13.2銆€闆嗙兢瑙勬ā銆€235
13.3銆€Hadoop/Hive榪佺Щ鐨勪嬌鐢ㄥ満鏅€€237
13.4銆€鍏朵粬鏁版嵁婧愩€€237
13.5銆€鐢ㄦ埛鍜屾祦閲忋€€237
13.6銆€灝忕粨銆€238
絎?14绔犮€€鎬葷粨銆€239
鍏充簬浣滆€呫€€240
鍏充簬灝侀潰銆€240
|
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
