Return-Path: 
 <user-return-4481-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: (qmail 93629 invoked from network); 24 Nov 2010 19:09:39 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 24 Nov 2010 19:09:39 -0000
Received: (qmail 42877 invoked by uid 500); 24 Nov 2010 19:10:10 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 42851 invoked by uid 500); 24 Nov 2010 19:10:10 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 42843 invoked by uid 99); 24 Nov 2010 19:10:10 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Nov 2010 19:10:10 +0000
X-ASF-Spam-Status: No, hits=0.7 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [63.245.208.150] (HELO dm-mail01.mozilla.org) (63.245.208.150)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Nov 2010 19:10:04 +0000
X-Virus-Scanned: amavisd-new at mozilla.org
Received: from joubert.local (v74-nslb.mozilla.org [10.2.74.4])
	(Authenticated sender: xstevens@mozilla.com)
	by dm-mail01.mozilla.org (Postfix) with ESMTP id DC33D6A8C7B
	for <user@hive.apache.org>; Wed, 24 Nov 2010 11:09:40 -0800 (PST)
Message-ID: <4CED62F4.4080505@mozilla.com>
Date: Wed, 24 Nov 2010 11:09:40 -0800
From: Xavier Stevens <xstevens@mozilla.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
To: user@hive.apache.org
Subject: Re: Querying HBase
References: <4CEC5953.1030903@mozilla.com>
 <B6E931DF-F87A-42CE-841B-9B524468E84B@facebook.com>
 <4CED60CB.1090505@mozilla.com>
In-Reply-To: <4CED60CB.1090505@mozilla.com>
X-Enigmail-Version: 1.1.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Actually I think I have found the issue.  I was trying to test this out
before we upgraded.  And we were having classpath conflicts which
pointed to the old datanucleus JARs that came with hive 0.5.

-Xavier


On 11/24/10 11:00 AM, Xavier Stevens wrote:
> Hi John,
>
> This definitely looks like the issue you linked.  I'm just using the
> default "datanucleus" for that configuration value.
>
> I see <dependency org="org.datanucleus"
> name="datanucleus-connectionpool"
> rev="${datanucleus-connectionpool.version}"> in the metastore ivy.xml.
>
> What version should I have?  I see this in my build/dist/lib directory:
>
> -rw-r--r--  1 xstevens  staff    16880 Jun 24 06:34
> datanucleus-connectionpool-2.0.3.jar
> -rw-r--r--  1 xstevens  staff  2052714 Jun 25 00:50
> datanucleus-core-2.1.1.jar
> -rw-r--r--  1 xstevens  staff   188007 Jun  9 05:47
> datanucleus-enhancer-2.1.0-release.jar
> -rw-r--r--  1 xstevens  staff  1240347 Jun 25 00:53
> datanucleus-rdbms-2.1.1.jar
>
> Thanks,
>
>
> -Xavier
>
> On 11/23/10 5:56 PM, John Sichi wrote:
>> It looks a bit like this one where ISCOMPRESSED was used instead of IS_COMPRESSED:
>>
>> https://issues.apache.org/jira/browse/HIVE-1435
>>
>> Maybe your datanucleus.identifierFactory is somehow misconfigured?
>>
>> JVS
>>
>> On Nov 23, 2010, at 4:16 PM, Xavier Stevens wrote:
>>
>>> I'm trying to create an external table to a pre-existing HBase table
>>> using Hive trunk, like so:
>>>
>>> CREATE EXTERNAL TABLE hbase_metrics (key string, value map<string,int>)
>>> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH
>>> SERDEPROPERTIES ("hbase.columns.mapping" = ":key,counters:")
>>> TBLPROPERTIES ("hbase.table.name" = "metrics");
>>>
>>> I'm getting this error:
>>>
>>> http://xstevens.pastebin.mozilla.org/863392
>>>
>>> The SDS table in MySQL doesn't have a default value for IS_COMPRESSED. 
>>> How do I specify a value for this via create table?
>>>
>>> Thanks,
>>>
>>>
>>> -Xavier
>>>