version: 1.0.0-rc.1
SQL:SELECT * FROM ( SELECT brs.cost_center_name , DATE_FORMAT(brs.pay_time, '%Y-%m'), CONVERT(b.amount, DECIMAL(20,2)) FROM cmp_billings.bill_resource_schedule_daily brs inner join (SELECT min(id) as id, SUM(total_amount) AS 'amount' FROM cmp_billings.bill_resource_schedule_daily WHERE total_amount > 0.0001 and tenant_id= $TENANT_ID$ AND pay_time>= CONCAT(SUBSTRING(NOW(),1,8),'01 00:00:00') and cost_center_id is not null AND pay_time<= NOW() GROUP BY cost_center_id ,DATE_FORMAT(pay_time, '%Y-%m')) b on brs.id=b.id and brs.tenant_id= $TENANT_ID$ and brs.cost_center_id is not null AND brs.pay_time>= CONCAT(SUBSTRING(NOW(),1,8),'01 00:00:00') AND brs.pay_time<= NOW() ) AS DATART_VTABLE LIMIT 1000 OFFSET 0
DB: MYSQL
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "," at line 1, column 115.
Was expecting one of:
"USING" ...
"." ...
"NOT" ...
"IN" ...
"<" ...
"<=" ...
">" ...
">=" ...
"=" ...
"<>" ...
"!=" ...
"BETWEEN" ...
"LIKE" ...
"SIMILAR" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"CONTAINS" ...
"OVERLAPS" ...
"EQUALS" ...
"PRECEDES" ...
"SUCCEEDS" ...
"IMMEDIATELY" ...
"MULTISET" ...
"&" ...
"[" ...
"FORMAT" ...
"(" ...