You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by ranjith raghunath <ra...@gmail.com> on 2012/12/04 05:06:20 UTC
sqoop and table schema
I apologize if this question has already been asked before. I am using
sqoop to import data from a SQL Server/DB2/Postgres database. Is there a
known issue with using schame.table in the --table parameter?
Any help will be appreciated.
Thanks
Re: sqoop and table schema
Posted by ranjith raghunath <ra...@gmail.com>.
So I was able to get it to work with DB2. The key there was to use a ";" at
the end of the jdbc url. As I come across others I will go ahead and post
it here.
Thanks,
ranjith
On Tue, Dec 4, 2012 at 9:56 AM, Jarek Jarcec Cecho <ja...@apache.org>wrote:
> I've actually google for some way to specify schema in JDBC URL prior
> working on SQOOP-601 and SQOOP-540. I do vaguely remember that I found
> similar property, but it simply did not worked for me on recent versions.
> Please don't hesitate and let me know if you will have more luck!
>
> Jarcec
>
> On Tue, Dec 04, 2012 at 07:00:19AM -0600, ranjith raghunath wrote:
> > Appreciate the response Jarek. Thanks for mentioning this as it was
> driving
> > me nuts.
> >
> > What about using parameters in the jdbc url? I have noticed that for DB2
> > (per a "how to" through google) it seems that this may work, --connect
> > "jdbc:db2://192.168.1.3:50001/sample:currentSchema=DB2INST1;". I am
> using
> > the db2jcc4.jar. However, I have not have had any luck with that.
> >
> > I guess what I am really asking is if there is a way around this without
> > building sqoop from trunk. And have any of you had any success with that
> > way.
> >
> > On Mon, Dec 3, 2012 at 11:35 PM, Jarek Jarcec Cecho <jarcec@apache.org
> >wrote:
> >
> > > Hi Ranjith,
> > > parameter --table is meant to be used for table name only. It do not
> > > support custom scheme unfortunately.
> > >
> > > We've just recently added support for custom schemes for PostreSQL
> > > (SQOOP-601) and Microsoft SQL (SQOOP-540). Unfortunately both issues
> are
> > > available only on trunk and are not part of any release yet. But hey,
> you
> > > can always build your own Sqoop from the trunk!
> > >
> > > Jarcec
> > >
> > > On Mon, Dec 03, 2012 at 10:06:20PM -0600, ranjith raghunath wrote:
> > > > I apologize if this question has already been asked before. I am
> using
> > > > sqoop to import data from a SQL Server/DB2/Postgres database. Is
> there a
> > > > known issue with using schame.table in the --table parameter?
> > > >
> > > > Any help will be appreciated.
> > > >
> > > > Thanks
> > >
>
Re: sqoop and table schema
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
I've actually google for some way to specify schema in JDBC URL prior working on SQOOP-601 and SQOOP-540. I do vaguely remember that I found similar property, but it simply did not worked for me on recent versions. Please don't hesitate and let me know if you will have more luck!
Jarcec
On Tue, Dec 04, 2012 at 07:00:19AM -0600, ranjith raghunath wrote:
> Appreciate the response Jarek. Thanks for mentioning this as it was driving
> me nuts.
>
> What about using parameters in the jdbc url? I have noticed that for DB2
> (per a "how to" through google) it seems that this may work, --connect
> "jdbc:db2://192.168.1.3:50001/sample:currentSchema=DB2INST1;". I am using
> the db2jcc4.jar. However, I have not have had any luck with that.
>
> I guess what I am really asking is if there is a way around this without
> building sqoop from trunk. And have any of you had any success with that
> way.
>
> On Mon, Dec 3, 2012 at 11:35 PM, Jarek Jarcec Cecho <ja...@apache.org>wrote:
>
> > Hi Ranjith,
> > parameter --table is meant to be used for table name only. It do not
> > support custom scheme unfortunately.
> >
> > We've just recently added support for custom schemes for PostreSQL
> > (SQOOP-601) and Microsoft SQL (SQOOP-540). Unfortunately both issues are
> > available only on trunk and are not part of any release yet. But hey, you
> > can always build your own Sqoop from the trunk!
> >
> > Jarcec
> >
> > On Mon, Dec 03, 2012 at 10:06:20PM -0600, ranjith raghunath wrote:
> > > I apologize if this question has already been asked before. I am using
> > > sqoop to import data from a SQL Server/DB2/Postgres database. Is there a
> > > known issue with using schame.table in the --table parameter?
> > >
> > > Any help will be appreciated.
> > >
> > > Thanks
> >
Re: sqoop and table schema
Posted by ranjith raghunath <ra...@gmail.com>.
Appreciate the response Jarek. Thanks for mentioning this as it was driving
me nuts.
What about using parameters in the jdbc url? I have noticed that for DB2
(per a "how to" through google) it seems that this may work, --connect
"jdbc:db2://192.168.1.3:50001/sample:currentSchema=DB2INST1;". I am using
the db2jcc4.jar. However, I have not have had any luck with that.
I guess what I am really asking is if there is a way around this without
building sqoop from trunk. And have any of you had any success with that
way.
On Mon, Dec 3, 2012 at 11:35 PM, Jarek Jarcec Cecho <ja...@apache.org>wrote:
> Hi Ranjith,
> parameter --table is meant to be used for table name only. It do not
> support custom scheme unfortunately.
>
> We've just recently added support for custom schemes for PostreSQL
> (SQOOP-601) and Microsoft SQL (SQOOP-540). Unfortunately both issues are
> available only on trunk and are not part of any release yet. But hey, you
> can always build your own Sqoop from the trunk!
>
> Jarcec
>
> On Mon, Dec 03, 2012 at 10:06:20PM -0600, ranjith raghunath wrote:
> > I apologize if this question has already been asked before. I am using
> > sqoop to import data from a SQL Server/DB2/Postgres database. Is there a
> > known issue with using schame.table in the --table parameter?
> >
> > Any help will be appreciated.
> >
> > Thanks
>
Re: sqoop and table schema
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Ranjith,
parameter --table is meant to be used for table name only. It do not support custom scheme unfortunately.
We've just recently added support for custom schemes for PostreSQL (SQOOP-601) and Microsoft SQL (SQOOP-540). Unfortunately both issues are available only on trunk and are not part of any release yet. But hey, you can always build your own Sqoop from the trunk!
Jarcec
On Mon, Dec 03, 2012 at 10:06:20PM -0600, ranjith raghunath wrote:
> I apologize if this question has already been asked before. I am using
> sqoop to import data from a SQL Server/DB2/Postgres database. Is there a
> known issue with using schame.table in the --table parameter?
>
> Any help will be appreciated.
>
> Thanks