unifiedExpr应该怎么拼接or呢

执行下列代码:

data=table(1..6 as id1,7..12 as id2)
whereCodes = [<id1=2>,<id1=5>,<id2=12>]
delCodes=unifiedExpr(whereCodes,take(expr{,or,},whereCodes.size()-1))
sql(sqlCol("*"),data,delCodes).eval();

报错:::evaluate(sql(sqlCol("*"), data, delCodes)) => Please use logical expressions to represent filtering criteria.


请先 登录 后评论

1 个回答

wale

不需要expr,改成如下即可:

data=table(1..6 as id1,7..12 as id2)
whereCodes = [<id1=2>,<id1=5>,<id2=12>]
delCodes=unifiedExpr(whereCodes,take(or,whereCodes.size()-1))
sql(sqlCol("*"),data,delCodes).eval();

输出:

id1	id2
2	8
5	11
6	12

请先 登录 后评论