遇到一个奇怪问题。
执行语句select value from loadTable("dfs://factors_value","factors_value") where factor in factors , date>=2017.12.31 and date <= 2018.01.07 pivot by date, stock,factor报错 select value from loadTable("dfs://factors_value", "factors_value") where factor in factors,date >= 2017.12.31 and date <= 2018.01.07 pivot by date,stock,factor => Column vector cannot be null.'
2017.12.31星期日,作为起始日期应该没问题,果然,原语句提取*数据没有问题,赋值给对象后再pivot by 也没问题,但是这样直接pivot by 就有问题。
另经测试其他年份..12.31到..01.07的区间同样报错,但..12.29到..01.07这样就正常,这是什么毛病呢?