[DRILL-658] Add support for multiple distinct counts without a grouping key.

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Chun Chang
• Created: 07/May/14 21:41
• Updated: 05/May/15 17:42
• Resolved: 29/Apr/15 17:24

Description

postgres:

foodmart=# select count(distinct(c_int)), count(distinct(c_bigint)), count(distinct(c_float4)), count(distinct(c_float8)) from data;
count | count | count | count
----------------+------
21 | 23 | 22 | 20
(1 row)

drill:

0: jdbc:drill:schema=dfs> select count(distinct(c_int)), count(distinct(c_bigint)), count(distinct(c_float4)), count(distinct(c_float8)) from data;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "658d1c88-3968-457f-82e1-26c76ff7b54b"
endpoint {
address: "qa-node120.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < CannotPlanException:[ Node [rel#5852:Subset#33.PHYSICAL.SINGLETON([]).[]] could not be implemented;