You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "Bulvik, Noam" <No...@teoco.com> on 2015/03/02 14:07:51 UTC

Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter

When using CSV bulk loader with dates I am getting this error Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter




Table DDL:

create table TS_TEST

( ID                 integer   not null,

  REC_TIMESTAMP      timestamp not null,

  REC_TIMESTAMP_STR  varchar   not null

  CONSTRAINT TS_TEST_PK PRIMARY KEY (ID,REC_TIMESTAMP,REC_TIMESTAMP_STR) )

COMPRESSION='SNAPPY';



Input File Data:

1,2015-03-01 00:00:00.111,2015-03-01 00:00:00.111

2,2015-03-01 01:00:00.222,2015-03-01 01:00:00.222

3,2015-03-01 02:00:00.333,2015-03-01 02:00:00.333

4,2015-03-01 03:00:00.444,2015-03-01 03:00:00.444





Information in this e-mail and its attachments is confidential and privileged under the TEOCO confidentiality terms that can be reviewed here<http://www.teoco.com/email-disclaimer>.

RE: Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter

Posted by "Bulvik, Noam" <No...@teoco.com>.
I am using CDH 5.3.0

I do not have too much more in the log :
….
15/03/02 15:20:13 INFO mapreduce.Job: The url to track the job: http://dc50-dev-bd15:8088/proxy/application_1425226676791_0083/
15/03/02 15:20:13 INFO mapreduce.Job: Running job: job_1425226676791_0083
15/03/02 15:21:00 INFO mapreduce.Job: Job job_1425226676791_0083 running in uber mode : false
15/03/02 15:21:00 INFO mapreduce.Job:  map 0% reduce 0%
15/03/02 15:21:24 INFO mapreduce.Job: Task Id : attempt_1425226676791_0083_m_000000_0, Status : FAILED
Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter;
15/03/02 15:21:35 INFO client.HConnectionManager$HConnectionImplementation: Closing zookeeper sessionid=0x24bd5223c471259
15/03/02 15:21:35 INFO zookeeper.ZooKeeper: Session: 0x24bd5223c471259 closed
15/03/02 15:21:35 INFO zookeeper.ClientCnxn: EventThread shut down

From: Gabriel Reid [mailto:gabriel.reid@gmail.com]
Sent: Monday, March 2, 2015 3:13 PM
To: user@phoenix.apache.org
Subject: Re: Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter

Is there more of a stack trace you could post around the error?

I'm guessing that this is something along the lines of NoSuchMethodException. Could you also post some info on your environment? Which version of Hadoop and HBase are you using? Is there an alternate version of joda-time on your classpath somewhere (e.g. in your Hadoop lib directory)?


On Mon, Mar 2, 2015 at 2:09 PM Bulvik, Noam <No...@teoco.com>> wrote:
When using CSV bulk loader with dates I am getting this error Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter




Table DDL:

create table TS_TEST

( ID                 integer   not null,

  REC_TIMESTAMP      timestamp not null,

  REC_TIMESTAMP_STR  varchar   not null

  CONSTRAINT TS_TEST_PK PRIMARY KEY (ID,REC_TIMESTAMP,REC_TIMESTAMP_STR) )

COMPRESSION='SNAPPY';



Input File Data:

1,2015-03-01 00:00:00.111,2015-03-01 00:00:00.111

2,2015-03-01 01:00:00.222,2015-03-01 01:00:00.222

3,2015-03-01 02:00:00.333,2015-03-01 02:00:00.333

4,2015-03-01 03:00:00.444,2015-03-01 03:00:00.444





Information in this e-mail and its attachments is confidential and privileged under the TEOCO confidentiality terms that can be reviewed here<http://www.teoco.com/email-disclaimer>.

Re: Error: org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter

Posted by Gabriel Reid <ga...@gmail.com>.
Is there more of a stack trace you could post around the error?

I'm guessing that this is something along the lines of
NoSuchMethodException. Could you also post some info on your environment?
Which version of Hadoop and HBase are you using? Is there an alternate
version of joda-time on your classpath somewhere (e.g. in your Hadoop lib
directory)?


On Mon, Mar 2, 2015 at 2:09 PM Bulvik, Noam <No...@teoco.com> wrote:

>  When using CSV bulk loader with dates I am getting this error Error:
> org.joda.time.format.DateTimeFormatter.withZoneUTC()Lorg/joda/time/format/DateTimeFormatter
>
>
>
>
>
>
>
> *Table DDL:*
>
> create table TS_TEST
>
> ( ID                 integer   not null,
>
>   REC_TIMESTAMP      timestamp not null,
>
>   REC_TIMESTAMP_STR  varchar   not null
>
>   CONSTRAINT TS_TEST_PK PRIMARY KEY (ID,REC_TIMESTAMP,REC_TIMESTAMP_STR) )
>
> COMPRESSION='SNAPPY';
>
>
>
> *Input File Data:*
>
> 1,2015-03-01 00:00:00.111,2015-03-01 00:00:00.111
>
> 2,2015-03-01 01:00:00.222,2015-03-01 01:00:00.222
>
> 3,2015-03-01 02:00:00.333,2015-03-01 02:00:00.333
>
> 4,2015-03-01 03:00:00.444,2015-03-01 03:00:00.444
>
>
>
>
>
>
>
>
>  Information in this e-mail and its attachments is confidential and
> privileged under the TEOCO confidentiality terms that can be reviewed here
> <http://www.teoco.com/email-disclaimer>.
>