[
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)
