-Re: Sqoop, sending for a loop - newby lost - SQL Server/Sqoop
DSuiter RDX 2013-11-01, 13:43
Good work! Sometimes it's a simple thing...case sensitivity and the like,
or an extra leading space...glad you were able to track it down.
Now, if you want another puzzle for later, try putting a firewall in
between MSSQL server and your Hadoop cluster. :-)
Jr. Data Solutions Software Engineer
100 Sandusky Street | 2nd Floor | Pittsburgh, PA 15212
Google Voice: 412-256-8556 | www.rdx.com
On Fri, Nov 1, 2013 at 8:01 AM, Andrew Allaway <[EMAIL PROTECTED]>wrote:
> Update -
> All's fixed, my TCP/IP port 1433 and UDP 1434 were not open /*blushing*/
> Live'n learn:)
> Thanks all for help triaging my question!
> On Oct 30, 2013, at 10:32 PM, "Andrew Allaway" <[EMAIL PROTECTED]>
> Hi Jarcec, et al -
> Yes, that is rather vague of me. Apologizes, I appreciate your question
> and aid:)
> I've some updates, but still getting thrown for a loop by Hadoop-Sqoop:)
> /* I can't resist 0> <--not'a bad ice-cream-cone :) */
> * I was able to uninstall the sqoop 1.4.4 package and re-install it with
> the version that says sqoop-bin.1.4.4. That worked magically! Woohoo. I
> can now run sqoop! What was the difference of the stable release with bin
> vs w/o bin?
> * Now the down side, I cant, for the life of me, get sqoop to connect to
> my SQL Server. I've the specific jar file to run sqoop for sql server at
> nameNode: ...sqoop/lib/sqljdbc4.jar
> 1) When I submit the below from .../sqoop/, I get nowhere:) advice?
> bin/sqoop list-databases --connect
> What I think is the relevant part of error:
> 13/10/30 06:20:29 ERROR manager.CatalogQueryManager: Failed to list
> com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to
> the host Andy-ABC-1-HP, port 1433 has failed. Error: "null. Verify the
> connection properties. Make sure that an instance of SQL Server is running
> on the host and accepting TCP/IP connections at the port. Make sure that
> TCP connections to the port are not blocked by a firewall.".
> What I've got:
> My HP Laptop, set to static: IP4 - 192.168.10.13
> SQLServer running on the above laptop:
> Host name: Andy-ABC-1-HP
> Instance: BOB
> Port (per: start>sql server config. mgr>SQL native client>client
> protocols>tcp/ip>properties>port 1433
> DB: andy_dev
> schema: dbo
> Login: Andy-ABC-1
> Pw :
> b) namenode, 192.168.10.10, Debian, can ping 192.168.10.13 and
> 192.168.10.13 can ssh into namenode
> 2) When I lauch sqoop, it keeps saying "Error: /usr/lib/hadoop does not
> exist! Please set $HADOOP_COMMON_HOME to the root of your Hadoop
> installation. & Please set $HADOOP_MAPRED_HOME to the root of your Hadoop
> MapReduce installation." I then run: export export
> HADOOP_COMMON_HOME=/usr/local/hadoop and export
> HADOOP_MAPRED_HOME=/usr/local/hadoop. It works but after reboot it is
> back??? How to perm set it?
> Firewall was off when all above run...
> Any advice appreciated!
> > Date: Wed, 30 Oct 2013 14:28:52 -0700
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Subject: Re: Sqoop, sending for a loop - newby lost - SQL Server/Sqoop
> > Hi Andrew,
> > would you mind sharing with use exact commands and exact exceptions that
> you are seeing? It will help us to understand your issue better.
> > Jarcec
> > On Mon, Oct 28, 2013 at 07:29:47PM -0500, Andrew Allaway wrote:
> > > Hey Abe -
> > >
> > > I haven't because I'm working on running a real lean install on a ARM
> > >
> > > I want a bare bones build (Hadoop, Hive & Scoop). Starting to feel
> that although these packages are open source (Hadoop, Hive, Sqoop, etc),