HQL常见错误及处理方式

1. 错误：Only numeric type arguments are accepted but string was passed as parameter 1.
   原因：是因为我使用函数做了这样一个操作：

percentile_approx(fst_shlv_time, array(0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,0.99,0.999)) as fst_shlv_time_distrib

而fst_shlv_time的类型是string，所以报错

2. 错误：ParseException line 10:7 missing EOF at ‘by’ near ‘group’
   原因：一般是因为没有在select from的子查询后面加别名
   参考链接：
   https://blog.csdn.net/syfly007/article/details/18225327