You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Siddharth Indurthi (JIRA)" <ji...@apache.org> on 2013/11/22 06:42:35 UTC

[jira] [Comment Edited] (SQOOP-322) Allow specification of Hive Database name when operating on Hive table

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

Siddharth Indurthi edited comment on SQOOP-322 at 11/22/13 5:40 AM:
--------------------------------------------------------------------

I'm not sure if bumping this issue is the right thing to do, but here's the thing:
Specifying the database name through the dot notation would work fine while importing individual tables. But the problem is when all the tables from a database need to be imported using "sqoop import-all-tables", since "--table" can't be used at all in that context.
I can see a workaround, though... we could split the import job into 2 parts, where we import the database to hdfs first, and then import from hdfs into the specific hive database that you need. But, still...

P.S. In case this is already sorted out and I've been ranting in ignorance, please do point me in the right direction. ;)


was (Author: siddharth_indurthi):
I'm not sure if bumping this issue is the right thing to do, but here's the thing:
Specifying the database name through the dot notation would work fine while importing individual tables. But the problem is when all the tables from a database need to be imported using "sqoop import-all", since "--table" can't be used at all in that context.
I can see a workaround, though... we could split the import job into 2 parts, where we import the database to hdfs first, and then import from hdfs into the specific hive database that you need. But, still...

P.S. In case this is already sorted out and I've been ranting in ignorance, please do point me in the right direction. ;)

> 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 was sent by Atlassian JIRA
(v6.1#6144)