Ooops, then i'd recommend Hbase API instead of HQL. http://lucene.apache.org/hadoop/docs/current/api/org/apache/hadoop/hbase/HBaseAdmin.html http://lucene.apache.org/hadoop/docs/current/api/org/apache/hadoop/hbase/HTable.html
You can use these. For example : HBaseAdmin admin = new HbaseAdmin(conf); HTableDescriptor tableDesc = new HTableDescriptor("webtable"); tableDesc.addFamily(new HColumnDescriptor("anchor")); tableDesc.addFamily(new HColumnDescriptor("content")); admin.createTable(tableDesc); B. Regards, Edward yoon @ NHN, corp. > Date: Thu, 17 Jan 2008 16:50:29 +0800 > From: [EMAIL PROTECTED] > To: hadoop-user@lucene.apache.org > Subject: Re: about using HBase? > > Thank you for your help! > > You metioned hadoop-0.16.* , but I still use hadoop-0.15 ,I can't see > hadoop-0.16.* in the http://lucene.apache.org/hadoop/releases.html, > and I haven't found the org.apache.hadoop.hbase.hql . .So I'm not sure > I use the correct edition. > > > > On Jan 17, 2008 4:40 PM, edward yoon wrote: >> >> Grandmotherly, If you want to retrieval the cell values, you should use the >> HTable.class because Result Set return policy doesn't implemented yet. >> >> Thanks. >> >> B. Regards, >> >> Edward yoon @ NHN, corp. >> >> >>> From: [EMAIL PROTECTED] >>> To: hadoop-user@lucene.apache.org >>> Subject: RE: about using HBase? >>> Date: Thu, 17 Jan 2008 08:33:58 +0000 >> >>> >>> >>> It's a org.apache.hadoop.hbase.hql. >>> >>> Or, Simply just use the 'ctrl + shift + o' key on eclipse tool. (simle) >>> >>> Thanks. >>> >>> B. Regards, >>> >>> Edward yoon @ NHN, corp. >>> >>> >>>> Date: Thu, 17 Jan 2008 16:29:28 +0800 >>>> From: [EMAIL PROTECTED] >>>> To: hadoop-user@lucene.apache.org >>>> Subject: Re: about using HBase? >>>> >>>> Thank you very much! >>>> I've used the HQL as you metioned, but where is package including >>>> HQLClient and ReturnMsg ? >>>> >>>> >>>> >>>> >>>> On Jan 17, 2008 4:05 PM, edward yoon wrote: >>>>> >>>>> See the HBaseAdmin and HTable, HConnection classes. >>>>> If you use a eclipse for develop, i'd recommend the Outline Viewer. >>>>> >>>>> Or, you can also use the HQL as describe below. >>>>> >>>>> HQLClient hql = new HQLClient(new HBaseConfiguration(), MASTER_ADDRESS, >>>>> null, null); >>>>> ReturnMsg rs = hql.executeQuery("create table >>>>> webtable('content','title');"); >>>>> >>>>> >>>>> B. Regards, >>>>> >>>>> Edward yoon @ NHN, corp. >>>>> >>>>> >>>>>> Date: Thu, 17 Jan 2008 15:58:24 +0800 >>>>>> From: [EMAIL PROTECTED] >>>>>> To: hadoop-user@lucene.apache.org >>>>>> Subject: Re: about using HBase? >>>>>> >>>>>> Thanks very much! >>>>>> When I manipulate the HBase in map and reduce function,I need use the >>>>>> java api about HBase. Can you tell me how to use it? >>>>>> >>>>>> >>>>>> >>>>> >>>>>> On Jan 17, 2008 3:50 PM, edward yoon wrote: >>>>>>> >>>>>>> Sorry for my broke mail. >>>>>>> >>>>>>> Please copy the hadoop-0.16.*-hbase.jar to ${hadoop_home}/lib folder. >>>>>>> And, Here's a exmple of hadoop-site.xml >>>>>>> >>>>>>> Also, see example code of >>>>>>> https://issues.apache.org/jira/browse/HADOOP-2480 >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> hbase.master >>>>>>> a51066.nhncorp.com:60000 >>>>>>> The port for the hbase master web UI >>>>>>> Set to -1 if you do not want the info server to run. >>>>>>> >>>>>>> >>>>>>> >>>>>>> hbase.master.info.port >>>>>>> 60010 >>>>>>> The port for the hbase master web UI >>>>>>> Set to -1 if you do not want the info server to run. >>>>>>> >>>>>>> >>>>>>> >>>>>>> hbase.regionserver >>>>>>> a51066.nhncorp.com:60020 >>>>>>> The port for the hbase regionserver web UI >>>>>>> Set to -1 if you do not want the info server to run. >>>>>>> >>>>>>> >>>>>>> >>>>>>> hbase.regionserver.info.port >>>>>>> 61030 >>>>>>> The port for the hbase regionserver web UI >>>>>>> Set to -1 if you do not want the info server to run. >>>>>>> >>>>>>> >>>>>>> >>>>>>> hbase.rootdir >>>>>>> /tmp/hbase >>>>>>> location of HBase instance in dfs >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> B. Regards, >>>>>>> >>>>>>> Edward yoon @ NHN, corp. >>>>>>> >>>>>>> >>>>>>>> From: [EMAIL PROTECTED] >>>>>>>> To: hadoop-user@lucene.apache.org >>>>>>>> Subject: RE: about using HBase? >>>>>>>> Date: Thu, 17 Jan 2008 07:46:00 +0000 >>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Please copy the hadoop-0.16.*-hbase.jar to ${hadoop_home}/lib folder. >>>>>>>> And, Here's a exmple of hadoop-site.xml >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> hbase.master >>>>>>>> a51066.nhncorp.com:60000 >>>>>>>> The port for the hbase master web UI >>>>>>>> Set to -1 if you do not want the info server to run. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> hbase.master.info.port >>>>>>>> 60010 >>>>>>>> The port for the hbase master web UI >>>>>>>> Set to -1 if you do not want the info server to run. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> hbase.regionserver >>>>>>>> a51066.nhncorp.com:60020 >>>>>>>> The port for the hbase regionserver web UI >>>>>>>> Set to -1 if you do not want the info server to run. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> hbase.regionserver.info.port >>>>>>>> 61030 >>>>>>>> The port for the hbase regionserver web UI >>>>>>>> Set to -1 if you do not want the info server to run. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> hbase.rootdir >>>>>>>> /tmp/hbase >>>>>>>> location of HBase instance in dfs >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Thanks. >>>>>>>> >>>>>>>> >>>>>>>> B. Regards, >>>>>>>> Edward yoon @ NHN, corp. >>>>>>>> >>>>>>>> ---------------------------------------- >>>>>>>>> Date: Thu, 17 Jan 2008 15:37:58 +0800 >>>>>>>>> From: [EMAIL PROTECTED] >>>>>>>>> To: hadoop-user@lucene.apache.org >>>>>>>>> Subject: about using HBase? >>>>>>>>> >>>>>>>>> Dear colleagues; >>>>>>>>> Now,I have to use HBase in my map and reduce functions, but I >>>>>>>>> don't know how to use. I have seen the examples in the FQA and >>>>>>>>> org.apache.hadoop.hbase. ,but I can't run it successfully. Can you >>>>>>>>> give me some simple examples make me manipulate HBase using java api >>>>>>>>> in my map and reduce functions as soon as possible. Thank you very >>>>>>>>> much! >>>>>>>>> >>>>>>>>> >>>>>>>>> Qiang Ma >>>>>>>>> Department of Computer Science and Engineering >>>>>>>>> Fudan University >>>>>>>>> Shanghai, P. R. China >>>>>>>>> EMail: [EMAIL PROTECTED] >>>>>>>> >>>>>>>> _________________________________________________________________ >>>>>>>> Share life as it happens with the new Windows Live. >>>>>>>> http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008 >>>>>>> >>>>>>> _________________________________________________________________ >>>>>>> Get the power of Windows + Web with the new Windows Live. >>>>>>> http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008 >>>>> >>>>> _________________________________________________________________ >>>>> Get the power of Windows + Web with the new Windows Live. >>>>> http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008 >>> >>> _________________________________________________________________ >>> Put your friends on the big screen with Windows Vista(R) + Windows Live™. >>> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_MediaCtr_bigscreen_012008 >> >> _________________________________________________________________ >> Get the power of Windows + Web with the new Windows Live. >> http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008 _________________________________________________________________ Put your friends on the big screen with Windows Vista® + Windows Live™. http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_MediaCtr_bigscreen_012008