drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudhakar Thota (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2401) Value 0 for monthOfYear must be in the range [1,12]
Date Fri, 06 Mar 2015 21:43:39 GMT
Sudhakar Thota created DRILL-2401:
-------------------------------------

             Summary: 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


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