I think the new Table("default", "pokes")will create a dummy table object with only the db name and table name set. It will not retrieve the table information from metastore.
If you are looking for the schema information and retrieve the data, you might want to consider using the JDBC interface. The JDBC driver can be used with a remote hiveserver as well embedded hive. thanks Prasad On Fri, Jun 7, 2013 at 7:59 AM, Haidar Hadi <haidar_hadi_...@yahoo.com>wrote: > Hello all, > I have similar issue, any idea? > > > On Jun 4, 2013, at 11:00 PM, Mohammad Tariq <donta...@gmail.com> wrote: > > Hello list, > > I am trying to access data stored in my Hive table through the Java > API but looks like I am not using it in the correct manner. Would really > appreciate some help. Here is the small piece of code I am trying to use : > > public static void main(String[] args) throws HiveMetaException { > // TODO Auto-generated method stub > > Table table = new Table("default", "pokes"); > System.out.println("DBNAME : " + table.getDbName()); > List<FieldSchema> cols = new ArrayList<FieldSchema>(); > cols = table.getCols(); > System.out.println("SIZE : " + cols.size()); > for(FieldSchema fs : cols) { > System.out.println(fs.getFieldValue(_Fields.findByName("foo VALUE : " + > "foo"))); > } > } > > The problem here is that *table.getCols() *is not returning anything. I > tried to print the size of the list, but it's zero. Looks like i'm missing > out something obvious or the approach itself is wrong. Need some help. > Pardon my ignorance. > > Thank you so much for your valuable time. > > Warm Regards, > Tariq > cloudfront.blogspot.com > >