![[Pgday.Seoul 2018] Greenplum 碁 覿 り](https://cdn.slidesharecdn.com/ss_thumbnails/02-20181103pgdayseminarv1-181112041352-thumbnail.jpg?width=560&fit=bounds)
More Related Content
What's hot (20)
Viewers also liked (20)
Similar to Apache sqoop (20)
![[NDC17] Unreal.js - 覦ろ襴渚碁 所 觜襯 UE4 螳覦蠍](https://cdn.slidesharecdn.com/ss_thumbnails/wjkqukgsqgm2vger5dnt-signature-2cf736e9b897e2aaaa6315f9d31d6951ba19fae7560fe278cefb4644ac0753c6-poli-170428114140-thumbnail.jpg?width=560&fit=bounds)
More from HyeonSeok Choi (20)
Apache sqoop
- 2. 企語 豢豌: siliconweek, <http://www.siliconweek.es/noticias/apache-sqoop-se-convierte-en-proyecto-prioritario-para-big-data-21558> ♀骸 RDBMS 伎 一危磯ゼ ″蠍 Tool Import Export 13 10 7
- 4. Import Flow 1. JDBC襯 伎伎 誤 企 蟆 2. 貊 貉企 企 3. 襷給Μ ろ 襷 ろ 貎朱Μ襯 ろ螻 貉企 企るゼ 伎 語ろ伎る 讌 13 10 7
- 5. 貉企 企 public class widgets extends SqoopRecord implements DBWritable, Writable { ... public void readFields(ResultSet __dbResults) throws SQLException { // Importing this.__cur_result_set = __dbResults; this.id = JdbcWritableBridge.readInteger(1, __dbResults); this.widget_name = JdbcWritableBridge.readString(2, __dbResults); this.price = JdbcWritableBridge.readBigDecimal(3, __dbResults); this.design_date = JdbcWritableBridge.readDate(4, __dbResults); this.version = JdbcWritableBridge.readInteger(5, __dbResults); this.design_comment = JdbcWritableBridge.readString(6, __dbResults); } // Exporting public int write(PreparedStatement __dbStmt, int __off) throws SQLException { JdbcWritableBridge.writeInteger(id, 1 + __off, 4, __dbStmt); JdbcWritableBridge.writeString(widget_name, 2 + __off, 12, __dbStmt); JdbcWritableBridge.writeBigDecimal(price, 3 + __off, 3, __dbStmt); JdbcWritableBridge.writeDate(design_date, 4 + __off, 91, __dbStmt); JdbcWritableBridge.writeInteger(version, 5 + __off, 4, __dbStmt); JdbcWritableBridge.writeString(design_comment, 6 + __off, 12, __dbStmt); return 6; } ... } Sqoop 一危磯ゼ 讌/讌 貉企 企るゼ 燕 企襦覿 豢豢 貊襯 讌 13 10 7
- 6. 焔レ Map Task 覿 焔レ 貎朱Μ襯 れ 碁 覿一貅 詞 Sqoop 企 覃 一危磯ゼ 覿 蟆一 (DataDrivenDBInputFormat) -m 1 旧 覃 1螳 襷 ろ襷 ろ . Ex) 譯狩れ 豕/豕 螳 伎 0 ~ 99,999 螳 螳讌 ID 貉殊願, 5螳 襷牛ろ螳 ろ 蟆曙 螳螳 襷 ろ 螳 貎朱Μ襯 ろ SELECT * FROM widgets WHERE id >=0 AND id < 20000; SELECT * FROM widgets WHERE id >=20000 AND id < 40000; : 13 10 7
- 7. ETC. 危蠍 WHERE 豢螳 豌 企 朱襷 螳 語 手 一危 語, 一危一 手 る血 蠏狩 蟆 譴. 企ゼ 蠍郁譴 企 襦語るゼ ろ 襷 蟆 讌 覈 讌 覈襯 焔レ レ . 企 讌 覈 一危 覯伎れ 讌 伎 (ex: mysqldump ...) 13 10 7
- 9. Export Flow 1. JDBC襯 伎伎 企 蟆 2. 貊 貉企 企 3. 襷給Μ ろ INSET 覓語 襷れ伎 企 れ 貊襯 豢螳 13 10 7
- 10. ETC. 旧ろ語 碁 襦語れ 覲煙朱 誤 旧ろ碁 朱 企讌 . ( ろ 蟆郁骸 るジ ろ螳 蠍 谿語＾ ) 企ゼ 襾殊 企 旧ろ , ′ 譬襭 碁朱 覈 企襦 蟾 (staging-table 旧) 讌 覈 旧ろ 讌 覈襯 旧 焔レ レ . 企 讌 覈 一危 覯 伎れ 讌 伎 (ex: mysqlimport ...) 13 10 7
- 11. References Tom White (2013). 覯所企. (蠍, 蟾, 蟾). : 觜覩碁. (豢 2012) 13 10 7