API tools faq
paste
kriteshpokharel

SQOOP experiments

kriteshpokharel
Nov 15th, 2021
22
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 36.21 KB | None | 0 0
raw download clone embed print report
  1. [cloudera@localhost ~]$ sudo service mysqld start
  2. Starting mysqld: [ OK ]
  3. [cloudera@localhost ~]$ mysql -u root
  4. Welcome to the MySQL monitor. Commands end with ; or \g.
  5. Your MySQL connection id is 2
  6. Server version: 5.1.73 Source distribution
  7.  
  8. Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
  9.  
  10. Oracle is a registered trademark of Oracle Corporation and/or its
  11. affiliates. Other names may be trademarks of their respective
  12. owners.
  13.  
  14. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  15.  
  16. EXPERIMENT 1:
  17.  
  18. mysql> create database sampledata;
  19. Query OK, 1 row affected (0.00 sec)
  20.  
  21. mysql> show databases;
  22. +--------------------+
  23. | Database |
  24. +--------------------+
  25. | information_schema |
  26. | db1 |
  27. | mysql |
  28. | sampledata |
  29. | sampledb |
  30. | test |
  31. +--------------------+
  32. 6 rows in set (0.07 sec)
  33.  
  34. mysql> use sampledata;
  35. Database changed
  36. mysql> create table mentor(mno int);
  37. Query OK, 0 rows affected (0.05 sec)
  38.  
  39. mysql> create table mentee(id int, name char);
  40. Query OK, 0 rows affected (0.00 sec)
  41.  
  42. mysql> insert into mentor values(101),(102),(103),(104),(105);
  43. Query OK, 5 rows affected (0.00 sec)
  44. Records: 5 Duplicates: 0 Warnings: 0
  45.  
  46. mysql> insert into mentee values(10,'a'),(20,'b'),(30,'c'),(40,'d'),(50,'e');
  47. Query OK, 5 rows affected (0.00 sec)
  48. Records: 5 Duplicates: 0 Warnings: 0
  49.  
  50. mysql> exit
  51. Bye
  52.  
  53. EXPERIMENT 2:
  54.  
  55. [cloudera@localhost ~]$ sqoop list-databases --connect "jdbc:mysql://localhost"
  56. --username root
  57.  
  58. 21/10/19 06:06:43 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  59. information_schema
  60. db1
  61. mysql
  62. sampledata
  63. sampledb
  64. test
  65. [cloudera@localhost ~]$ sqoop list-tables --connect "jdbc:mysql://localhost/sampledata"
  66. --username root
  67.  
  68. 21/10/19 06:07:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  69. mentee
  70. mentor
  71. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  72. --username root --query "select *from mentee"
  73.  
  74. 21/10/19 06:08:48 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  75. -------------------
  76. | id | name |
  77. -------------------
  78. | 10 | a |
  79. | 20 | b |
  80. | 30 | c |
  81. | 40 | d |
  82. | 50 | e |
  83. -------------------
  84. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  85. --username root --query "select count(*) from mentor"
  86.  
  87. 21/10/19 06:09:31 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  88. ------------------------
  89. | count(*) |
  90. ------------------------
  91. | 5 |
  92. ------------------------
  93. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  94. --username root --query "select * from mentor where mno>103"
  95.  
  96. 21/10/19 06:11:30 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  97. ---------------
  98. | mno |
  99. ---------------
  100. | 104 |
  101. | 105 |
  102. ---------------
  103. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  104. --username root --query "insert into mentee values(6,'f')"
  105.  
  106. 21/10/19 06:15:14 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  107. 21/10/19 06:15:15 INFO tool.EvalSqlTool: 1 row(s) updated.
  108. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata" --username root --query "select * from mentee"
  109. 21/10/19 06:15:34 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  110. -------------------
  111. | id | name |
  112. -------------------
  113. | 10 | a |
  114. | 20 | b |
  115. | 30 | c |
  116. | 40 | d |
  117. | 50 | e |
  118. | 6 | f |
  119. -------------------
  120.  
  121. EXPERIMENT 3:
  122.  
  123. [cloudera@localhost ~]$ sqoop list-databases --connect "jdbc:mysql://localhost"
  124. --username root
  125.  
  126. [cloudera@localhost ~]$ sqoop list-tables --connect "jdbc:mysql://localhost/sampledata"
  127. --username root
  128.  
  129. 21/10/19 06:33:20 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  130. mentee
  131. mentor
  132.  
  133. [cloudera@localhost ~]$ hadoop fs -rm -R /user/cloudera/mentor
  134. Moved: 'hdfs://localhost.localdomain:8020/user/cloudera/mentor' to trash at: hdfs://localhost.localdomain:8020/user/cloudera/.Trash/Current
  135.  
  136. [cloudera@localhost ~]$ hadoop fs -rm -R /user/cloudera/mentee
  137. Moved: 'hdfs://localhost.localdomain:8020/user/cloudera/mentee' to trash at: hdfs://localhost.localdomain:8020/user/cloudera/.Trash/Current
  138.  
  139. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera/mentor
  140. ls: `/user/cloudera/mentor': No such file or directory
  141.  
  142. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera/mentee
  143. ls: `/user/cloudera/mentee': No such file or directory
  144.  
  145. [cloudera@localhost ~]$ sqoop import --connect "jdbc:mysql://localhost/sampledata"
  146. --username root --table mentor -m 1
  147.  
  148. 21/10/19 06:38:27 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  149. 21/10/19 06:38:27 INFO tool.CodeGenTool: Beginning code generation
  150. 21/10/19 06:38:28 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  151. 21/10/19 06:38:28 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  152. 21/10/19 06:38:28 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
  153. 21/10/19 06:38:28 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop-0.20-mapreduce/hadoop-core.jar
  154. Note: /tmp/sqoop-cloudera/compile/1fd8f0aa24117cb20be9f086034af550/mentor.java uses or overrides a deprecated API.
  155. Note: Recompile with -Xlint:deprecation for details.
  156. 21/10/19 06:38:34 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-cloudera/compile/1fd8f0aa24117cb20be9f086034af550/mentor.jar
  157. 21/10/19 06:38:34 WARN manager.MySQLManager: It looks like you are importing from mysql.
  158. 21/10/19 06:38:34 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  159. 21/10/19 06:38:34 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  160. 21/10/19 06:38:34 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  161. 21/10/19 06:38:34 INFO mapreduce.ImportJobBase: Beginning import of mentor
  162. 21/10/19 06:38:37 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
  163. 21/10/19 06:38:40 INFO mapred.JobClient: Running job: job_202110190550_0004
  164. 21/10/19 06:38:41 INFO mapred.JobClient: map 0% reduce 0%
  165. 21/10/19 06:39:00 INFO mapred.JobClient: map 100% reduce 0%
  166. 21/10/19 06:39:05 INFO mapred.JobClient: Job complete: job_202110190550_0004
  167. 21/10/19 06:39:05 INFO mapred.JobClient: Counters: 23
  168. 21/10/19 06:39:05 INFO mapred.JobClient: File System Counters
  169. 21/10/19 06:39:05 INFO mapred.JobClient: FILE: Number of bytes read=0
  170. 21/10/19 06:39:05 INFO mapred.JobClient: FILE: Number of bytes written=175163
  171. 21/10/19 06:39:05 INFO mapred.JobClient: FILE: Number of read operations=0
  172. 21/10/19 06:39:05 INFO mapred.JobClient: FILE: Number of large read operations=0
  173. 21/10/19 06:39:05 INFO mapred.JobClient: FILE: Number of write operations=0
  174. 21/10/19 06:39:05 INFO mapred.JobClient: HDFS: Number of bytes read=87
  175. 21/10/19 06:39:05 INFO mapred.JobClient: HDFS: Number of bytes written=20
  176. 21/10/19 06:39:05 INFO mapred.JobClient: HDFS: Number of read operations=1
  177. 21/10/19 06:39:05 INFO mapred.JobClient: HDFS: Number of large read operations=0
  178. 21/10/19 06:39:05 INFO mapred.JobClient: HDFS: Number of write operations=1
  179. 21/10/19 06:39:05 INFO mapred.JobClient: Job Counters
  180. 21/10/19 06:39:05 INFO mapred.JobClient: Launched map tasks=1
  181. 21/10/19 06:39:05 INFO mapred.JobClient: Total time spent by all maps in occupied slots (ms)=22059
  182. 21/10/19 06:39:05 INFO mapred.JobClient: Total time spent by all reduces in occupied slots (ms)=0
  183. 21/10/19 06:39:05 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  184. 21/10/19 06:39:05 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  185. 21/10/19 06:39:05 INFO mapred.JobClient: Map-Reduce Framework
  186. 21/10/19 06:39:05 INFO mapred.JobClient: Map input records=5
  187. 21/10/19 06:39:05 INFO mapred.JobClient: Map output records=5
  188. 21/10/19 06:39:05 INFO mapred.JobClient: Input split bytes=87
  189. 21/10/19 06:39:05 INFO mapred.JobClient: Spilled Records=0
  190. 21/10/19 06:39:05 INFO mapred.JobClient: CPU time spent (ms)=250
  191. 21/10/19 06:39:05 INFO mapred.JobClient: Physical memory (bytes) snapshot=98820096
  192. 21/10/19 06:39:05 INFO mapred.JobClient: Virtual memory (bytes) snapshot=656605184
  193. 21/10/19 06:39:05 INFO mapred.JobClient: Total committed heap usage (bytes)=60751872
  194. 21/10/19 06:39:05 INFO mapreduce.ImportJobBase: Transferred 20 bytes in 30.3395 seconds (0.6592 bytes/sec)
  195. 21/10/19 06:39:05 INFO mapreduce.ImportJobBase: Retrieved 5 records.
  196.  
  197. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera
  198. Found 9 items
  199. drwx------ - cloudera cloudera 0 2019-12-17 22:29 /user/cloudera/.Trash
  200. drwx------ - cloudera cloudera 0 2021-10-19 06:39 /user/cloudera/.staging
  201. drwxr-xr-x - cloudera cloudera 0 2021-10-15 01:39 /user/cloudera/_sqoop
  202. drwxr-xr-x - cloudera cloudera 0 2021-10-15 01:19 /user/cloudera/hp2
  203. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:39 /user/cloudera/mentor
  204. drwxr-xr-x - cloudera cloudera 0 2021-10-12 01:57 /user/cloudera/stu
  205. -rw-r--r-- 3 cloudera cloudera 12 2021-10-12 02:11 /user/cloudera/stu1
  206. drwxr-xr-x - cloudera cloudera 0 2021-10-12 01:58 /user/cloudera/tea
  207. -rw-r--r-- 3 cloudera cloudera 12 2021-10-15 01:43 /user/cloudera/test1
  208.  
  209. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera/mentor
  210. Found 3 items
  211. -rw-r--r-- 3 cloudera cloudera 0 2021-10-19 06:39 /user/cloudera/mentor/_SUCCESS
  212. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:38 /user/cloudera/mentor/_logs
  213. -rw-r--r-- 3 cloudera cloudera 20 2021-10-19 06:38 /user/cloudera/mentor/part-m-00000
  214.  
  215. [cloudera@localhost ~]$ hadoop fs -cat /user/cloudera/mentor/part*
  216. 101
  217. 102
  218. 103
  219. 104
  220. 105
  221.  
  222. [cloudera@localhost ~]$ sqoop import --connect "jdbc:mysql://localhost/sampledata"
  223. --username root --table mentor --target-dir /user/cloudera/hat1 -m 1
  224.  
  225. 21/10/19 06:46:54 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  226. 21/10/19 06:46:54 INFO tool.CodeGenTool: Beginning code generation
  227. 21/10/19 06:46:55 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  228. 21/10/19 06:46:55 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  229. 21/10/19 06:46:55 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
  230. 21/10/19 06:46:55 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop-0.20-mapreduce/hadoop-core.jar
  231. Note: /tmp/sqoop-cloudera/compile/1e263d0a41690e9153daec3aba95b7ef/mentor.java uses or overrides a deprecated API.
  232. Note: Recompile with -Xlint:deprecation for details.
  233. 21/10/19 06:47:00 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-cloudera/compile/1e263d0a41690e9153daec3aba95b7ef/mentor.jar
  234. 21/10/19 06:47:00 WARN manager.MySQLManager: It looks like you are importing from mysql.
  235. 21/10/19 06:47:00 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  236. 21/10/19 06:47:00 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  237. 21/10/19 06:47:00 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  238. 21/10/19 06:47:00 INFO mapreduce.ImportJobBase: Beginning import of mentor
  239. 21/10/19 06:47:04 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
  240. 21/10/19 06:47:07 INFO mapred.JobClient: Running job: job_202110190550_0006
  241. 21/10/19 06:47:08 INFO mapred.JobClient: map 0% reduce 0%
  242. 21/10/19 06:47:27 INFO mapred.JobClient: map 100% reduce 0%
  243. 21/10/19 06:47:33 INFO mapred.JobClient: Job complete: job_202110190550_0006
  244. 21/10/19 06:47:33 INFO mapred.JobClient: Counters: 23
  245. 21/10/19 06:47:33 INFO mapred.JobClient: File System Counters
  246. 21/10/19 06:47:33 INFO mapred.JobClient: FILE: Number of bytes read=0
  247. 21/10/19 06:47:33 INFO mapred.JobClient: FILE: Number of bytes written=175172
  248. 21/10/19 06:47:33 INFO mapred.JobClient: FILE: Number of read operations=0
  249. 21/10/19 06:47:33 INFO mapred.JobClient: FILE: Number of large read operations=0
  250. 21/10/19 06:47:33 INFO mapred.JobClient: FILE: Number of write operations=0
  251. 21/10/19 06:47:33 INFO mapred.JobClient: HDFS: Number of bytes read=87
  252. 21/10/19 06:47:33 INFO mapred.JobClient: HDFS: Number of bytes written=20
  253. 21/10/19 06:47:33 INFO mapred.JobClient: HDFS: Number of read operations=1
  254. 21/10/19 06:47:33 INFO mapred.JobClient: HDFS: Number of large read operations=0
  255. 21/10/19 06:47:33 INFO mapred.JobClient: HDFS: Number of write operations=1
  256. 21/10/19 06:47:33 INFO mapred.JobClient: Job Counters
  257. 21/10/19 06:47:33 INFO mapred.JobClient: Launched map tasks=1
  258. 21/10/19 06:47:33 INFO mapred.JobClient: Total time spent by all maps in occupied slots (ms)=21067
  259. 21/10/19 06:47:33 INFO mapred.JobClient: Total time spent by all reduces in occupied slots (ms)=0
  260. 21/10/19 06:47:33 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  261. 21/10/19 06:47:33 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  262. 21/10/19 06:47:33 INFO mapred.JobClient: Map-Reduce Framework
  263. 21/10/19 06:47:33 INFO mapred.JobClient: Map input records=5
  264. 21/10/19 06:47:33 INFO mapred.JobClient: Map output records=5
  265. 21/10/19 06:47:33 INFO mapred.JobClient: Input split bytes=87
  266. 21/10/19 06:47:33 INFO mapred.JobClient: Spilled Records=0
  267. 21/10/19 06:47:33 INFO mapred.JobClient: CPU time spent (ms)=240
  268. 21/10/19 06:47:33 INFO mapred.JobClient: Physical memory (bytes) snapshot=94601216
  269. 21/10/19 06:47:33 INFO mapred.JobClient: Virtual memory (bytes) snapshot=656605184
  270. 21/10/19 06:47:33 INFO mapred.JobClient: Total committed heap usage (bytes)=60751872
  271. 21/10/19 06:47:33 INFO mapreduce.ImportJobBase: Transferred 20 bytes in 31.093 seconds (0.6432 bytes/sec)
  272. 21/10/19 06:47:33 INFO mapreduce.ImportJobBase: Retrieved 5 records.
  273.  
  274. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera/hat1
  275. Found 3 items
  276. -rw-r--r-- 3 cloudera cloudera 0 2021-10-19 06:47 /user/cloudera/hat1/_SUCCESS
  277. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:47 /user/cloudera/hat1/_logs
  278. -rw-r--r-- 3 cloudera cloudera 20 2021-10-19 06:47 /user/cloudera/hat1/part-m-00000
  279.  
  280. [cloudera@localhost ~]$ hadoop fs -cat /user/cloudera/hat1/part*
  281. 101
  282. 102
  283. 103
  284. 104
  285. 105
  286.  
  287. [cloudera@localhost ~]$ sqoop import --connect "jdbc:mysql://localhost/sampledata"
  288. --username root --table mentor --where "mno>'102'"
  289. --target-dir /user/cloudera/hat1/lab1 -m 1
  290.  
  291. 21/10/19 06:52:31 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  292. 21/10/19 06:52:31 INFO tool.CodeGenTool: Beginning code generation
  293. 21/10/19 06:52:32 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  294. 21/10/19 06:52:32 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  295. 21/10/19 06:52:32 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
  296. 21/10/19 06:52:32 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop-0.20-mapreduce/hadoop-core.jar
  297. Note: /tmp/sqoop-cloudera/compile/bbb5f073950ee93a796e9da3d27af988/mentor.java uses or overrides a deprecated API.
  298. Note: Recompile with -Xlint:deprecation for details.
  299. 21/10/19 06:52:37 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-cloudera/compile/bbb5f073950ee93a796e9da3d27af988/mentor.jar
  300. 21/10/19 06:52:37 WARN manager.MySQLManager: It looks like you are importing from mysql.
  301. 21/10/19 06:52:37 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  302. 21/10/19 06:52:37 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  303. 21/10/19 06:52:37 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  304. 21/10/19 06:52:37 INFO mapreduce.ImportJobBase: Beginning import of mentor
  305. 21/10/19 06:52:40 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
  306. 21/10/19 06:52:43 INFO mapred.JobClient: Running job: job_202110190550_0007
  307. 21/10/19 06:52:44 INFO mapred.JobClient: map 0% reduce 0%
  308. 21/10/19 06:53:03 INFO mapred.JobClient: map 100% reduce 0%
  309. 21/10/19 06:53:08 INFO mapred.JobClient: Job complete: job_202110190550_0007
  310. 21/10/19 06:53:08 INFO mapred.JobClient: Counters: 23
  311. 21/10/19 06:53:08 INFO mapred.JobClient: File System Counters
  312. 21/10/19 06:53:08 INFO mapred.JobClient: FILE: Number of bytes read=0
  313. 21/10/19 06:53:08 INFO mapred.JobClient: FILE: Number of bytes written=175593
  314. 21/10/19 06:53:08 INFO mapred.JobClient: FILE: Number of read operations=0
  315. 21/10/19 06:53:08 INFO mapred.JobClient: FILE: Number of large read operations=0
  316. 21/10/19 06:53:08 INFO mapred.JobClient: FILE: Number of write operations=0
  317. 21/10/19 06:53:08 INFO mapred.JobClient: HDFS: Number of bytes read=87
  318. 21/10/19 06:53:08 INFO mapred.JobClient: HDFS: Number of bytes written=12
  319. 21/10/19 06:53:08 INFO mapred.JobClient: HDFS: Number of read operations=1
  320. 21/10/19 06:53:08 INFO mapred.JobClient: HDFS: Number of large read operations=0
  321. 21/10/19 06:53:08 INFO mapred.JobClient: HDFS: Number of write operations=1
  322. 21/10/19 06:53:08 INFO mapred.JobClient: Job Counters
  323. 21/10/19 06:53:08 INFO mapred.JobClient: Launched map tasks=1
  324. 21/10/19 06:53:08 INFO mapred.JobClient: Total time spent by all maps in occupied slots (ms)=20855
  325. 21/10/19 06:53:08 INFO mapred.JobClient: Total time spent by all reduces in occupied slots (ms)=0
  326. 21/10/19 06:53:08 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  327. 21/10/19 06:53:08 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  328. 21/10/19 06:53:08 INFO mapred.JobClient: Map-Reduce Framework
  329. 21/10/19 06:53:08 INFO mapred.JobClient: Map input records=3
  330. 21/10/19 06:53:08 INFO mapred.JobClient: Map output records=3
  331. 21/10/19 06:53:08 INFO mapred.JobClient: Input split bytes=87
  332. 21/10/19 06:53:08 INFO mapred.JobClient: Spilled Records=0
  333. 21/10/19 06:53:08 INFO mapred.JobClient: CPU time spent (ms)=260
  334. 21/10/19 06:53:08 INFO mapred.JobClient: Physical memory (bytes) snapshot=100413440
  335. 21/10/19 06:53:08 INFO mapred.JobClient: Virtual memory (bytes) snapshot=656605184
  336. 21/10/19 06:53:08 INFO mapred.JobClient: Total committed heap usage (bytes)=60751872
  337. 21/10/19 06:53:08 INFO mapreduce.ImportJobBase: Transferred 12 bytes in 29.8409 seconds (0.4021 bytes/sec)
  338. 21/10/19 06:53:08 INFO mapreduce.ImportJobBase: Retrieved 3 records.
  339.  
  340. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera
  341. Found 11 items
  342. drwx------ - cloudera cloudera 0 2019-12-17 22:29 /user/cloudera/.Trash
  343. drwx------ - cloudera cloudera 0 2021-10-19 06:53 /user/cloudera/.staging
  344. drwxr-xr-x - cloudera cloudera 0 2021-10-15 01:39 /user/cloudera/_sqoop
  345. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:44 /user/cloudera/hat
  346. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:52 /user/cloudera/hat1
  347. drwxr-xr-x - cloudera cloudera 0 2021-10-15 01:19 /user/cloudera/hp2
  348. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:39 /user/cloudera/mentor
  349. drwxr-xr-x - cloudera cloudera 0 2021-10-12 01:57 /user/cloudera/stu
  350. -rw-r--r-- 3 cloudera cloudera 12 2021-10-12 02:11 /user/cloudera/stu1
  351. drwxr-xr-x - cloudera cloudera 0 2021-10-12 01:58 /user/cloudera/tea
  352. -rw-r--r-- 3 cloudera cloudera 12 2021-10-15 01:43 /user/cloudera/test1
  353.  
  354. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera/hat1
  355. Found 4 items
  356. -rw-r--r-- 3 cloudera cloudera 0 2021-10-19 06:47 /user/cloudera/hat1/_SUCCESS
  357. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:47 /user/cloudera/hat1/_logs
  358. drwxr-xr-x - cloudera cloudera 0 2021-10-19 06:53 /user/cloudera/hat1/lab1
  359. -rw-r--r-- 3 cloudera cloudera 20 2021-10-19 06:47 /user/cloudera/hat1/part-m-00000
  360.  
  361. [cloudera@localhost ~]$ hadoop fs -cat /user/cloudera/hat1/lab1/part*
  362. 103
  363. 104
  364. 105
  365.  
  366. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  367. --username root --query "insert into mentor values (106),(107),(108)"
  368.  
  369. 21/10/19 07:02:15 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  370. 21/10/19 07:02:16 INFO tool.EvalSqlTool: 3 row(s) updated.
  371.  
  372. [cloudera@localhost ~]$ sqoop import --connect "jdbc:mysql://localhost/sampledata"
  373. --username root --table mentor --target-dir /user/cloudera/hat1/lab1
  374. --incremental append --check-column mno --last-value 105 -m 1
  375.  
  376. 21/10/19 07:06:25 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  377. 21/10/19 07:06:25 INFO tool.CodeGenTool: Beginning code generation
  378. 21/10/19 07:06:26 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  379. 21/10/19 07:06:26 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `mentor` AS t LIMIT 1
  380. 21/10/19 07:06:26 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
  381. 21/10/19 07:06:26 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop-0.20-mapreduce/hadoop-core.jar
  382. Note: /tmp/sqoop-cloudera/compile/4c1c9bcdd05df90850bd31d01931160b/mentor.java uses or overrides a deprecated API.
  383. Note: Recompile with -Xlint:deprecation for details.
  384. 21/10/19 07:06:32 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-cloudera/compile/4c1c9bcdd05df90850bd31d01931160b/mentor.jar
  385. 21/10/19 07:06:32 INFO tool.ImportTool: Maximal id query for free form incremental import: SELECT MAX(`mno`) FROM mentor
  386. 21/10/19 07:06:32 INFO tool.ImportTool: Incremental import based on column `mno`
  387. 21/10/19 07:06:32 INFO tool.ImportTool: Lower bound value: 105
  388. 21/10/19 07:06:32 INFO tool.ImportTool: Upper bound value: 108
  389. 21/10/19 07:06:32 WARN manager.MySQLManager: It looks like you are importing from mysql.
  390. 21/10/19 07:06:32 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
  391. 21/10/19 07:06:32 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
  392. 21/10/19 07:06:32 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
  393. 21/10/19 07:06:32 INFO mapreduce.ImportJobBase: Beginning import of mentor
  394. 21/10/19 07:06:35 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
  395. 21/10/19 07:06:38 INFO mapred.JobClient: Running job: job_202110190550_0008
  396. 21/10/19 07:06:39 INFO mapred.JobClient: map 0% reduce 0%
  397. 21/10/19 07:06:59 INFO mapred.JobClient: map 100% reduce 0%
  398. 21/10/19 07:07:04 INFO mapred.JobClient: Job complete: job_202110190550_0008
  399. 21/10/19 07:07:04 INFO mapred.JobClient: Counters: 23
  400. 21/10/19 07:07:04 INFO mapred.JobClient: File System Counters
  401. 21/10/19 07:07:04 INFO mapred.JobClient: FILE: Number of bytes read=0
  402. 21/10/19 07:07:04 INFO mapred.JobClient: FILE: Number of bytes written=175623
  403. 21/10/19 07:07:04 INFO mapred.JobClient: FILE: Number of read operations=0
  404. 21/10/19 07:07:04 INFO mapred.JobClient: FILE: Number of large read operations=0
  405. 21/10/19 07:07:04 INFO mapred.JobClient: FILE: Number of write operations=0
  406. 21/10/19 07:07:04 INFO mapred.JobClient: HDFS: Number of bytes read=87
  407. 21/10/19 07:07:04 INFO mapred.JobClient: HDFS: Number of bytes written=20
  408. 21/10/19 07:07:04 INFO mapred.JobClient: HDFS: Number of read operations=1
  409. 21/10/19 07:07:04 INFO mapred.JobClient: HDFS: Number of large read operations=0
  410. 21/10/19 07:07:04 INFO mapred.JobClient: HDFS: Number of write operations=1
  411. 21/10/19 07:07:04 INFO mapred.JobClient: Job Counters
  412. 21/10/19 07:07:04 INFO mapred.JobClient: Launched map tasks=1
  413. 21/10/19 07:07:04 INFO mapred.JobClient: Total time spent by all maps in occupied slots (ms)=21962
  414. 21/10/19 07:07:04 INFO mapred.JobClient: Total time spent by all reduces in occupied slots (ms)=0
  415. 21/10/19 07:07:04 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  416. 21/10/19 07:07:04 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  417. 21/10/19 07:07:04 INFO mapred.JobClient: Map-Reduce Framework
  418. 21/10/19 07:07:04 INFO mapred.JobClient: Map input records=5
  419. 21/10/19 07:07:04 INFO mapred.JobClient: Map output records=5
  420. 21/10/19 07:07:04 INFO mapred.JobClient: Input split bytes=87
  421. 21/10/19 07:07:04 INFO mapred.JobClient: Spilled Records=0
  422. 21/10/19 07:07:04 INFO mapred.JobClient: CPU time spent (ms)=210
  423. 21/10/19 07:07:04 INFO mapred.JobClient: Physical memory (bytes) snapshot=99799040
  424. 21/10/19 07:07:04 INFO mapred.JobClient: Virtual memory (bytes) snapshot=656605184
  425. 21/10/19 07:07:04 INFO mapred.JobClient: Total committed heap usage (bytes)=60751872
  426. 21/10/19 07:07:04 INFO mapreduce.ImportJobBase: Transferred 20 bytes in 31.0254 seconds (0.6446 bytes/sec)
  427. 21/10/19 07:07:04 INFO mapreduce.ImportJobBase: Retrieved 5 records.
  428. 21/10/19 07:07:04 INFO util.AppendUtils: Appending to directory lab1
  429. 21/10/19 07:07:04 INFO util.AppendUtils: Using found partition 1
  430. 21/10/19 07:07:04 INFO tool.ImportTool: Incremental import complete! To run another incremental import of all data following this import, supply the following arguments:
  431. 21/10/19 07:07:04 INFO tool.ImportTool: --incremental append
  432. 21/10/19 07:07:04 INFO tool.ImportTool: --check-column mno
  433. 21/10/19 07:07:04 INFO tool.ImportTool: --last-value 108
  434. 21/10/19 07:07:04 INFO tool.ImportTool: (Consider saving this with 'sqoop job --create')
  435.  
  436. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/sampledata"
  437. --username root --query "select * from mentor"
  438.  
  439. 21/10/19 07:08:05 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  440. ---------------
  441. | mno |
  442. ---------------
  443. | 101 |
  444. | 102 |
  445. | 103 |
  446. | 104 |
  447. | 105 |
  448. | 106 |
  449. | 107 |
  450. | 108 |
  451. ---------------
  452.  
  453.  
  454. EXPERIMENT 4:
  455.  
  456. [cloudera@localhost ~]$ gedit kk1
  457. 1,a
  458. 2,b
  459. 3,c
  460. save & exit
  461.  
  462. [cloudera@localhost ~]$ hadoop fs -put kk1 /user/cloudera
  463.  
  464. [cloudera@localhost ~]$ hadoop fs -ls /user/cloudera
  465. Found 57 items
  466. drwx------ - cloudera cloudera 0 2020-03-09 20:43 /user/cloudera/.Trash
  467. drwx------ - cloudera cloudera 0 2021-10-15 22:32 /user/cloudera/.staging
  468. drwxr-xr-x - cloudera cloudera 0 2021-10-15 22:32 /user/cloudera/_sqoop
  469. -rw-r--r-- 3 cloudera cloudera 282 2021-02-03 19:55 /user/cloudera/actor
  470. -rw-r--r-- 3 cloudera cloudera 1564 2021-02-03 22:03 /user/cloudera/actor1
  471. -rw-r--r-- 3 cloudera cloudera 212 2021-02-04 01:24 /user/cloudera/ara
  472. drwxr-xr-x - cloudera cloudera 0 2020-11-19 21:43 /user/cloudera/b3
  473. -rw-r--r-- 3 cloudera cloudera 59994 2020-11-24 20:48 /user/cloudera/cse553
  474. -rw-r--r-- 3 cloudera cloudera 28 2020-03-13 03:43 /user/cloudera/data
  475. -rw-r--r-- 3 cloudera cloudera 83 2020-03-11 22:59 /user/cloudera/datafile
  476. drwxr-xr-x - cloudera cloudera 0 2021-01-17 22:56 /user/cloudera/deepti
  477. -rw-r--r-- 3 cloudera cloudera 3101 2020-11-12 00:55 /user/cloudera/demo
  478. -rw-r--r-- 3 cloudera cloudera 155 2020-03-11 21:11 /user/cloudera/doctor
  479. -rw-r--r-- 3 cloudera cloudera 6201 2020-11-19 21:36 /user/cloudera/f1
  480. -rw-r--r-- 3 cloudera cloudera 67 2021-02-03 00:46 /user/cloudera/f2
  481. -rw-r--r-- 3 cloudera cloudera 110 2020-03-12 21:26 /user/cloudera/gobind
  482. drwxr-xr-x - cloudera supergroup 0 2020-11-26 00:49 /user/cloudera/hio
  483. -rw-r--r-- 3 cloudera cloudera 16 2021-10-15 22:34 /user/cloudera/kk1
  484. drwxr-xr-x - cloudera cloudera 0 2021-02-03 00:57 /user/cloudera/l2out
  485. -rw-r--r-- 3 cloudera cloudera 68 2021-10-11 22:48 /user/cloudera/lab1sem7.txt
  486. -rw-r--r-- 3 cloudera cloudera 21 2020-03-11 22:03 /user/cloudera/math
  487. -rw-r--r-- 3 cloudera cloudera 135 2021-01-28 00:25 /user/cloudera/movie
  488. drwxr-xr-x - cloudera cloudera 0 2021-10-11 03:12 /user/cloudera/nh001
  489. -rw-r--r-- 3 cloudera cloudera 0 2021-01-28 01:04 /user/cloudera/op
  490. drwxr-xr-x - cloudera cloudera 0 2020-11-24 21:02 /user/cloudera/op_grep
  491. drwxr-xr-x - cloudera cloudera 0 2020-11-24 20:55 /user/cloudera/opcse553
  492. drwxr-xr-x - cloudera cloudera 0 2021-01-17 23:50 /user/cloudera/out1
  493. drwxr-xr-x - cloudera cloudera 0 2021-01-18 00:03 /user/cloudera/out2
  494. drwxr-xr-x - cloudera cloudera 0 2021-02-03 22:08 /user/cloudera/outactor
  495. drwxr-xr-x - cloudera cloudera 0 2020-11-12 01:10 /user/cloudera/outp1
  496. -rw-r--r-- 3 cloudera cloudera 0 2021-01-28 01:42 /user/cloudera/output
  497. drwxr-xr-x - cloudera cloudera 0 2021-10-11 23:02 /user/cloudera/output1
  498. drwxr-xr-x - cloudera cloudera 0 2021-02-03 19:59 /user/cloudera/outputa
  499. -rw-r--r-- 3 cloudera cloudera 191 2020-03-11 21:11 /user/cloudera/patient
  500. drwxr-xr-x - cloudera cloudera 0 2021-10-11 00:15 /user/cloudera/pig_b3
  501. -rw-r--r-- 3 cloudera cloudera 190 2021-02-03 20:19 /user/cloudera/players
  502. -rw-r--r-- 3 cloudera cloudera 206 2020-03-09 20:51 /user/cloudera/pro
  503. -rw-r--r-- 3 cloudera cloudera 45 2020-03-09 20:51 /user/cloudera/q.csv
  504. drwxr-xr-x - cloudera cloudera 0 2021-10-13 03:56 /user/cloudera/saisreeja
  505. -rw-r--r-- 3 cloudera cloudera 206 2020-03-10 20:47 /user/cloudera/samp148.csv
  506. drwxr-xr-x - cloudera cloudera 0 2021-10-15 22:28 /user/cloudera/sat
  507. drwxr-xr-x - cloudera cloudera 0 2020-03-11 23:30 /user/cloudera/script1_086
  508. drwxr-xr-x - cloudera cloudera 0 2020-03-11 23:12 /user/cloudera/script_086
  509. drwxr-xr-x - cloudera cloudera 0 2020-03-12 21:50 /user/cloudera/script_o7
  510. drwxr-xr-x - cloudera cloudera 0 2020-03-12 21:57 /user/cloudera/script_o8
  511. -rw-r--r-- 3 cloudera cloudera 145 2020-03-09 22:51 /user/cloudera/split.txt
  512. drwxr-xr-x - cloudera cloudera 0 2021-02-03 01:25 /user/cloudera/student
  513. drwxr-xr-x - cloudera cloudera 0 2021-10-15 22:14 /user/cloudera/sty
  514. drwxr-xr-x - cloudera cloudera 0 2020-11-12 02:07 /user/cloudera/t1
  515. drwxr-xr-x - cloudera cloudera 0 2020-11-12 01:58 /user/cloudera/t2
  516. drwxr-xr-x - cloudera cloudera 0 2021-10-15 22:07 /user/cloudera/teach
  517. drwxr-xr-x - cloudera cloudera 0 2021-02-03 01:25 /user/cloudera/teacher
  518. -rw-r--r-- 3 cloudera cloudera 13 2021-02-03 01:46 /user/cloudera/test
  519. -rw-r--r-- 3 cloudera cloudera 8359 2020-11-18 01:22 /user/cloudera/text.csv
  520. -rw-r--r-- 3 cloudera cloudera 64 2021-02-03 20:04 /user/cloudera/train
  521. -rw-r--r-- 3 cloudera cloudera 64 2021-02-03 22:14 /user/cloudera/train1
  522. -rw-r--r-- 3 cloudera cloudera 64 2021-02-03 22:30 /user/cloudera/train11
  523.  
  524. [cloudera@localhost ~]$ hadoop fs -cat /user/cloudera/kk1
  525. 1,a
  526. 2,b
  527. 3,c
  528. 4,d
  529.  
  530. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/dd1"
  531. --username root --query "create table table_kk1(a int , b char)"
  532.  
  533. 21/10/15 22:37:02 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  534. 21/10/15 22:37:03 INFO tool.EvalSqlTool: 0 row(s) updated.
  535.  
  536. [cloudera@localhost ~]$ sqoop export --connect "jdbc:mysql://localhost/dd1"
  537. --username root --table table_kk1 --export-dir /user/cloudera/kk1
  538.  
  539. 21/10/15 22:38:05 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  540. 21/10/15 22:38:05 INFO tool.CodeGenTool: Beginning code generation
  541. 21/10/15 22:38:05 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `table_kk1` AS t LIMIT 1
  542. 21/10/15 22:38:05 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `table_kk1` AS t LIMIT 1
  543. 21/10/15 22:38:05 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
  544. 21/10/15 22:38:05 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop-0.20-mapreduce/hadoop-core.jar
  545. Note: /tmp/sqoop-cloudera/compile/9db04b8e4401494dec22682ee84857be/table_kk1.java uses or overrides a deprecated API.
  546. Note: Recompile with -Xlint:deprecation for details.
  547. 21/10/15 22:38:08 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-cloudera/compile/9db04b8e4401494dec22682ee84857be/table_kk1.jar
  548. 21/10/15 22:38:08 INFO mapreduce.ExportJobBase: Beginning export of table_kk1
  549. 21/10/15 22:38:09 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same.
  550. 21/10/15 22:38:10 INFO input.FileInputFormat: Total input paths to process : 1
  551. 21/10/15 22:38:10 INFO input.FileInputFormat: Total input paths to process : 1
  552. 21/10/15 22:38:10 INFO mapred.JobClient: Running job: job_202110152121_0009
  553. 21/10/15 22:38:11 INFO mapred.JobClient: map 0% reduce 0%
  554. 21/10/15 22:38:46 INFO mapred.JobClient: map 25% reduce 0%
  555. 21/10/15 22:38:49 INFO mapred.JobClient: map 50% reduce 0%
  556. 21/10/15 22:38:57 INFO mapred.JobClient: map 75% reduce 0%
  557. 21/10/15 22:38:58 INFO mapred.JobClient: map 100% reduce 0%
  558. 21/10/15 22:39:00 INFO mapred.JobClient: Job complete: job_202110152121_0009
  559. 21/10/15 22:39:00 INFO mapred.JobClient: Counters: 24
  560. 21/10/15 22:39:00 INFO mapred.JobClient: File System Counters
  561. 21/10/15 22:39:00 INFO mapred.JobClient: FILE: Number of bytes read=0
  562. 21/10/15 22:39:00 INFO mapred.JobClient: FILE: Number of bytes written=697132
  563. 21/10/15 22:39:00 INFO mapred.JobClient: FILE: Number of read operations=0
  564. 21/10/15 22:39:00 INFO mapred.JobClient: FILE: Number of large read operations=0
  565. 21/10/15 22:39:00 INFO mapred.JobClient: FILE: Number of write operations=0
  566. 21/10/15 22:39:00 INFO mapred.JobClient: HDFS: Number of bytes read=580
  567. 21/10/15 22:39:00 INFO mapred.JobClient: HDFS: Number of bytes written=0
  568. 21/10/15 22:39:00 INFO mapred.JobClient: HDFS: Number of read operations=16
  569. 21/10/15 22:39:00 INFO mapred.JobClient: HDFS: Number of large read operations=0
  570. 21/10/15 22:39:00 INFO mapred.JobClient: HDFS: Number of write operations=0
  571. 21/10/15 22:39:00 INFO mapred.JobClient: Job Counters
  572. 21/10/15 22:39:00 INFO mapred.JobClient: Launched map tasks=4
  573. 21/10/15 22:39:00 INFO mapred.JobClient: Data-local map tasks=4
  574. 21/10/15 22:39:00 INFO mapred.JobClient: Total time spent by all maps in occupied slots (ms)=82920
  575. 21/10/15 22:39:00 INFO mapred.JobClient: Total time spent by all reduces in occupied slots (ms)=0
  576. 21/10/15 22:39:00 INFO mapred.JobClient: Total time spent by all maps waiting after reserving slots (ms)=0
  577. 21/10/15 22:39:00 INFO mapred.JobClient: Total time spent by all reduces waiting after reserving slots (ms)=0
  578. 21/10/15 22:39:00 INFO mapred.JobClient: Map-Reduce Framework
  579. 21/10/15 22:39:00 INFO mapred.JobClient: Map input records=4
  580. 21/10/15 22:39:00 INFO mapred.JobClient: Map output records=4
  581. 21/10/15 22:39:00 INFO mapred.JobClient: Input split bytes=528
  582. 21/10/15 22:39:00 INFO mapred.JobClient: Spilled Records=0
  583. 21/10/15 22:39:00 INFO mapred.JobClient: CPU time spent (ms)=2890
  584. 21/10/15 22:39:00 INFO mapred.JobClient: Physical memory (bytes) snapshot=424091648
  585. 21/10/15 22:39:00 INFO mapred.JobClient: Virtual memory (bytes) snapshot=2617999360
  586. 21/10/15 22:39:00 INFO mapred.JobClient: Total committed heap usage (bytes)=243007488
  587. 21/10/15 22:39:00 INFO mapreduce.ExportJobBase: Transferred 580 bytes in 51.1094 seconds (11.3482 bytes/sec)
  588. 21/10/15 22:39:00 INFO mapreduce.ExportJobBase: Exported 4 records.
  589.  
  590. [cloudera@localhost ~]$ sqoop eval --connect "jdbc:mysql://localhost/dd1"
  591. --username root --query "select * from table_kk1"
  592.  
  593. 21/10/15 22:41:47 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
  594. -------------------
  595. | a | b |
  596. -------------------
  597. | 1 | a |
  598. | 2 | b |
  599. | 3 | c |
  600. | 4 | d |
  601. -------------------
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!