title: Sqoop Teradata Connector issue - Error: The user does not have CREATE TABLE access to database
body: <p>I am facing issue with Teradata connector for Sqoop, when i am trying to import table from Teradata View. I have only access for Views.</p>
  
  <p>but somehow when sqoop job starts it is trying to create a table in Teradata DB which i am accessing but dont have right to create any table in that DB/schema</p>
  
  <p>I am getting below Error</p>
  
  <pre><code> 13/05/31 03:40:12 ERROR tool.ImportTool: Encountered IOException running import job:     com.teradata.hadoop.exception.TeradataHadoopSQLException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.01] [Error 3524] [SQLState 42000] The user does not have CREATE TABLE access to database EDWABSVIEWS.
      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)
      at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
      at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:298)
      at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:179)
      at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:120)
      at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:111)
      at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:372)
      at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:314)
      at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecute(TDStatement.java:277)
      at com.teradata.jdbc.jdbc_4.TDStatement.execute(TDStatement.java:1087)
      at com.teradata.hadoop.TeradataConnection.executeDDL(TeradataConnection.java:379)
      at com.teradata.hadoop.TeradataConnection.createTable(TeradataConnection.java:1655)
      at com.teradata.hadoop.TeradataPartitionStageInputProcessor.createStageTable(TeradataPartitionStageInputProcessor.java:233)
      at com.teradata.hadoop.TeradataPartitionStageInputProcessor.setup(TeradataPartitionStageInputProcessor.java:87)
      at com.teradata.hadoop.TeradataImportJob.run(TeradataImportJob.java:36)
      at org.apache.sqoop.teradata.TeradataImportJob.doSubmitJob(TeradataImportJob.java:173)
      at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)
      at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:208)
      at org.apache.sqoop.teradata.TeradataConnManager.importTable(TeradataConnManager.java:64)
      at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
      at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
      at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
      at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
  
      at    com.teradata.hadoop.TeradataPartitionStageInputProcessor.createStageTable(TeradataPartitionStageInputProcessor.java:243)
      at com.teradata.hadoop.TeradataPartitionStageInputProcessor.setup(TeradataPartitionStageInputProcessor.java:87)
      at com.teradata.hadoop.TeradataImportJob.run(TeradataImportJob.java:36)
      at org.apache.sqoop.teradata.TeradataImportJob.doSubmitJob(TeradataImportJob.java:173)
      at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)
      at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:208)
      at     org.apache.sqoop.teradata.TeradataConnManager.importTable(TeradataConnManager.java:64)
      at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
      at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
      at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
      at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
  </code></pre>
  
  <p>Please assist.</p>