简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

将记录从mysql导出到hdfs中_MySQL

WBOY
Release： 2016-06-01 13:32:18
Original
932 people have browsed it

bitsCN.com

将记录从mysql导出到hdfs中

 

01ConnectURL=jdbc:mysql://localhost:3306/user_action0203UserName=root0405PassWord=1234560607OutputPath=/hdfs/recommend/user_action/watch_record0809TableName= watch_record1011Columns=id,uid,mid,timestamp121314IfJobCreated =`sqoop job list | grep import_ watch_record`1516#检查import_ watch_record这个job是否已经创建 如果未创建则创建1718if [ $IfJobCreated = ’’ ] then1920sqoop  job  import_ watch_record /2122  --create  --import /2324  --connect  $ConnectURL/2526  --username  $UserName/2728  --password  $PassWord/2930  --target-dir  $OutputPath/3132  --m  1/3334  --table  $TableName/3536  –columns  $Columns/3738  --incremental  append/3940  --check-column  id/4142  --last-value  04344fi4546  4748sqoop  job --exec import_ watch_record
Copy after login

 

 

bitsCN.com
Related labels：
localhost mysql Record
source：php.cn
Previous article：Incorrect integer value: ''for column 'id' at row 1解决_MySQL Next article：mysqldump命令的使用_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity> This is my endpoint http://localhost:8080/country/all replies are ok for all countries and...
From 2024-04-06 17:11:03
0
1
421
Symfony Redis cannot connect to the host defined in the env file, which defaults to localhost We have a new Symfony setup with Redis as the caching mechanism. We want to connect to a s...
From 2024-04-06 10:53:02
0
1
375
JS: How to build an object based on parent properties I'm trying to create a JS object containing all URLs. I want to achieve this through the d...
From 2024-04-04 21:08:50
0
1
1411
next not working properly in middleware using Nodejs I am working with Nodejs and using expressjs and now I am working on middleware functional...
From 2024-04-04 17:33:56
0
1
340
Solve the error that mysql result contains multiple lines When I execute this query I get this error message "Error code: 1172. The result cont...
From 2024-04-04 16:42:59
0
1
311
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！