Error 2:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO hotel_revenue_octopus_hotel_info FROM '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data' USING DELIMITERS '\\001smb://001','\\n'smb://n'"
could not open file '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data': No such file or directory
在 2017年1月10日，下午4:14，Stefan Manegold mailto:Stefan.Manegold@cwi.nl> 写道：
Not strange at all. Quotes are missing around file path (string).
Sent from my Samsung Galaxy smartphone.
-------- Original message --------
From: "ping gao 高平(0)" mailto:ping.gao@corp.elong.com>
Date: 1/10/17 08:07 (GMT+01:00)
To: Communication channel for MonetDB users mailto:users-list@monetdb.org>
Subject: COPY INFO ERROR
Hi ALL
I encountered a problem using a COPY INFO. Strange thing is my IP is 59, execute the following statement is not a problem on the machine.So freak!
IP:192.168.110.59 (Database Server)
[hotel-revenue-online@bjs-hotel-RevenueCompute-02 data_visual_monetdb]$ mclient -u monetdb -d hotel-revenue -s "COPY 2 RECORDS INTO hotel_revenue_octopus_booking_order FROM '/home/hotel-revenue-online/ping.gao/data_visual_monetdb/hotel_revenue_octopus_booking_order.sql' USING DELIMITERS ',','\\n'smb://n'"
password:
2 affected rows
IP:192.168.110.179
Error 1:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO hotel_revenue_octopus_hotel_info FROM /home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data USING DELIMITERS '\\001','\\n'smb://001','//n'”
syntax error, unexpected '/', expecting STRING or '(' or STDIN in: "copy 2 records into hotel_revenue_octopus_hotel_info from /“
Error 2:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO hotel_revenue_octopus_hotel_info FROM '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data' USING DELIMITERS '\\001smb://001','\\n'smb://n'"
could not open file '/home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data': No such file or directory
Error 3:
[hotel-revenue-online@bjs-hotel-RevenueCompute-01 datavisual_service]$ mclient -h 192.168.110.59 -p 50001 -d hotel-revenue -s "COPY 2 RECORDS INTO hotel_revenue_octopus_hotel_info FROM STDIN DELIMITERS '\\001','\\n'smb://001','//n'" - < /home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data
2 affected rows
syntax error, unexpected sqlINT in: "90564318"
_______________________________________________
users-list mailing list
users-list@monetdb.orgmailto:users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
ping gao 高平(0)
Stefan Manegold