sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2895) NCLOB import to Hive not supported
Date Fri, 25 Mar 2016 17:12:25 GMT

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

ASF GitHub Bot commented on SQOOP-2895:

GitHub user bonnetb opened a pull request:


    SQOOP-2895 : NCLOB import to Hive not supported

    see https://issues.apache.org/jira/browse/SQOOP-2895

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/bonnetb/sqoop SQOOP-2895

Alternatively you can review and apply these changes as the patch at:


To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #17
commit 42e44ed64b4ec8801d9377111e7eb5460bfef3bc
Author: Benjamin BONNET <benjamin.bonnet@m4x.org>
Date:   2016-03-25T17:07:00Z

    SQOOP-2895 : NCLOB import to Hive not supported


> NCLOB import to Hive not supported 
> -----------------------------------
>                 Key: SQOOP-2895
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2895
>             Project: Sqoop
>          Issue Type: Bug
>          Components: hive-integration
>            Reporter: Benjamin BONNET
> Hi,
> Sqoop cannot import and create Hive table when the table to be imported contains NCLOB
> Actually, data is correctly imported into HDFS but Hive table creation fails with :
> ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException:
Hive does not support the SQL type for column myNClobColumn
>         at org.apache.sqoop.hive.TableDefWriter.getCreateTableStmt(TableDefWriter.java:181)
>         at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:188)
>         at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:514)
>         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
>         at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
>         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
>         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
>         at org.apache.sqoop.Sqoop.main(Sqoop.java:244)
> That issue is due to the fact SQOOP knows CLOB type but not NCLOB. See type mappings
in org.apache.sqoop.hive.HiveTypes where NCLOB is not.
> Regards

This message was sent by Atlassian JIRA

View raw message