1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | The VoltDB scripts are not in your PATH. For ease of use, add the VoltDB bin directory: /opt/voltdb/bin to your PATH. ----------------------------------------------------------- Command Line Configuration ----------------------------------------------------------- contestants = 6 displayinterval = 5 duration = 120 latencyreport = false maxvotes = 2 password = ratelimit = 2147483647 servers = localhost:21212 statsfile = user = warmup = 5 ----------------------------------------------------------- Setup & Initialization ----------------------------------------------------------- Connecting to VoltDB... Connected to VoltDB node at: localhost:21212. |
1 2 3 4 | SELECT a.contestant_name AS contestant_name , a.contestant_number AS contestant_number , SUM(b.num_votes) AS total_votes FROM v_votes_by_contestant_number_state AS b , contestants AS a WHERE a.contestant_number = b.contestant_number GROUP BY a.contestant_name , a.contestant_number ORDER BY total_votes DESC , contestant_number ASC , contestant_name ASC; |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |