Hi, I was exploring the sample scripts for loading csv data into phoenix. i happen to face the following issue:
1) The web_stat.csv, web_stat.sql,web_stat_queries.stat was initially used to create the table web_stat and was loaded with the csv data. 2) I modified the sql file to create a duplicate table called web1 and I use the same input file ( web_stat.csv) for loading data. I get no rows upserted. ./psql.sh localhost ../examples/web_stat.sql ../examples/web_stat.csv ../examples/web_stat_queries.sql no rows upserted Time: 1.503 sec(s) CSV Upsert complete. 39 rows upserted Time: 0.052 sec(s) no rows selected Time: 0.018 sec(s) no rows selected Time: 0.013 sec(s) no rows selected Time: 0.016 sec(s) 3) if i use a different csv file with the same content (web1.csv) , the insertion works. root@raajaa:/opt/phoenix-2.2.2-install/bin# ./psql.sh localhost ../examples/web_stat.sql ../examples/web1.csv ../examples/web_stat_queries.sql no rows upserted Time: 1.44 sec(s) CSV Upsert complete. 39 rows upserted Time: 0.097 sec(s) DOMAIN AVERAGE_CPU_USAGE AVERAGE_DB_USAGE ---------- ----------------- ---------------- Salesforce.com 260.7272 257.6363 Google.com 212.875 213.75 Apple.com 114.1111 119.5555 Time: 0.028 sec(s) DAY TOTAL_CPU_USAGE MIN_CPU_USAGE MAX_CPU_USAGE ------------------- --------------- ------------- ------------- 2013-01-01 00:00:00 35 35 35 2013-01-02 00:00:00 150 25 125 2013-01-03 00:00:00 88 88 88 2013-01-04 00:00:00 26 3 23 2013-01-05 00:00:00 550 75 475 2013-01-06 00:00:00 12 12 12 2013-01-08 00:00:00 345 345 345 2013-01-09 00:00:00 390 35 355 2013-01-10 00:00:00 345 345 345 2013-01-11 00:00:00 335 335 335 2013-01-12 00:00:00 5 5 5 2013-01-13 00:00:00 355 355 355 2013-01-14 00:00:00 5 5 5 2013-01-15 00:00:00 720 65 655 2013-01-16 00:00:00 785 785 785 2013-01-17 00:00:00 1590 355 1235 Time: 0.027 sec(s) HOST TOTAL_ACTIVE_VISITORS ---- --------------------- EU 150 NA 1 Time: 0.033 sec(s) Can you explain the process?? Regards, Vijay Raajaa G S
