You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Kaufman Ng (JIRA)" <ji...@apache.org> on 2013/09/30 18:32:23 UTC
[jira] [Created] (SQOOP-1209) DirectNetezzaManager fails to find
tables from older Netezza system catalogs
Kaufman Ng created SQOOP-1209:
---------------------------------
Summary: 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
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#6144)