Aditaya,
Thanks for working on this.
Here is drill bit log.
2015-02-13 14:28:51,498 [2b218572-dd78-a538-e9bb-547410c18cea:frag:1:0] ERROR
o.a.d.e.w.f.AbstractStatusReporter - Error
69c63002-9e29-471a-aacb-a073a421d37f: Failure while running fragment.
org.joda.time.IllegalFieldValueException: Value 0 for monthOfYear must be in
the range [1,12]
at
org.joda.time.field.FieldUtils.verifyValueBounds(FieldUtils.java:236)
~[joda-time-2.3.jar:2.3]
at
org.joda.time.chrono.BasicChronology.getDateMidnightMillis(BasicChronology.java:613)
~[joda-time-2.3.jar:2.3]
at
org.joda.time.chrono.BasicChronology.getDateTimeMillis(BasicChronology.java:159)
~[joda-time-2.3.jar:2.3]
at
org.joda.time.chrono.AssembledChronology.getDateTimeMillis(AssembledChronology.java:120)
~[joda-time-2.3.jar:2.3]
at
org.apache.drill.exec.expr.fn.impl.StringFunctionHelpers.memGetDate(StringFunctionHelpers.java:246)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.expr.fn.impl.StringFunctionHelpers.getDate(StringFunctionHelpers.java:203)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.test.generated.FiltererGen379.doEval(FilterTemplate2.java:90)
~[na:na]
at
org.apache.drill.exec.test.generated.FiltererGen379.filterBatchNoSV(FilterTemplate2.java:95)
~[na:na]
at
org.apache.drill.exec.test.generated.FiltererGen379.filterBatch(FilterTemplate2.java:68)
~[na:na]
at
org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.doWork(FilterRecordBatch.java:82)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:93)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:57)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.innerNext(RemovingRecordBatch.java:96)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:99)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:89)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:132)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:142)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:118)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:97)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:114)
~[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_75]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_75]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
2015-02-13 14:28:51,750 [2b218572-dd78-a538-e9bb-547410c18cea:frag:0:0] ERROR
o.a.d.e.p.i.ScreenCreator$ScreenRoot - Error
7497a04b-dd87-4e07-b6fb-008bb4707bf3: Query stopped.
org.apache.drill.common.exceptions.DrillException: Undefined failure occurred.
at
org.apache.drill.exec.work.ErrorHelper.logAndConvertError(ErrorHelper.java:68)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.work.ErrorHelper.logAndConvertMessageError(ErrorHelper.java:50)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:103)
[drill-java-exec-0.7.0-SNAPSHOT-rebuffed.jar:0.7.0-SNAPSHOT]
Thanks
Sudhakar Thota
On Feb 13, 2015, at 1:28 PM, Sudhakar Thota <[email protected]> wrote:
> Andries,
>
> Good thinking.
>
> It works on csv file but not with MapR-DB table.
>
>
> Here is the file showing that.
>
> <orders-csv-DateRangeQery.rtf>
>
>
> Thanks
> Sudhakar Thota
>
> On Feb 13, 2015, at 8:14 AM, Andries Engelbrecht <[email protected]>
> wrote:
>
>> Does the CSV file work?
>> Just not when in MaprDB?
>> If so try varchar before to date.
>>
>> --Andries
>>
>>
>>
>>> On Feb 13, 2015, at 8:06 AM, Sudhakar Thota <[email protected]>h wrote:
>>>
>>> Andries,
>>>
>>> The order date looks good I think as per the format.
>>>
>>>> | 3421989 | Clerk#000000601 | O | 1996-01-10 |
>>>> | 3422915 | Clerk#000000058 | O | 1996-01-11 |
>>>> | 3423106 | Clerk#000000266 | O | 1996-01-11 |
>>>
>>> If you look at the output, it pulls the records for some and fails later
>>> with that error. I verified the dataset for that 00 in month, I dint find
>>> it. I think it is missed some where in translation and transit.
>>>
>>> Thanks
>>> Sudhakar Thota
>>>
>>>
>>>
>>> On Feb 12, 2015, at 10:21 PM, Andries Engelbrecht
>>> <[email protected]> wrote:
>>>
>>>>> | 3421989 | Clerk#000000601 | O | 1996-01-10 |
>>>>> | 3422915 | Clerk#000000058 | O | 1996-01-11 |
>>>>> | 3423106 | Clerk#000000266 | O | 1996-01-11 |
>>>
>
