sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3124) Fix ordering in column list query of PostgreSQL connector
Date Tue, 17 Jan 2017 15:32:26 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15826240#comment-15826240
] 

ASF subversion and git services commented on SQOOP-3124:
--------------------------------------------------------

Commit d0f99c01c7afa8fade70c4429899e36d3b29cc39 in sqoop's branch refs/heads/trunk from [~maugli]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=d0f99c0 ]

SQOOP-3124: Fix ordering in column list query of
PostgreSQL connector to reflect the logical order
instead of adhoc ordering

(Szabolcs Vasas via Attila Szabo)


> Fix ordering in column list query of PostgreSQL connector
> ---------------------------------------------------------
>
>                 Key: SQOOP-3124
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3124
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.6
>            Reporter: Szabolcs Vasas
>            Assignee: Szabolcs Vasas
>             Fix For: 1.4.7
>
>         Attachments: SQOOP-3124.patch
>
>
> PostgreSQL connector gets the lit of column names from pg_attribute system catalog table
using the following query:
> {code}
> SELECT col.ATTNAME FROM PG_CATALOG.PG_NAMESPACE sch,  PG_CATALOG.PG_CLASS tab, PG_CATALOG.PG_ATTRIBUTE
col
> WHERE sch.OID = tab.RELNAMESPACE   AND tab.OID = col.ATTRELID   AND sch.NSPNAME = (SELECT
CURRENT_SCHEMA())  AND tab.RELNAME = ?   AND col.ATTNUM >= 1  AND col.ATTISDROPPED = 'f'
> {code}
> This SELECT statement does not contain an ORDER BY clause so the order of the result
set is not guaranteed to be the column order defined during table creation and this can cause
issues for the users.
> The task is to make sure that the result set of this query is sorted by the attnum column
of the pg_attribute table (https://wiki.postgresql.org/wiki/Alter_column_position).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message