Sqoop
From Chaehyun
(Difference between revisions)
(→auto increment primary key 적용) |
|||
| Line 4: | Line 4: | ||
** INSERT INTO table2 (name, job) SELECT * FROM table1; | ** INSERT INTO table2 (name, job) SELECT * FROM table1; | ||
* http://mail-archives.apache.org/mod_mbox/sqoop-user/201204.mbox/%3CCAOyWd-Keo8Ei9WQPN9o8KPZ3Xy5WnVkLHSNHU_HqZeBAKgzXeA@mail.gmail.com%3E | * http://mail-archives.apache.org/mod_mbox/sqoop-user/201204.mbox/%3CCAOyWd-Keo8Ei9WQPN9o8KPZ3Xy5WnVkLHSNHU_HqZeBAKgzXeA@mail.gmail.com%3E | ||
| + | |||
| + | = timezone 설정 = | ||
| + | * -D mapred.child.java.opts="-Duser.timezone=GMT -Xmx1024m" \ | ||
Latest revision as of 02:23, 18 March 2013
auto increment primary key 적용
- 한 번에는 안됨
- 일단 staging table에 만들고, 업데이트 하는 방법
- INSERT INTO table2 (name, job) SELECT * FROM table1;
- http://mail-archives.apache.org/mod_mbox/sqoop-user/201204.mbox/%3CCAOyWd-Keo8Ei9WQPN9o8KPZ3Xy5WnVkLHSNHU_HqZeBAKgzXeA@mail.gmail.com%3E
timezone 설정
- -D mapred.child.java.opts="-Duser.timezone=GMT -Xmx1024m" \