[
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:
https://github.com/apache/sqoop/pull/17
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:
https://github.com/apache/sqoop/pull/17.patch
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 <[email protected]>
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 columns.
> 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
(v6.3.4#6332)
