sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venkat Ranganathan (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (SQOOP-1209) DirectNetezzaManager fails to find tables from older Netezza system catalogs
Date Fri, 17 Jan 2014 02:03:19 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Venkat Ranganathan reassigned SQOOP-1209:
-----------------------------------------

    Assignee: Venkat Ranganathan

> 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
>            Reporter: Kaufman Ng
>            Assignee: Venkat Ranganathan
>
> 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.1.5#6160)

Mime
View raw message