You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by Peeyush Bishnoi <pe...@yahoo-inc.com> on 2008/01/31 15:57:26 UTC
Hbase Timestamp Error
Hi ,
While inserting the data into Hbase , timestamp is giving problem.
Hbase> select * from test;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell
|
+-------------------------+-------------------------+-------------------------+
| r1 | a: | 10
|
+-------------------------+-------------------------+-------------------------+
| r1 | b: | 20
|
+-------------------------+-------------------------+-------------------------+
| r1 | c: | 30
|
+-------------------------+-------------------------+-------------------------+
3 row(s) in set (0.19 sec)
Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
TIMESTAMP '200';
Syntax error : Type 'help;' for usage.
Message : Encountered "TIMESTAMP" at line 1, column 62.
Hbase>
But data gets inserted
Hbase> insert into test(a,b,c) values ('1','2','3') where
row='r1' ;
1 row inserted successfully. (0.01 sec)
Hbase>
Hbase> select * from
test;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell
|
+-------------------------+-------------------------+-------------------------+
| r1 | a: | 1
|
+-------------------------+-------------------------+-------------------------+
| r1 | b: | 2
|
+-------------------------+-------------------------+-------------------------+
| r1 | c: | 3
|
+-------------------------+-------------------------+-------------------------+
3 row(s) in set (0.09 sec)
Hbase>
But my old data in column get overridden with previous one. Can any one
look into this and give their valuable suggestion why it is so.
Why timestamp is not showing atall but it is claimed to be working in
the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
So please help me out with valuable solutions and example.
Thanks
---
Peeyush
Re: Hbase Timestamp Error
Posted by edward yoon <ed...@udanax.org>.
http://people.apache.org/~nigel/hadoop-0.16.0-candidate-0/
On 1/31/08, ma qiang <ma...@gmail.com> wrote:
> Additionally, I only find the 0.15.3 version in the releases.
>
>
> On Feb 1, 2008 12:05 PM, ma qiang <ma...@gmail.com> wrote:
> > Where can we get the higher version ? Which is the latest version?
> > 0.16 or 0.15.2?
> > Thank you !
> >
> >
> >
> >
> > On Feb 1, 2008 6:58 AM, edward yoon <ed...@udanax.org> wrote:
> > > It required a higher version version than hadoop 0.16
> > >
> > >
> > > On 1/31/08, Peeyush Bishnoi <pe...@yahoo-inc.com> wrote:
> > > > Hi ,
> > > >
> > > > While inserting the data into Hbase , timestamp is giving problem.
> > > >
> > > > Hbase> select * from test;
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | Row | Column | Cell
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | a: | 10
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | b: | 20
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | c: | 30
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > >
> > > > 3 row(s) in set (0.19 sec)
> > > >
> > > > Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
> > > > TIMESTAMP '200';
> > > > Syntax error : Type 'help;' for usage.
> > > > Message : Encountered "TIMESTAMP" at line 1, column 62.
> > > > Hbase>
> > > >
> > > > But data gets inserted
> > > >
> > > > Hbase> insert into test(a,b,c) values ('1','2','3') where
> > > > row='r1' ;
> > > > 1 row inserted successfully. (0.01 sec)
> > > > Hbase>
> > > >
> > > > Hbase> select * from
> > > > test;
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | Row | Column | Cell
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | a: | 1
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | b: | 2
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > > | r1 | c: | 3
> > > > |
> > > > +-------------------------+-------------------------+-------------------------+
> > > >
> > > > 3 row(s) in set (0.09 sec)
> > > > Hbase>
> > > >
> > > > But my old data in column get overridden with previous one. Can any one
> > > > look into this and give their valuable suggestion why it is so.
> > > >
> > > > Why timestamp is not showing atall but it is claimed to be working in
> > > > the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
> > > >
> > > > So please help me out with valuable solutions and example.
> > > >
> > > > Thanks
> > > >
> > > > ---
> > > > Peeyush
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > B. Regards,
> > > Edward yoon @ NHN, corp.
> > >
> >
>
--
B. Regards,
Edward yoon @ NHN, corp.
Re: Hbase Timestamp Error
Posted by ma qiang <ma...@gmail.com>.
Additionally, I only find the 0.15.3 version in the releases.
On Feb 1, 2008 12:05 PM, ma qiang <ma...@gmail.com> wrote:
> Where can we get the higher version ? Which is the latest version?
> 0.16 or 0.15.2?
> Thank you !
>
>
>
>
> On Feb 1, 2008 6:58 AM, edward yoon <ed...@udanax.org> wrote:
> > It required a higher version version than hadoop 0.16
> >
> >
> > On 1/31/08, Peeyush Bishnoi <pe...@yahoo-inc.com> wrote:
> > > Hi ,
> > >
> > > While inserting the data into Hbase , timestamp is giving problem.
> > >
> > > Hbase> select * from test;
> > > +-------------------------+-------------------------+-------------------------+
> > > | Row | Column | Cell
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | a: | 10
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | b: | 20
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | c: | 30
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > >
> > > 3 row(s) in set (0.19 sec)
> > >
> > > Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
> > > TIMESTAMP '200';
> > > Syntax error : Type 'help;' for usage.
> > > Message : Encountered "TIMESTAMP" at line 1, column 62.
> > > Hbase>
> > >
> > > But data gets inserted
> > >
> > > Hbase> insert into test(a,b,c) values ('1','2','3') where
> > > row='r1' ;
> > > 1 row inserted successfully. (0.01 sec)
> > > Hbase>
> > >
> > > Hbase> select * from
> > > test;
> > > +-------------------------+-------------------------+-------------------------+
> > > | Row | Column | Cell
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | a: | 1
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | b: | 2
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | c: | 3
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > >
> > > 3 row(s) in set (0.09 sec)
> > > Hbase>
> > >
> > > But my old data in column get overridden with previous one. Can any one
> > > look into this and give their valuable suggestion why it is so.
> > >
> > > Why timestamp is not showing atall but it is claimed to be working in
> > > the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
> > >
> > > So please help me out with valuable solutions and example.
> > >
> > > Thanks
> > >
> > > ---
> > > Peeyush
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > B. Regards,
> > Edward yoon @ NHN, corp.
> >
>
Re: Hbase Timestamp Error
Posted by edward yoon <ed...@udanax.org>.
Please use the hadoop 0.16 release or TRUNK version.
Thanks.
On 2/1/08, ma qiang <ma...@gmail.com> wrote:
> Where can we get the higher version ? Which is the latest version?
> 0.16 or 0.15.2?
> Thank you !
>
>
>
> On Feb 1, 2008 6:58 AM, edward yoon <ed...@udanax.org> wrote:
> > It required a higher version version than hadoop 0.16
> >
> >
> > On 1/31/08, Peeyush Bishnoi <pe...@yahoo-inc.com> wrote:
> > > Hi ,
> > >
> > > While inserting the data into Hbase , timestamp is giving problem.
> > >
> > > Hbase> select * from test;
> > > +-------------------------+-------------------------+-------------------------+
> > > | Row | Column | Cell
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | a: | 10
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | b: | 20
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | c: | 30
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > >
> > > 3 row(s) in set (0.19 sec)
> > >
> > > Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
> > > TIMESTAMP '200';
> > > Syntax error : Type 'help;' for usage.
> > > Message : Encountered "TIMESTAMP" at line 1, column 62.
> > > Hbase>
> > >
> > > But data gets inserted
> > >
> > > Hbase> insert into test(a,b,c) values ('1','2','3') where
> > > row='r1' ;
> > > 1 row inserted successfully. (0.01 sec)
> > > Hbase>
> > >
> > > Hbase> select * from
> > > test;
> > > +-------------------------+-------------------------+-------------------------+
> > > | Row | Column | Cell
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | a: | 1
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | b: | 2
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > > | r1 | c: | 3
> > > |
> > > +-------------------------+-------------------------+-------------------------+
> > >
> > > 3 row(s) in set (0.09 sec)
> > > Hbase>
> > >
> > > But my old data in column get overridden with previous one. Can any one
> > > look into this and give their valuable suggestion why it is so.
> > >
> > > Why timestamp is not showing atall but it is claimed to be working in
> > > the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
> > >
> > > So please help me out with valuable solutions and example.
> > >
> > > Thanks
> > >
> > > ---
> > > Peeyush
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > B. Regards,
> > Edward yoon @ NHN, corp.
> >
>
--
B. Regards,
Edward yoon @ NHN, corp.
Re: Hbase Timestamp Error
Posted by ma qiang <ma...@gmail.com>.
Where can we get the higher version ? Which is the latest version?
0.16 or 0.15.2?
Thank you !
On Feb 1, 2008 6:58 AM, edward yoon <ed...@udanax.org> wrote:
> It required a higher version version than hadoop 0.16
>
>
> On 1/31/08, Peeyush Bishnoi <pe...@yahoo-inc.com> wrote:
> > Hi ,
> >
> > While inserting the data into Hbase , timestamp is giving problem.
> >
> > Hbase> select * from test;
> > +-------------------------+-------------------------+-------------------------+
> > | Row | Column | Cell
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | a: | 10
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | b: | 20
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | c: | 30
> > |
> > +-------------------------+-------------------------+-------------------------+
> >
> > 3 row(s) in set (0.19 sec)
> >
> > Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
> > TIMESTAMP '200';
> > Syntax error : Type 'help;' for usage.
> > Message : Encountered "TIMESTAMP" at line 1, column 62.
> > Hbase>
> >
> > But data gets inserted
> >
> > Hbase> insert into test(a,b,c) values ('1','2','3') where
> > row='r1' ;
> > 1 row inserted successfully. (0.01 sec)
> > Hbase>
> >
> > Hbase> select * from
> > test;
> > +-------------------------+-------------------------+-------------------------+
> > | Row | Column | Cell
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | a: | 1
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | b: | 2
> > |
> > +-------------------------+-------------------------+-------------------------+
> > | r1 | c: | 3
> > |
> > +-------------------------+-------------------------+-------------------------+
> >
> > 3 row(s) in set (0.09 sec)
> > Hbase>
> >
> > But my old data in column get overridden with previous one. Can any one
> > look into this and give their valuable suggestion why it is so.
> >
> > Why timestamp is not showing atall but it is claimed to be working in
> > the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
> >
> > So please help me out with valuable solutions and example.
> >
> > Thanks
> >
> > ---
> > Peeyush
> >
> >
> >
> >
> >
>
>
> --
> B. Regards,
> Edward yoon @ NHN, corp.
>
Re: Hbase Timestamp Error
Posted by edward yoon <ed...@udanax.org>.
It required a higher version version than hadoop 0.16
On 1/31/08, Peeyush Bishnoi <pe...@yahoo-inc.com> wrote:
> Hi ,
>
> While inserting the data into Hbase , timestamp is giving problem.
>
> Hbase> select * from test;
> +-------------------------+-------------------------+-------------------------+
> | Row | Column | Cell
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | a: | 10
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | b: | 20
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | c: | 30
> |
> +-------------------------+-------------------------+-------------------------+
>
> 3 row(s) in set (0.19 sec)
>
> Hbase> insert into test(a,b,c) values ('1','2','3') where row='r1'
> TIMESTAMP '200';
> Syntax error : Type 'help;' for usage.
> Message : Encountered "TIMESTAMP" at line 1, column 62.
> Hbase>
>
> But data gets inserted
>
> Hbase> insert into test(a,b,c) values ('1','2','3') where
> row='r1' ;
> 1 row inserted successfully. (0.01 sec)
> Hbase>
>
> Hbase> select * from
> test;
> +-------------------------+-------------------------+-------------------------+
> | Row | Column | Cell
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | a: | 1
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | b: | 2
> |
> +-------------------------+-------------------------+-------------------------+
> | r1 | c: | 3
> |
> +-------------------------+-------------------------+-------------------------+
>
> 3 row(s) in set (0.09 sec)
> Hbase>
>
> But my old data in column get overridden with previous one. Can any one
> look into this and give their valuable suggestion why it is so.
>
> Why timestamp is not showing atall but it is claimed to be working in
> the following URL: http://wiki.apache.org/hadoop/Hbase/HbaseShell/
>
> So please help me out with valuable solutions and example.
>
> Thanks
>
> ---
> Peeyush
>
>
>
>
>
--
B. Regards,
Edward yoon @ NHN, corp.