the debug level is stable in the related properties file To enable debug mode on sqoop we need to follow these steps. Add following two lines in *log4j.properties* and modify the sqoop command to include *--verbose* option
sqoop.root.logger=DEBUG,console org.apache.sqoop=DEBUG, console On Mon, 15 Jul 2019, 19:11 Marcelo Valle, <marcelo.va...@ktech.com> wrote: > Hi, > > I am having errors running sqoop export on oracle and it would be nice to > be able to enable some debug option where it would output all SQL > statements generated. > > I tried executing it with the option `-Doracle.jdbc.Trace=true` for oracle > JDBC driver, but it seems to have made no effect. > > How can I run sqoop in order to print all SQL statements? > > Thanks, > Marcelo. > > This email is confidential [and may be protected by legal privilege]. If > you are not the intended recipient, please do not copy or disclose its > content but contact the sender immediately upon receipt. > > KTech Services Ltd is registered in England as company number 10704940. > > Registered Office: The River Building, 1 Cousin Lane, London EC4R 3TE, > United Kingdom >