drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parth Chandra (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2401) Value 0 for monthOfYear must be in the range [1,12]
Date Mon, 06 Apr 2015 20:46:12 GMT

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

Parth Chandra commented on DRILL-2401:
--------------------------------------

[~cchang@maprtech.com] Can you try to reproduce this.

> Value 0 for monthOfYear must be in the range [1,12]
> ---------------------------------------------------
>
>                 Key: DRILL-2401
>                 URL: https://issues.apache.org/jira/browse/DRILL-2401
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 0.7.0
>         Environment: Sandbox, SE cluster
>            Reporter: Sudhakar Thota
>            Assignee: Chun Chang
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: month-00-drill-MapR-DB.rtf
>
>
> 0: jdbc:drill:zk=10.10.15.10:5181,10.10.15.11> select cast(row_key as varchar(20))
as order_id, cast(t.CF1.`clerk` as varchar(20)) as order_clerk, cast(t.CF1.orderstatus as
varchar(20)) as ord_stat,cast(t.CF1.orderdate as date) ordrdt from m7thotas.orders t where
 cast(t.CF1.orderdate as date) BETWEEN cast('1996-01-10' as date) AND cast('1996-01-11' as
date) and cast(t.CF1.`clerk` as varchar(20))<>cast('Clerk#000000334' as varchar(20));
> .
> .
> .
> | 3592807    | Clerk#000000358 | O          | 1996-01-11 |
> | 6969024    | Clerk#000000185 | O          | 1996-01-10 |
> | 6973990    | Clerk#000000491 | O          | 1996-01-10 |
> | 6975170    | Clerk#000000493 | O          | 1996-01-10 |
> | 6975462    | Clerk#000000352 | O          | 1996-01-11 |
> | 6978503    | Clerk#000000482 | O          | 1996-01-11 |
> | 6979654    | Clerk#000000389 | O          | 1996-01-10 |
> | 5344355    | Clerk#000000653 | O          | 1996-01-11 |
> | 5351969    | Clerk#000000237 | O          | 1996-01-10 |
> | 5352003    | Clerk#000000756 | O          | 1996-01-10 |
> | 3608519    | Clerk#000000384 | O          | 1996-01-10 |
> Query failed: Query failed: Failure while running fragment., Value 0 for monthOfYear
must be in the range [1,12] [ 2b41018b-b35e-42a9-bd4e-0307e582b718 on se-node11.se.lab:31010
]
> [ 2b41018b-b35e-42a9-bd4e-0307e582b718 on se-node11.se.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> 	at sqlline.SqlLine.print(SqlLine.java:1809)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> 	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:889)
> 	at sqlline.SqlLine.begin(SqlLine.java:763)
> 	at sqlline.SqlLine.start(SqlLine.java:498)
> 	at sqlline.SqlLine.main(SqlLine.java:460)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message