drill-dev 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:28:01 GMT
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 林春晓 <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。
>
> 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