phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "G.S.Vijay Raajaa" <gsvijayraa...@gmail.com>
Subject Insertion failiure
Date Fri, 14 Feb 2014 10:33:46 GMT
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

Mime
View raw message