Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop import Format Issue


Copy link to this message
-
Re: Sqoop import Format Issue
Ya Abhijeet, I removed '\0001' so its working fine but still the issue is
database id field as till I pass the *id* parameter value in the data file
it works well but I can't hold of the id value and unlike Mysql, Postgres
don't even support null values which can be passed for the auto increment
value.
On Mon, Jan 21, 2013 at 5:23 PM, abhijeet gaikwad <[EMAIL PROTECTED]>wrote:

> Your fields are terminated by comma. Your command directs otherwise -
> '\0000'.
>
> Thanks,
> Abhijeet
> On Jan 21, 2013 2:13 PM, "Vineet Mishra" <[EMAIL PROTECTED]>
> wrote:
>
>>
>> On Mon, Jan 21, 2013 at 2:08 PM, abhijeet gaikwad <[EMAIL PROTECTED]
>> > wrote:
>>
>>> and table sche
>>
>>
>> Ya sure,
>> here is the data rows,
>>
>> 28.00,10005,\0001
>> 403.71,90210,\0001
>>
>> I even tried with single inverted values, but not positivity.
>>
>> and this is the Table Schema,
>>
>> * Column |     Type     | Modifiers | Storage | Description
>> --------+--------------+-----------+---------+-------------
>>  volume | numeric(8,2) |           | main    |
>>  zip    | integer      |           | plain   |
>> *
>>
>>
>> --
>> Thanks and Regards
>> Vineet Mishra
>>
>
--
Thanks and Regards
Vineet Mishra