No that should have no influence.
Do you have the users already in your db?
Do you have and index on :ThanhVien(id) and :DiaDiem(id) ?
try
> LOAD CSV FROM "file:E:/binhluan.tsv" AS line FIELDTERMINATOR '\t'
with line limit 100
return line;
and
> LOAD CSV FROM "file:E:/binhluan.tsv" AS line FIELDTERMINATOR '\t'
return count(*);
> LOAD CSV FROM "file:E:/binhluan.tsv" AS line FIELDTERMINATOR '\t'
with line limit 100
> MATCH ( a:`ThanhVien`{ id:line[4] } ), ( b:`DiaDiem`{ id:line[2] } )
return a,b
Am 09.07.2014 um 06:40 schrieb Nguyen Minh Nhut <[email protected]>:
> Hi Micheal!
> I have a .tsv file. I clean all the characters ' and " in that file.
> When i run the load csv command then the console load it, and then do not
> thing :
>
> USING PERIODIC COMMIT 100
> LOAD CSV FROM "file:E:/binhluan.tsv" AS line FIELDTERMINATOR '\t'
> MATCH ( a:`ThanhVien`{ id:line[4] } ), ( b:`DiaDiem`{ id:line[2] } )
> CREATE (a)-[:BinhLuan{ NoiDung:line[1]}]->(b);
>
> I don't know why, is this b/c content of line[1] is too big.
>
>
> On Sat, Jul 5, 2014 at 7:45 AM, Nguyen Minh Nhut
> <[email protected]> wrote:
> OK Thks!
>
>
>
> On Sat, Jul 5, 2014 at 3:25 AM, Michael Hunger
> <[email protected]> wrote:
> I just deleted all quotes and the emojii smileys ;)
>
> Sent from mobile device
>
> Am 04.07.2014 um 17:10 schrieb Nguyen Minh Nhut
> <[email protected]>:
>
>> I have escaped all the single quotes by double them and delete all the
>> smileys like you said. Now when i count(*), it reuturns 30375 but not 41879
>> nodes.
>> Could you tell me, what characters I should check that affect my results.
>> Sorry about my bad English.
>>
>>
>>
>> On Fri, Jul 4, 2014 at 5:28 PM, Michael Hunger
>> <[email protected]> wrote:
>> You have several single quotes in your file, which cause our csv reader to
>> continue to read until it finds the next quote.
>>
>> You have to escape those by doubling them.
>>
>> Many of them are smileys like this ":)
>>
>> LOAD CSV FROM "file:///Users/mh/Downloads/thanhvien.csv" AS line return
>> count(*);
>>
>> +----------+
>>
>> | count(*) |
>>
>> +----------+
>>
>> | 41881 |
>>
>> +----------+
>>
>> 1 row
>>
>>
>>
>> On Fri, Jul 4, 2014 at 4:57 AM, Nguyen Minh Nhut
>> <[email protected]> wrote:
>> Hi good guys!
>> My .csv file have 41879 nodes. When i run the load csv file it just create
>> 13415 nodes.
>>
>> This is my cypher command:
>>
>> USING PERIODIC COMMIT 1000 LOAD CSV FROM "file:E:/thanhvien.csv" AS line
>> create (u:ThanhVien { id: line[0], HoTen : line[1] , GioiTinh: line[2],
>> NgaySinh: line[3] , GioiThieuBanThan: line[4], DienThoai: line[5] , DiaChi:
>> line[6] , Email: [7] , NgheNghiep: line[7] , CoQuan: line[8] , SoThichKhac:
>> line[9] , Quan: line[10] , TinhTrangHonNhan: line[11] , HinhDaiDien:
>> line[12] } );
>>
>> Don't know why!
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "Neo4j" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/neo4j/-S1Xdh4ZkrE/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to a topic in the Google
> Groups "Neo4j" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/neo4j/-S1Xdh4ZkrE/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
