You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2015/06/11 18:01:02 UTC
[jira] [Created] (DRILL-3277) SUM(CAST(columns[0] AS INT))
OVER(...) gives wrong results
Deneche A. Hakim created DRILL-3277:
---------------------------------------
Summary: SUM(CAST(columns[0] AS INT)) OVER(...) gives wrong results
Key: DRILL-3277
URL: https://issues.apache.org/jira/browse/DRILL-3277
Project: Apache Drill
Issue Type: Sub-task
Reporter: Deneche A. Hakim
Assignee: Deneche A. Hakim
The following query return wrong results, there is a difference in actual vs expected results. Expected results were generated on Postgres 9.3
{noformat}
SELECT
SUM(cast( columns[0] as INT ))
OVER(PARTITION BY cast( columns[2] as CHAR(2)))
FROM `allData.csv`;
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)