Hi, Please check if the sqoop list tables option is working or not against the same connection details.
If this is not working, then there is a connectivity issue from the sqoop client machine to the database server.
The query that is failing here is not the query used by Sqoop to extract data , but the query used to collect metadata information from remote database. It then uses this information to create the hadoop writers. So this appears to be a connectivity issue, and this can be confirmed by running the list tables variant of sqoop first.
Thanks for the feedback. list-tables work but doesn't actually give any output. The following are the only logs I get for this. Should I be investigating connectivity?
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
16/07/05 12:55:16 INFO sqoop.Sqoop: Running Sqoop version: 184.108.40.206.4.2.0-258
16/07/05 12:55:16 INFO manager.SqlManager: Using default fetchSize of 1000
Creating the tables - this is an already existing database so I didn't have to create tables. I didn't create any tables on hadoop - I assumed this would be done automatically? I seem to have no log files within the sqoop directory. Is there something I need to do to enable logs?