2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:336 : Using project: affiliate_report 2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:337 : The original query: SELECT sum(counter) FROM AFFILIATE_VALID_CLICK WHERE dt >= '2016-12-01' AND dt < '2016-12-19' AND advertiser_id IN (803, 804, 982, 966, 967, 664, 939, 911, 632, 658, 694, 727, 856, 762, 831, 606, 703) 2016-12-20 01:42:12,526 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:440 : The corrected query: SELECT sum(counter) FROM AFFILIATE_VALID_CLICK WHERE dt >= '2016-12-01' AND dt < '2016-12-19' AND advertiser_id IN (803, 804, 982, 966, 967, 664, 939, 911, 632, 658, 694, 727, 856, 762, 831, 606, 703) LIMIT 50000 2016-12-20 01:42:12,535 ERROR [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] runtime.CalciteException:59 : org.apache.calcite.sql.validate.SqlValidatorException: Table 'AFFILIATE_VALID_CLICK' not found 2016-12-20 01:42:12,535 ERROR [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] runtime.CalciteException:61 : org.apache.calcite.runtime.CalciteContextException: From line 1, column 27 to line 1, column 47: Table 'AFFILIATE_VALID_CLICK' not found
上一封 下一封 « 返回
