_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › Sqoop
|
|
[edit]
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\ 譴覦蠖 [edit]
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' . 願 覓語 襾轟 蠍一旧 .
鏤
|
襭襭螳 襯 燕. 蠏碁Μ螻 襾語 螳 讌覿 覦 襯 燕 蟆企. 蠏 伎朱 覯 襯 企蟆 蟆企. 企蟆 覲 蟆企. 企 蠏碁 譟伎螳 朱 襷企. (覯る) |