hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravikumar MAV <ravi...@gmail.com>
Subject Re: Trouble with Boolean,integer and timestamp
Date Sat, 24 Dec 2011 06:53:14 GMT
hbql looks like abandoned. If you are in initial stages to use it, better
to use Java/REST/Thrift client code.

-R

On Fri, Dec 23, 2011 at 10:32 PM, Suraj Varma <svarma.ng@gmail.com> wrote:

> 1. You're using hbql library to interact with hbase not the java
> client. I don't know how up-to-date hbql is with hbase versions. From
> their site it appears to be close to a year old
> (http://hbql.com/download.html)
>
> 2. I'm not sure why you want to store a "number" and retrieve that as
> a boolean.
>
> If you are trying to explore hbase, I'd recommend that you use the
> hbase java client rather than an additional intermediate layer like
> hbql. Once you are comfortable with the java client, you can see if
> you can make hbql work (and perhaps fix minor issues that may exist
> with it to work with the version of hbase you are using).
> See http://hbase.apache.org/book/config.files.html#client_dependencies
> and checkout HTable or HTablePool to connect to the cluster.
>
> Hope that helps.
> --Suraj
>
> On Wed, Dec 21, 2011 at 5:52 AM, neuron005 <neuron005@gmail.com> wrote:
> >
> > Hiii there
> > I am new to hbase and trying to explore it. I am trying to store some
> values
> > to hbase using my java program. Though I can easily store string values
> and
> > retrieve them but I am having trouble with Boolean int and timestamp.
> > Boolean --- whatever number I save between 0 to 9 it results in true
> >
> > int -- does not let me store a number less than 3 digits and if i store a
> > number of 4 or 5 digits it results in different value
> >
> > timestamp: How can I get timestamp from hbase for a particular column so
> > that I can apply toString() method on it to get in format yyyy:mm:dd
> > Here is my sample program of java with which I am trying
> > --------------------------------Please add necessary jars to
> > classpath(hbql,hadoop-core,hbase,commons,antlr,zookeeper,log4j)
> > import java.sql.*;
> > import java.util.Date;
> > public class test
> > {
> > public static void main(String args[])
> > {
> > Connection con=null;
> > Statement stmt = null;
> >        try{
> >                Class.forName("org.apache.hadoop.hbase.jdbc.Driver");
> >                con = DriverManager.getConnection("jdbc:hbql");
> >        stmt=con.createStatement();
> >    stmt.execute("CREATE TABLE Activity (f1()) IF NOT
> > tableexists('Activity')");
> >
> >    stmt.execute("CREATE TEMP MAPPING scho8 FOR TABLE Activity"
> >                 + "("
> >                 + "keyval key, "
> >                 + "f1 ("
> >                 + "User string alias User, "
> >                 + " date DATE alias date, "
> >                + " count INTEGER alias count, "
> >                + " flag boolean alias flag "
> >                 + ") "
> >                 + ")");
> >
> >    ResultSet rs = stmt.executeQuery("select * from scho8");
> >    System.out.println("hii there");
> >    while (rs.next()) {
> >        System.out.println("hii there you");
> >        String user=rs.getString("User");
> >        Date feedDate=rs.getDate("date");
> >        Timestamp timestamp=rs.getTimestamp("date");
> >        int comment = rs.getInt("count");
> >
> >        boolean flag=rs.getBoolean("flag");
> >
> >        System.out.println("user is : "+ user);
> >
> >        System.out.print("feed Date is :"+feedDate);
> >        System.out.println("Timestamp received is"+timestamp);
> >        System.out.println("Comment count is: " + comment);
> >        System.out.println("Flag is: "+flag);
> >        System.out.print("feed Date is :"+timestamp.toString());
> >    }
> >   rs.close();
> >    stmt.close();
> >    con.close();
> >        }catch(Exception e)
> >        {
> >                e.printStackTrace();
> >        }
> > }
> > }
> >
> >
> >
> > --
> > View this message in context:
> http://old.nabble.com/Trouble-with-Boolean%2Cinteger-and-timestamp-tp33016853p33016853.html
> > Sent from the HBase User mailing list archive at Nabble.com.
> >
>



-- 
- Ravi MAV

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message