语句块

Select,  Alias, From,  Where, Parameter, Group By, Order By

常见函数

Count, Count(Distinct A), Sum, Max, Min, Avg

特殊函数

Range, Product, Median, Quartile, Mode, SumSQ, PthPercentile, Variance, PopulationVariance, StandardDeviation, StandardError, PopulationStandardDeviation, SumWT, WeightAvg, Covariance, Correlation

四则运算及函数

Sqrt, Sqr, ParseInt, ParseFloat, Abs, Substring, (a+b-c)*b/c

日期函数

Year, Quarter, Month, Week, Day, Hour, Minute, Second, Quarterpart, Monthpart, Weekpart, Daypart, Weekday, Hourpart, Minutepart, Secondpart

Join

不支持，由于基于主题的数据集市，Join会影响性能

SubQuery

暂不支持