sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejoy ks <bejo...@gmail.com>
Subject Re: [sqoop-user] How to see the imported data
Date Tue, 13 Dec 2011 16:10:30 GMT
Hi Tariq
       Please subscribe to sqoop-user@incubator.apache.org and post your
queries there, as this is the current active SQOOP mailing list. Moving
this conversation  to apache mailing lists.

        Can you post the SQOOP command you used to import data. Did you see
the map reduce job running to completion or was there any errors if so
please post the stack trace.

By the way does your import command looks something like this, just verify
you have the minimum required arguments
sqoop import --connect jdbc:mysql://db.*****.com/test_db --username user1
-P --table EMPLOYEES -split-by EMPLOYEE_ID --target-dir

In this case the data would be availabe in HDFS under
/userdata/bejoys/testImports/EMPLOYEES , If you are using --warehouse-dir
instead of --target-dir then the data would be available within a directory
with name same as your imported table name within your specified warehouse

                You can import data from any jdbc compliant database to
SQOOP irrespective of the location of your data base server. The server can
be in any remote location, you just need the database connection url and
the access credentials. For SQOOP with oracle there is an optimized
connector called Oraoop. You can utilize that for better performance

      In default mode without oraoop, you can use the import as
sqoop import --driver <full path of driver> --connect
--username User -P --table Test_Table --split-by Column_1 --num-mappers 13
--target-dir /userdata/bejoyks/sqoop/qatest/Test_Table

You need to have the oracle jdbc driver jar in your class path (sqoop lib
dir or use the -libjars option).

For reference

Hope it helps!...

On Tue, Dec 13, 2011 at 8:17 PM, TARIQ <dontariq@gmail.com> wrote:

> Hello group,
>   I have just started using sqoop. I was able to import a table from
> a mysql database, but I am not able to see the imported data in the
> hdfs. Need some help..Also I would like to know how can I use sqoop to
> import data form an oracle database that is present on a different
> machine.
> Many thanks in advance.
> Regards,
>     Tariq
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of
> Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please
> subscribe to it by sending an email to
> incubator-sqoop-user-subscribe@apache.org.


View raw message