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

Switch to Plain View
Sqoop, mail # user - Sqoop import Format Issue


+
Vineet Mishra 2013-01-18, 11:20
+
Vineet Mishra 2013-01-21, 11:20
+
Jarek Jarcec Cecho 2013-01-22, 00:49
+
Vineet Mishra 2013-01-21, 07:31
+
abhijeet gaikwad 2013-01-21, 08:38
+
Vineet Mishra 2013-01-21, 08:43
+
abhijeet gaikwad 2013-01-21, 11:53
Copy link to this message
-
Re: Sqoop import Format Issue
Vineet Mishra 2013-01-21, 12:01
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
+
Vineet Mishra 2013-01-18, 12:31
+
abhijeet gaikwad 2013-01-18, 12:41
+
abhijeet gaikwad 2013-01-18, 11:50
+
Vineet Mishra 2013-01-18, 12:06