version: 1.0.0-beta.3
SQL:SELECT * FROM ( select count(1) count from t_ads_retail_detail_daily where tenant_id = $tenant_id$ and store_id = $store_id$ and billtime >= $today$ and retail_tot_amt_actual > 0 ) AS DATART_VTABLE LIMIT 0, 1000
DB: CLICKHOUSE
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "count" at line 1, column 37.
Was expecting one of:
"AS" ...
"EXCEPT" ...
"FETCH" ...
"FILTER" ...
"FROM" ...
"INTERSECT" ...
"LIMIT" ...
"OFFSET" ...
"ORDER" ...
"OVER" ...
"MINUS" ...
"UNION" ...
"WITHIN" ...
<QUOTED_STRING> ...
")" ...
"," ...
<BRACKET_QUOTED_IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<HYPHENATED_IDENTIFIER> ...
...
<UNICODE_QUOTED_IDENTIFIER> ...
"." ...
"NOT" ...
"IN" ...
"<" ...
"<=" ...
">" ...
">=" ...
"=" ...
"<>" ...
"!=" ...
"BETWEEN" ...
"LIKE" ...
"SIMILAR" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"CONTAINS" ...
"OVERLAPS" ...
"EQUALS" ...
"PRECEDES" ...
"SUCCEEDS" ...
"MULTISET" ...
"&" ...
"[" ...