| -- This file is automatically generated. You should know what you did if you want to edit this | |
| -- !sql -- | |
| test_rollup_agg AGG_KEYS siteid INT No true \N true | |
| citycode SMALLINT No true \N true | |
| username VARCHAR(32) No true \N true | |
| pv BIGINT No false 0 SUM true | |
| uv BIGINT No false 0 SUM true | |
| vv BIGINT Yes false 0 SUM true | |
| rollup_city AGG_KEYS citycode SMALLINT No true \N true | |
| pv BIGINT No false 0 SUM true | |
| vv BIGINT Yes false 0 SUM true | |
| -- !sql -- | |
| 1 200 | |