drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 林春晓 <lincx0...@gmail.com>
Subject Re: drill return count(*) is wrong
Date Wed, 21 Dec 2016 11:19:53 GMT
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 林春晓 <lincx0128@gmail.com>:

> 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。
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message