sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathleen Ting <kathl...@cloudera.com>
Subject Re: sqoop exporting from hdfs to postgresql, using --staging-table option
Date Thu, 26 Jan 2012 01:01:58 GMT
Srinivas, as it happens, the Cloudera Connector for Teradata supports
staging tables. It is freely available here:
https://ccp.cloudera.com/display/con/Cloudera+Connector+for+Teradata+Download
.

Regards, Kathleen

On Wed, Jan 25, 2012 at 3:36 PM, Srinivas Surasani <vasajb@gmail.com> wrote:

> Hi Kathleen,
>
> Same issue with Teradata.
>
>
> Srinivas --
>
>
> On Mon, Jan 23, 2012 at 8:26 PM, Kathleen Ting <kathleen@cloudera.com>wrote:
>
>> Hi Weihua -
>>
>> Unfortunately, the generic jdbc manager does not support staging.
>> As a result, I've filed https://issues.apache.org/jira/browse/SQOOP-431on your behalf.
>>
>> Regards, Kathleen
>>
>>
>> On Mon, Jan 23, 2012 at 3:10 PM, Weihua Zhu <wzhu@adconion.com> wrote:
>>
>>> Hi Guys,
>>>
>>>   Good afternoon!
>>>   I have a question. I was trying to sqoop exporting from hdfs to
>>> postgresql, using --staging-table options due to transactions
>>> consideration. But it gives me error below.
>>>   I am wondering if the staging_able is supported for
>>> GenericJdbcManager? if not, what kind of manager should I use?
>>>   Thanks very much!
>>>
>>>  -Weihua
>>>
>>> error message:
>>>
>>> 12/01/23 15:00:39 ERROR tool.ExportTool: Error during export: The active
>>> connection manager (org.apache.sqoop.manager.GenericJdbcManager) does not
>>> support staging of data for export. Please retry without specifying the
>>> --staging-table option.
>>>
>>>
>>>
>>
>

Mime
View raw message