GeezerVison is showing github.com — Support CAST clause · Issue #9 · JavaScriptor/js-sql-parser
Descriptioncode
select
concat(dsw_cluster_name,',',logic_pod_name) as event_obj,
concat(dsw_cluster_name,',',logic_pod_name, ' PFC STORM. 详情: ',
'流量突跃 ', cast(FLOW_RX_BPS_RATE100 as int), '%(RX)',
'; ', cast(FLOW_TX_BPS_RATE100 as int), '%(TX)',
'; PFC 突增 ', cast(PFC_RX_PPS_RATE*100 as int), '%(RECV)') as brief
from SOURCE_BASIC_EVENT_POD_FLOW_AND_PFC_TREND
where win_end >= '${yyyy-MM-dd HH:mm:ss - 2m}'
and win_end < '${yyyy-MM-dd HH:mm:ss}'
and PFC_RX_PPS_RATE >= 100
and (FLOW_RX_BPS_RATE <= -0.2 and FLOW_TX_BPS_RATE <= -0.2)
error like this
{message: "Parse error on line 4:↵...LOW_RX_BPS_RATE*100 as i…,', ')', 'AND', '&&', '||', 'OR', 'XOR', got 'AS'", hash: {…}} Activityalbin3 commented on Mar 6, 2018 changed the title [-]can not parse code like this[/-] [+]Support CAST clause[/+] on Mar 16, 2018
MetadataMetadataDevelopmentNo branches or pull requestsIssue actions
|