You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2014/03/29 16:33:16 UTC
[jira] [Commented] (SQOOP-1209) DirectNetezzaManager fails to find
tables from older Netezza system catalogs
[ https://issues.apache.org/jira/browse/SQOOP-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13954292#comment-13954292 ]
ASF subversion and git services commented on SQOOP-1209:
--------------------------------------------------------
Commit ddd454b9b67bd32c12cbd1230c02d2a20c27d917 in sqoop's branch refs/heads/trunk from [~jarcec]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=ddd454b ]
SQOOP-1209: DirectNetezzaManager fails to find tables from older Netezza system catalogs
(Venkat Ranganathan via Jarek Jarcec Cecho)
> DirectNetezzaManager fails to find tables from older Netezza system catalogs
> ----------------------------------------------------------------------------
>
> Key: SQOOP-1209
> URL: https://issues.apache.org/jira/browse/SQOOP-1209
> Project: Sqoop
> Issue Type: Bug
> Components: connectors
> Affects Versions: 1.4.4
> Reporter: Kaufman Ng
> Assignee: Venkat Ranganathan
> Fix For: 1.4.5
>
> Attachments: SQOOP-1209.patch
>
>
> DirectNetezzaManager's checkTable method fails to find table and it will error out and returns something like:
> "<table_name> is not a valid Netezza table"
> The cause is the query to look for netezza table (QUERY_CHECK_DICTIONARY_FOR_TABLE) is case-sensitive. To query for tables in Netezza catalog this needs to be case-insensitive.
> Older netezza installs have system catalog tables stored in lowercase 'table', while more recent Netezza have 'TABLE' by default.
> Based on the feedback from Netezza admins, the query recommended to check for tables in _V_TABLES system catalog (instead of _V_OBJECTS) table.
--
This message was sent by Atlassian JIRA
(v6.2#6252)