sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markus Kemper (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3029) Add an option for uppercase/lowercase column name mapping between HCatalog and RDBMS cloumn name list
Date Tue, 18 Oct 2016 22:01:01 GMT

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

Markus Kemper commented on SQOOP-3029:
--------------------------------------

Hey [~maugli],

I am not sure I follow you completely here.

Are you suggesting matching lower or upper or case-sensitive?

Thanks, [~markuskemper@me.com]

> Add an option for uppercase/lowercase column name mapping between HCatalog and RDBMS
cloumn name list
> -----------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-3029
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3029
>             Project: Sqoop
>          Issue Type: Improvement
>            Reporter: Attila Szabo
>             Fix For: 1.4.7
>
>
> The current implementation of HCatalog related export works out of the box with RDBMS
systems (e.g. Oracle) if the column names match case sensitive, although in several cases
the column names are received as an UPPER_CASE list from the RDBMS, and thus the export fails,
within the ClassWriter.
> Although the users have the possibility to define the name of the columns explicit with
the --columns option, in case of 100+ columns it's not practical.
> It would be great to have an option which could do the matching in lower and UPPER case
as well. The start point for this implementation should start from SqoopHCatUtilities#configureHCat
method with respect to ensure HCatalog api is able to handle the different cased column names.



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

Mime
View raw message