[
https://issues.apache.org/jira/browse/PIG-3953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009350#comment-14009350
]
Ben Vermeersch commented on PIG-3953:
-------------------------------------
That should fix the problem, yes, but I don't know for sure if it won't
introduce other issues.
> Ordering on date doesn't work
> -----------------------------
>
> Key: PIG-3953
> URL: https://issues.apache.org/jira/browse/PIG-3953
> Project: Pig
> Issue Type: Bug
> Affects Versions: 0.12.0
> Reporter: Ben Vermeersch
> Fix For: 0.12.1
>
>
> I get the following error when trying to order by datetime datatype:
> java.lang.Exception: java.lang.NoSuchMethodError:
> org.joda.time.DateTime.compareTo(Lorg/joda/time/ReadableInstant;)I
> at
> org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:403)
> Caused by: java.lang.NoSuchMethodError:
> org.joda.time.DateTime.compareTo(Lorg/joda/time/ReadableInstant;)I
> at
> org.apache.pig.backend.hadoop.DateTimeWritable$Comparator.compare(DateTimeWritable.java:105)
> at
> org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.PigDateTimeRawComparator.compare(PigDateTimeRawComparator.java:82)
> at
> org.apache.hadoop.mapred.MapTask$MapOutputBuffer.compare(MapTask.java:1248)
> at org.apache.hadoop.util.QuickSort.sortInternal(QuickSort.java:74)
> at org.apache.hadoop.util.QuickSort.sort(QuickSort.java:63)
> at
> org.apache.hadoop.mapred.MapTask$MapOutputBuffer.sortAndSpill(MapTask.java:1582)
> at
> org.apache.hadoop.mapred.MapTask$MapOutputBuffer.flush(MapTask.java:1467)
> at
> org.apache.hadoop.mapred.MapTask$NewOutputCollector.close(MapTask.java:699)
> at org.apache.hadoop.mapred.MapTask.closeQuietly(MapTask.java:1997)
> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:773)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:339)
> at
> org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:235)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Can be reproduced using the following dates.txt:
>
> {quote}
> 12-01-2013
> 13-04-2014
> 12-01-2013
> 01-01-2012
> 02-12-2011
> {quote}
> And the following script:
> {quote}
> records = LOAD 'dates.txt' as (date:chararray);
> dates = foreach records generate ToDate(date, 'dd-MM-yyyy');
> orderedDates = order dates by $0;
> DUMP orderedDates;
> {quote}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
