Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on 06-07-2019 02:11 AM - edited 09-16-2022 07:25 AM
I run a sqoop import command
sqoop import --connect jdbc:oracle:thin:.... --username .... --password ...
--query "SELECT $CHOOSE_COLUMN_NAMES FROM $OTABLE where $OWHERE and \$CONDITIONS" ...
through unix shell. If the command takes a long time how can i kill through shell ?
Thanks in advance.
Created on 06-13-2019 12:19 AM - edited 06-13-2019 12:19 AM
@Consult I found the solution. The sqoop command creates a YARN process, type MAPREDUCE.
So if we only kill the processes through unix shell, this YARN process will continue to run at the background.
So from the cloudera manager, we go to YARN --> Applications and then we kill the YARN process.
.
Created 06-07-2019 02:30 AM
Hello @eMazarakis,
Logically, you just search for the process and then use KILL command to kill that process.
Hope that helps.
Created 06-07-2019 06:45 AM
@Consult i thought the same think, but I had an incident yesterday. I killed the process but the morning I saw the table to be imported under the sqoop schema. I was wondering if there is another way to kill the command.
Created on 06-13-2019 12:19 AM - edited 06-13-2019 12:19 AM
@Consult I found the solution. The sqoop command creates a YARN process, type MAPREDUCE.
So if we only kill the processes through unix shell, this YARN process will continue to run at the background.
So from the cloudera manager, we go to YARN --> Applications and then we kill the YARN process.
.