[
https://issues.apache.org/jira/browse/SQOOP-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13159321#comment-13159321
]
Jarek Jarcec Cecho commented on SQOOP-322:
------------------------------------------
Hi Alex,
I wanted to ask on which hive version did you try the dot notation? (I mean
database.table) I've tried both CDH3B4 (hive 0.7.0) and CDH3U2 (hive 0.7.1)
versions and I'm getting following exception using proposed approach:
11/11/29 10:19:23 INFO hive.HiveImport: FAILED: Error in metadata:
org.apache.hadoop.hive.ql.metadata.HiveException: [database.table]: is not a
valid table name
11/11/29 10:19:23 INFO hive.HiveImport: FAILED: Execution Error, return code 1
from org.apache.hadoop.hive.ql.exec.DDLTask
11/11/29 10:19:23 ERROR tool.ImportTool: Encountered IOException running import
job: java.io.IOException: Hive exited with status 9
at
com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
at com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
at com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)
Would you mind to attach your patch meantime so that I use it?
Jarcec
> Allow specification of Hive Database name when operating on Hive table
> -----------------------------------------------------------------------
>
> Key: SQOOP-322
> URL: https://issues.apache.org/jira/browse/SQOOP-322
> Project: Sqoop
> Issue Type: New Feature
> Reporter: Alex Newman
> Assignee: Alex Newman
>
> Sqoop Hive-import does not allow the specification of the database within
> Hive in which the table is to be created or populated.
> Relevant issue: HIVE-2172
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
