Hello, I upgrade to V1.9.0 from V1.4.0 today, found that using the query statements (select t.b, count (1) the from (select distinct columns [4] a, columns, [5] m columns [6] b, columns, [7] c columns [8] d from hdfs.` /2016/12/20161202.txt `) t group by t.b) return all statistics is 1, the result is actually wrong. how to solve the problem？thanks!
ps: the columns[6] is time type, for example: 00:00:12。 2016-12-21 19:17 GMT+08:00 林春晓 <[email protected]>: > Hello, > I upgrade to V1.9.0 from V1.4.0 today, found that using the query > statements (select t.b, count (1) the from (select distinct columns [4] a, > columns, [5] m columns [6] b, columns, [7] c columns [8] d from hdfs.` > /2016/12/20161202.txt `) t group by t.b) return all statistics is 1, the > result is actually wrong. how to solve the problem？thanks! > > ps: the columns[6] is time type, for example: 00:00:12。 >
