Hello, These are NOT ERRORS: INFO conf.Configuration: resource-types.xml not found. INFO resource.ResourceUtils: Unable to find 'resource-types.xml'. As for this: INFO mapreduce.Job: map 0% reduce 0% How many mappers were specified for the IMPORT? Try locating the running containers in YARN and take a few JSTACKs to find out if the mapper is stuck waiting from your source database, if so make sure there are no firewall/network rules preventing the flow of data. Are you able to execute SQOOP EVAL on the source DB? If so, try using options: -jt local -m 1 --verbose If the job completes, that would confirm a communication issue from your NodeManagers to the source DB ... View more

Are you able to reproduce at will? If so, provide the Cloudera Runtime version and the associated DDL/DML ... View more

@hanumanth  Your Python code is throwing this:  OSError: [Errno 2] No such file or directory The stack is not enough to determine what is happening Please look at the following items: * job.properties / workflow.xml    Is this being setup as a Shell Action?    Are all the necessary files being provided?    The action needs to setup the Python environment within a YARN container * Oozie launcher log    Is Python code starting to execute and then hit a snag or it does fail from the get-go? ... View more

@zhaiziha  Are you running this query on DataHub or Hive VW? Please try your SELECT statement on Beeline from DataHub as follows and let us know how it works for you SET hive.server2.logging.operation.level=VERBOSE; SET hive.input.format = org.apache.hadoop.hive.ql.io.HiveInputFormat; SET fs.s3a.experimental.input.fadvise=random; SET fs.s3a.readahead.range=1024K; SET parquet.enable.dictionary=false; SELECT * FROM small; Should that fail, can you provide the beeline output and simple repro steps? Seems like some form of HADOOP-16109 ... View more

OK.... So, sqlplus works from the same host SQOOP is being tried? What is the output from SQOOP eval for "SELECT COUNT(*) FROM <YOUR TABLE>;" vs import on the same table?    ... View more

Hello, This seems more of an Oracle TNS listener misconfiguration  Oracle native sqlplus should be able to connect before using SQOOP:  sqlplus <USER>/<PASSWD>@prxd10-scan.intranet.slt.com.lk:1521/<listener> Hope this helps, -JMP ... View more

@Lorenzo On CDP Hive the Spark engine is deprecated if favor of TEZ      ... View more