Not strange at all. Quotes are missing around file path (string).
Sent from my Samsung Galaxy smartphone.
-------- Original message --------From: "ping gao 高平(0)" Date: 1/10/17 08:07 (GMT+01:00) To: Communication channel for MonetDB users 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'"
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'”
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 '\\001','\\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'"
- < /home/hotel-revenue-online/datavisual_service/data_tmp/hotel_revenue_octopus_hotel_info.data
2 affected rows
syntax error, unexpected sqlINT in: "90564318"
