Return-Path: 
 <issues-return-740-apmail-drill-issues-archive=drill.apache.org@drill.incubator.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id DA96411790
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Tue,  3 Jun 2014 21:24:22 +0000 (UTC)
Received: (qmail 65934 invoked by uid 500); 3 Jun 2014 21:24:22 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 65910 invoked by uid 500); 3 Jun 2014 21:24:22 -0000
Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.incubator.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.incubator.apache.org>
List-Post: <mailto:issues@drill.incubator.apache.org>
List-Id: <issues.drill.incubator.apache.org>
Reply-To: dev@drill.incubator.apache.org
Delivered-To: mailing list issues@drill.incubator.apache.org
Received: (qmail 65901 invoked by uid 99); 3 Jun 2014 21:24:22 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jun 2014 21:24:22 +0000
X-ASF-Spam-Status: No, hits=-2000.7 required=5.0
	tests=ALL_TRUSTED,RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 03 Jun 2014 21:24:21 +0000
Received: (qmail 65677 invoked by uid 99); 3 Jun 2014 21:24:01 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jun 2014 21:24:01 +0000
Date: Tue, 3 Jun 2014 21:24:01 +0000 (UTC)
From: "Mehant Baid (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12708633.1397599670228.67828.1401830641705@arcas>
In-Reply-To: <JIRA.12708633.1397599670228@arcas>
References: <JIRA.12708633.1397599670228@arcas>
Subject: [jira] [Commented] (DRILL-526) Parse error for ROUND function
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


    [ https://issues.apache.org/jira/browse/DRILL-526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14017173#comment-14017173 ] 

Mehant Baid commented on DRILL-526:
-----------------------------------

Seems its fixed as part of p1 functions.
select round(10.34) from dfs.`/tmp/input.json`;
+------------+
|   EXPR$0   |
+------------+
| 10.0       |
+------------+


> Parse error for ROUND function
> ------------------------------
>
>                 Key: DRILL-526
>                 URL: https://issues.apache.org/jira/browse/DRILL-526
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>            Reporter: Krystal
>            Assignee: Krystal
>
> Drill fails to parse query with ROUND function:
> 0: jdbc:drill:schema=dfs> select round(10.34) as col from dfs.`voter` where rownum = 10;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "b098032a-6b6c-4720-8326-08f69210ec08"
> endpoint {
>   address: "qa-node57.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 19 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 19 ] < SqlValidatorException:[ No match found for function signature round(<NUMERIC>) ]"
> ]
> Error: exception while executing query (state=,code=0)



--
This message was sent by Atlassian JIRA
(v6.2#6252)