Return codes from Sqoop Import

Hi, Does Sqoop Import returns any codes. I am trying to find the return code to determine it is a success or failure. Thanks, Raj

Re: AW: Sqoop connection to MS SQL Server

It did not worked with a backslash. On Monday, November 18, 2013 5:06 PM, "Kallinteris, Christos" wrote: Hello Raj,   I’m pretty sure you need a backslash in front of the instance name instead of a slash   Please try   sqoop import --connect 'jdbc:sqlserver://ABC_SERVER:1433\Instance_Na

Re: Sqoop connection to MS SQL Server

Thanks Martin. I tried with the SCHEMA.TABLE_NAME. Did not worked. On Monday, November 18, 2013 2:05 PM, "Martin, Nick" wrote: I hit this when first starting out on Sqoop and using –table SCHEMA.TABLE_NAME worked for me.   If I don’t specify the schema I get the same “unable to find obje

Sqoop connection to MS SQL Server

I am getting error messages while connecting to a MS SQL Server running on a VM which has multiple instances. If it is a single machine and single instance - I could sucessfully run through the following command. sqoop import --connect 'jdbc:sqlserver://ABC_SERVER:1433;username=u1;password=p

Re: Oracle to HDFS through Sqoop and a Hive External Table

will affect the load and query time. 4. Think about compression as well before hand, as that will govern the data split, and performance of your queries as well. Regards, Manish Sent from my T-Mobile 4G LTE Device Original message From: Raj Hadoop Date: 11/03/2013 7:

Oracle to HDFS through Sqoop and a Hive External Table

Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in Oracle (about 60 million rows - Primary Key Customer Id). I want to bring this to HDFS and then create a Hive exter

Sqoop issue related to Hadoop

Hello all,   I am getting an error while using sqoop export ( Load HDFS file to Oracle ). I am not sure the issue might be a Sqoop or Hadoop related one. So I am sending it to both the dist lists.   I am using -   sqoop export --connect jdbc:oracle:thin:@//dbserv:9876/OKI --table  RAJ.CUSTOMERS -

Complex Oracle query to HDFS or Hive through Sqoop

Hello everyone, I want to load data from an Oracle query to HDFS or Hive through Sqoop.    My query in Oracle is based on something like this -    select a.col1,a.col2,bcol3,c.col4,d.col5 from T1 a,T2 b, T3 c, T4 d where a.col1=b.col1 and b.col2=c.col2 and c.col3 = d.col3;  Is this possib

Sqoop Import with a query - Where to set $CONDITIONS

Hi,   I am trying to load data from an Oracle query to HDFS using Sqoop.   sqoop import --connect jdbc:oracle:thin:@//gobyuioids:1521/dbgyru --username  user1 --password pwd--query 'select a.col1,a.col2,b.col1 from sch1.t1 a , sch1.t2 b  where $CONDITIONS' --split-by col1 --target-dir tgrdir1    

Sqoop Import Oracle Error - Attempted to generate class with no columns!

Hi,   I just finished setting up Apache sqoop 1.4.3. I am trying to test basic sqoop import on Oracle.   sqoop import --connect jdbc:oracle:thin:@//intelli.dmn.com:1521/DBT --table usr1.testonetwo --username usr123 --password passwd123     I am getting the error as 13/05/22 17:18:16 INFO manager