Hi Christos,
would you mind sharing with us entire Sqoop command and associated log generated with parameter
--verbose?
Jarcec
On Wed, Oct 30, 2013 at 09:40:40AM +0000, Kallinteris, Christos wrote:
> Hello!
>
> I would like to import a complete database from SQL Server into HDFS and from there to
HIVE to have some data to play with.
>
> I figured out the necessary connection string and I get the first few tables imported
but then the job throws the invalid object name exception. As far as I can tell this happens
when the job encounters a table that has a schema other than dbo.
>
> Is this a known issue and if yes, is there a way around it?
>
> I'm using Sqoop 1.4.3-cdh4.4.0 on the latest stable Cloudera distribution.
>
> Thanks!
>
> Christos
>
> --
>
> initions AG
> Christos Kallinteris
> Weidestraße 120a
> D-22083 Hamburg
>
> t: +49 (0) 40 / 41 49 60-79
> f: +49 (0) 40 / 41 49 60-11
> e: kallinteris@initions.com<mailto:kallinteris@initions.com>
> w: www.initions.com<http://www.initions.com/>
>
>
> Vollständiger Name der Gesellschaft: initions innovative IT solutions AG
> Sitz der Gesellschaft: Hamburg
> Handelsregister Hamburg B 83929
> Aufsichtsratsvorsitzender: Dr. Michael Leue
> Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn
>
|