Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 38BF5D42F for ; Thu, 16 Aug 2012 09:25:25 +0000 (UTC) Received: (qmail 20950 invoked by uid 500); 16 Aug 2012 09:25:23 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 20902 invoked by uid 500); 16 Aug 2012 09:25:23 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 20894 invoked by uid 99); 16 Aug 2012 09:25:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2012 09:25:23 +0000 X-ASF-Spam-Status: No, hits=1.8 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gemini5201314@gmail.com designates 209.85.160.169 as permitted sender) Received: from [209.85.160.169] (HELO mail-gh0-f169.google.com) (209.85.160.169) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2012 09:25:18 +0000 Received: by ghrr18 with SMTP id r18so3291463ghr.14 for ; Thu, 16 Aug 2012 02:24:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=yhHOqJLT65mM4lkSVxvtMS5Y8Gt50V0/+oAcJPnUoA8=; b=O+byeXrJGOxXhhYMf3UHEU6f51wAh4tc/BxtqwFRfvAaecGBT7WtyrHNqSJX8XeSjh 3lVGMBkY1Nfaj3CJdgvGZh+rbWI0OALWC/7K0l+fPacKaTbfGOeIEO/efDEQLZcyxBq+ POeaHtkFB7KPo3B5hrpxgRbtJzwuuKeEqqht+s+tJtSRAzkfK8IG0kCGcSZdTY5LLdI/ iDg7sOlcs+BFurWP7H5DcoAorl3KyxQFxQPew20+5oS0sIaLHkA3eW6o6t59fNqLVgay mSNno3/L5CICnMv9nmr/VFNS0yYTOjRxvkkxAV6lNKKvkzVh8CFbTyhp+0rwKovbKM+9 m1vA== MIME-Version: 1.0 Received: by 10.60.24.35 with SMTP id r3mr402744oef.67.1345109058144; Thu, 16 Aug 2012 02:24:18 -0700 (PDT) Received: by 10.60.116.197 with HTTP; Thu, 16 Aug 2012 02:24:18 -0700 (PDT) In-Reply-To: References: Date: Thu, 16 Aug 2012 17:24:18 +0800 Message-ID: Subject: Re: Issue with creating table in hbase From: gemini alex To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=e89a8fb2067e984b2004c75e9be4 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb2067e984b2004c75e9be4 Content-Type: text/plain; charset=UTF-8 it seems you didn't start hive with --aux-path as mentioned in hive hbase integration document. 2012/8/15 Kevin O'dell > What happens if you paste that into the hive shell? > > On Tue, Aug 14, 2012 at 11:05 AM, Omer, Farah >wrote: > > > Hi all, > > > > I was testing hbase integrated with Hive, and running into an issue. > Would > > anyone has an idea what it means? > > > > > > > > hbase(main):001:0> CREATE TABLE hbase_mstr_1(key int, value string) > STORED > > BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH > SERDEPROPERTIES > > ("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES (" > > hbase.table.name" = "xyz") > > > > SyntaxError: (hbase):1: syntax error, unexpected tIDENTIFIER > > > > > > > > CREATE TABLE hbase_mstr_1(key int, value string) STORED BY > > 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES > > ("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES (" > > hbase.table.name" = "xyz") > > > > ^ > > > > > > > > hbase(main):002:0> > > > > > > > > Hive version is 0.7, hbase version is 0.90 > > > > > > > > Farah Omer > > > > Sr. DB Engineer | MicroStrategy, Inc. > > > > Tel 703.270.2230 | fomer@microstrategy.com > > > > 1850 Towers Crescent Plaza | Tysons Corner, VA 22182 > > > > www.microstrategy.com > > > > > > > > > -- > Kevin O'Dell > Customer Operations Engineer, Cloudera > --e89a8fb2067e984b2004c75e9be4--