You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Shyam Rai (JIRA)" <ji...@apache.org> on 2017/12/22 21:57:00 UTC

[jira] [Created] (SQOOP-3271) DirectNetezzaManager Fails for checkTable method for row validation

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)