_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
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:52Anonymous