Shyam Rai created SQOOP-3271:
--------------------------------

             Summary: DirectNetezzaManager Fails for checkTable method for row 
validation
                 Key: SQOOP-3271
                 URL: https://issues.apache.org/jira/browse/SQOOP-3271
             Project: Sqoop
          Issue Type: Bug
          Components: connectors
    Affects Versions: 1.4.6
            Reporter: Shyam Rai


While using --direct method which invokes DirectNetezzaManager, checkTable 
method tries to validate 1 row using this query

{code}
  private static final String QUERY_CHECK_DICTIONARY_FOR_TABLE =
      "SELECT 1 FROM _V_TABLE WHERE OWNER= ? "
      + " AND TABLENAME = ? ";
{code}

For validity, the check introduced for the query {code} if (!rs.next()) {code} 
is already at the first row and when assessed for next ResultSet, gets into the 
exception clause. 





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to