_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › Sqoop

Contents

1 import (sql server -> hive)
2 export (hdfs -> sql server)
3 谿瑚襭



1 import (sql server -> hive) #

sqoop import --connect 'jdbc:sqlserver://192.168.201.36;databaseName=sqlbook;username=襦蠏語;password=れ;currentSchema=dbo' \
 --table Actors -m 1 --hive-import
\ 譴覦蠖

2 export (hdfs -> sql server) #

sqoop export --connect 'jdbc:sqlserver://192.168.201.36;databaseName=sqlbook;username=襦蠏語;password=れ;currentSchema=dbo' \
 --export-dir  /user/hive/warehouse/actors --table actors --input-fields-terminated-by '\001' --direct
* \ 譴覦蠖
* 蠍磯蓋朱 蟲覿 '\001' . 願 覓語 襾轟 蠍一旧 .

蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

螳 谿語襷螻 企る. 覃 語企. 蠏殊蟇煙 朱 覈語 讌. 一誤 襴襦 碁襯 覿. . 覩語覃 蠍 企.