Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-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 0CD101848A for ; Wed, 2 Mar 2016 05:44:13 +0000 (UTC) Received: (qmail 49412 invoked by uid 500); 2 Mar 2016 05:44:11 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 49348 invoked by uid 500); 2 Mar 2016 05:44:11 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 49338 invoked by uid 99); 2 Mar 2016 05:44:11 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2016 05:44:11 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2DBEC18055A for ; Wed, 2 Mar 2016 05:44:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.571 X-Spam-Level: ** X-Spam-Status: No, score=2.571 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_IMAGE_ONLY_24=1.282, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_REMOTE_IMAGE=0.01] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=goibibo-com.20150623.gappssmtp.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id yI82DqFhHnZG for ; Wed, 2 Mar 2016 05:44:09 +0000 (UTC) Received: from mail-lf0-f43.google.com (mail-lf0-f43.google.com [209.85.215.43]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 8A7625F33F for ; Wed, 2 Mar 2016 05:44:08 +0000 (UTC) Received: by mail-lf0-f43.google.com with SMTP id l83so80577182lfd.3 for ; Tue, 01 Mar 2016 21:44:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=goibibo-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=Qb+rCJjNoJ+zHCDREGhCIvdH3AQtbxrLqQWs4+PZbLs=; b=A3nCwX57DabkKNQZtJ67NkNTYdoYEMMtVYujPHdUuyP7ntKN1SVUWIWkWNvJ1qxW60 iDR86k9OIJUIhBCc3f3UzsFZLM3tHQ7Qdfh2BYjtaifU+0DzJS3E6IkPWLWa6yxhrYxA tQeTonux/6h51Npu19XXYi+0qmf76nK3WzjI01hSph++ueorZVr7/XYxfcW4SZbkRbvp hlZrPii1arzCPYnIC8nqhe5bZHM+yRtUmOFCTqW1JNyC+t0AzESmULp4GpYIYB1OLyMO UGEcNHiOgU8Tr7GbOcEExSmaC/xx81Bs5ORmbdsyUaTpoxRYE5se8eQ86Ym3TluFLRAz 9cog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=Qb+rCJjNoJ+zHCDREGhCIvdH3AQtbxrLqQWs4+PZbLs=; b=CSgTrWo20wdl7zd0YrxylXJaz3Ewxxsmd71ae4SJXHsJsTKHxAjR5f1w+6qIsrXTj2 b38WiKT81SwDnVv9XPsIr9m7x6Qslip969U1OkfX9iiLPTymsrTL6LXSjwetWBrtcg1n ydIEWpwMQZMLc4AejTKEzF2IthdHRpOwTZkN9nPHybUWWYn138gX0dG/e0PG42zfpVYk U/sWOsQeBflqDXnLUaaFV9yItcf1w5WfsktswwSagsCaapT65mWEk8UYPTBAOXJugaZi sZpxtJcJGJXzcf3St6hpSAi43NzRLGQCJuAepXiIrtpFybXF83xgnjrdwxQZPRIpbj82 yhrQ== X-Gm-Message-State: AD7BkJK7H/ImHQ3BxTwSIqHcxdDyh1fRzTEG9MuSUsdrk1PffSVvHCO6eviE5dAnfF8eUnRPuTFhwD3hhftz6tck0Fi0G/FoZ0WD8A71nVNXqyUoLQV3ir0REmNhJ0NzZpSHiFERTCI5NkHtJw== MIME-Version: 1.0 X-Received: by 10.25.91.20 with SMTP id p20mr7786090lfb.79.1456897448110; Tue, 01 Mar 2016 21:44:08 -0800 (PST) Received: by 10.112.60.40 with HTTP; Tue, 1 Mar 2016 21:44:08 -0800 (PST) In-Reply-To: References: Date: Wed, 2 Mar 2016 11:14:08 +0530 Message-ID: Subject: Re: Hbase-Hive table integration Error From: Amrit Jangid To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11400984de8d27052d0a5e9c --001a11400984de8d27052d0a5e9c Content-Type: text/plain; charset=UTF-8 Anyone ? On Fri, Feb 26, 2016 at 3:50 PM, Amrit Jangid wrote: > Hi , > > I wanted to access one hbase table in hive, during creating the table, had > incorrect columns mapping in query. > > Now i want to DROP the table to create it again.But every query(DESCRIBE , > DROP, SELECT) in table is giving error as : > > Error while compiling statement: FAILED: RuntimeException > MetaException(message:org.apache.hadoop.hive.serde2.SerDeException > org.apache.hadoop.hive.hbase.HBaseSerDe: columns has 227 elements while > hbase.columns.mapping has 155 elements (counting the key if implicit)) > > Please Help. > > > -- > > Regards, > Amrit > > -- Regards, Amrit DataPlatform Team -- --001a11400984de8d27052d0a5e9c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Anyone ?

On Fri, Feb 26, 2016 at 3:50 PM, Amrit Jangid <amrit.= jangid@goibibo.com> wrote:
=
Hi ,

I wanted to access one hbase table in hive, du= ring creating the table, had =C2=A0incorrect columns mapping in query.=C2= =A0

Now i want to DROP the table to create it again.But every query(= DESCRIBE , DROP, SELECT) in table is giving error as :

Error while compiling statement: FAILED:= RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDe= Exception org.apache.hadoop.hive.hbase.HBaseSerDe: columns has 227 elements= while hbase.columns.mapping has 155 elements (counting the key if implicit= ))


Please Help.


--
=

Regards,
Amrit =C2=A0




--

Regards,Amrit =C2=A0
DataPla= tform=C2=A0Team

<= img src=3D"https://s3-ap-southeast-1.amazonaws.com/mdb-ibcdn-com/website_of= _the_year_2015.jpg"> --001a11400984de8d27052d0a5e9c--