sorry ,update last mail sql:select t.b, count (*) the from (select distinct columns [4] a, columns[5] m, columns [6] b, columns[7] c, columns [8] d from hdfs.`/ott_raw_data/8/2016/12/20161202.txt`) t group by t.b
2016-12-21 19:19 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。 > > 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。 >> > >
