sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Sqoop from/to Oracle
Date Tue, 29 Oct 2013 23:06:24 GMT
Nick,

I haven't tested this, but Sqoop should accept full timestamps when
exporting into DATE columns. If the data you're exporting has a full
timestamp (as it should after import), then the export job should just work.

-Abe


On Mon, Oct 28, 2013 at 9:55 AM, Martin, Nick <NiMartin@pssd.com> wrote:

>  Hi Abe,****
>
> ** **
>
> After doing some digging on this issue I’ve found I’m facing what seems
> like a fairly common issue with importing data from an Oracle DATE column
> and trying to export that same data (from HDFS) back into an Oracle DATE
> column (of course, it will have been converted to a timestamp on the way
> into HDFS). ****
>
> ** **
>
> So, what’s the current thinking on the best way to get around this issue?*
> ***
>
> ** **
>
> Thanks,****
>
> Nick  ****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Abraham Elmahrek [mailto:abe@cloudera.com]
> *Sent:* Tuesday, October 01, 2013 7:31 PM
>
> *To:* user@sqoop.apache.org
> *Subject:* Re: Sqoop from/to Oracle****
>
> ** **
>
> Nick,****
>
> ** **
>
> It looks like Sqoop believes the format of the timestamps are incorrect.
> Could you please inspect the data you are attempting to import and verify
> the columns are aligned and the data is correctly formatted? I believe if
> you use the --verbose option, Sqoop will give more details in its own logs
> and the tasks logs. Can you post the task logs back here?****
>
> ** **
>
> Some other information that might be helpful to us is an example of the
> data you're trying to export and the schema of the table you're importing
> to.****
>
> ** **
>
> -Abe****
>
> ** **
>
> On Tue, Oct 1, 2013 at 4:11 PM, Martin, Nick <NiMartin@pssd.com> wrote:***
> *
>
> Hi Abe,****
>
> ** **
>
> Just checking in to see if you had any suggestions for me to try?****
>
> ** **
>
> Thanks again,****
>
> Nick
>
> Sent from my iPhone****
>
>
> On Sep 30, 2013, at 6:36 PM, "Abraham Elmahrek" <abe@cloudera.com> wrote:*
> ***
>
>  Nick, ****
>
> ** **
>
> What is the exact command you are using and the exact error you are
> seeing? Also, what version of sqoop are you using?****
>
> ** **
>
> -Abe****
>
> ** **
>
> On Mon, Sep 30, 2013 at 3:32 PM, Martin, Nick <NiMartin@pssd.com> wrote:**
> **
>
> Hi all,
>
> I have a table I've imported from Oracle into HDFS and now I want to
> export it into an Oracle Db (import and export table schemas are identical).
>
> My initial attempt at exporting from HDFS (using Sqoop) to Oracle failed
> (data types failures). So, my question is what's the best way for me to
> accomplish this? My source table is a mixture of NUMBER, VARCHAR, DATE
> fields. Am I better off importing into a Hive table I define and then
> exporting into Oracle from there? Or do I just need to do some export
> formatting in my Sqoop export statement?
>
> Any other intel you'd need to make a recommendation?
>
> Thanks in advance,
> Nick
>
> Sent from my iPhone****
>
> ** **
>
>   ** **
>

Mime
View raw message