You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sudhakar Thota (JIRA)" <ji...@apache.org> on 2015/03/06 22:49:39 UTC
[jira] [Commented] (DRILL-2401) Value 0 for monthOfYear must be in
the range [1,12]
[ https://issues.apache.org/jira/browse/DRILL-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14350967#comment-14350967 ]
Sudhakar Thota commented on DRILL-2401:
---------------------------------------
I tried to attache orders.tbl, system doesn't allow 179MB file. Please let me know if you want that file.
> 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: Daniel Barclay (Drill)
> Priority: Minor
> 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)