Re: [sqoop-user] Problem with importing date fields from Netezza

["arvind@cloudera.com" <ar...@cloudera.com>]

[Moving the conversation to sqoop-user@incubator.apache.org. Please
subscribe to this mailing list.]

Hi,

Apologies for the delayed response. Can you give us more details:

- The datatype defined in Netezza that is not getting properly received.
- The version of Sqoop you are using
- And if you are using vanilla Sqoop or with a specialized connector
for Netezza.

FWIW - I just did a test with a table containing timestamp datatype
and it seems to have carried over correctly to Hive.

Thanks,
Arvind

On Sun, Sep 4, 2011 at 4:13 AM, inbal <in...@gmail.com> wrote:
> Hi,
> When trying to import date fields from Netezza to Hive, the data is
> passed partially - The hh:mm:ss part is not recieved.
> For example - '1999-12-27 00:00:00' is recieved as '1999-12-27'
>
> How can it be fixed?
>
> Thank you very much
>
> --
> 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.
>