Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id D76CA200AF7 for ; Tue, 14 Jun 2016 20:47:37 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id D5E64160A47; Tue, 14 Jun 2016 18:47:37 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B9824160A06 for ; Tue, 14 Jun 2016 20:47:36 +0200 (CEST) Received: (qmail 46640 invoked by uid 500); 14 Jun 2016 18:47:35 -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 46630 invoked by uid 99); 14 Jun 2016 18:47:35 -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; Tue, 14 Jun 2016 18:47:35 +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 07D8218057D for ; Tue, 14 Jun 2016 18:47:35 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id HXI8KoUN4AmP for ; Tue, 14 Jun 2016 18:47:32 +0000 (UTC) Received: from mail-qg0-f44.google.com (mail-qg0-f44.google.com [209.85.192.44]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 1D2D25FB76 for ; Tue, 14 Jun 2016 18:47:32 +0000 (UTC) Received: by mail-qg0-f44.google.com with SMTP id v48so71880054qgd.2 for ; Tue, 14 Jun 2016 11:47:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=ttzi/Zo4u0IKzXVE1GtFyJqDAXowg4//rARGEulRv3U=; b=Tj/2HvLjr2aSd5cFlCdxV4OKz7eKV4//19Ccp3afYfC6/exXMdaHAQDrFsyPdapPCd CgKJCExUg4UFojZTAS6t49JtPIFbYD3wDxwMjaRGLF6P2ALHScxUtyGi6ELu4viMPelA c8oDkepDCeYKBCLMUpWR/ayga7gihBWE9ch80oPzTiEQOzaGq/HQH4MFKZ70xNCyGLhA vN/KrHd/YRDC25/RcUbQM1OYlvaKjZ2AnokarhgUFzJ/00VgV8crx1gnscIOBR4xyig0 e3B3zZ65lb0QoEukb/llsSumQ6CbHRvZs/nE0cqUSuXTGNhD3a/7QH3xQVgfwGWEY+jh 5duw== 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:from:date :message-id:subject:to; bh=ttzi/Zo4u0IKzXVE1GtFyJqDAXowg4//rARGEulRv3U=; b=B4EdE4p2aZ/BLBCLpC9LoKmmGlHKgfGd6aBiKvJFCBGoJoDJG41087vQRhF1SROW5L LojztS7BJeWRAV13Mn1BB8GBLiImW6/91VgRGVRE42EHpkWtA6BLyeDxgDfn2pUZ+7YJ ptaV6bZwxbPk4456LWoKH1L+WNp5rgxOOHbhpsfEjs5VYME9fH0q3u19utamYvVJ8ncV iv7RXs0kzuTSfU6BIdWnmhFkGvQnX5VSLQnCsxiIHmcfVPbQmhEoBqJmCDu5hL0hFlBI u0+9qu8nWtS+nxx9fuTZGhh7WJp2uAq7X26henTUGpuW6+NIpS5zgApTP5o4iYiABEo7 nWiQ== X-Gm-Message-State: ALyK8tKYL8+U5S0AC5eDBuiGNIYQGjcaFmLtfrcMy8Gs/t5SWOgQU0RiyxHeRIjpqLJEmFFcYBan7OWD/2yBpw== X-Received: by 10.140.142.82 with SMTP id 79mr13946403qho.4.1465930051440; Tue, 14 Jun 2016 11:47:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.126.131 with HTTP; Tue, 14 Jun 2016 11:47:31 -0700 (PDT) In-Reply-To: References: From: Mich Talebzadeh Date: Tue, 14 Jun 2016 19:47:31 +0100 Message-ID: Subject: Re: ORC does not support type conversion from INT to STRING. To: user Content-Type: multipart/alternative; boundary=001a11371e18fb5a770535416f4a archived-at: Tue, 14 Jun 2016 18:47:38 -0000 --001a11371e18fb5a770535416f4a Content-Type: text/plain; charset=UTF-8 you must excuse my ignorance can you please elaborate on this as there seems something has gone wrong somewhere? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 14 June 2016 at 19:42, Mahender Sarangam wrote: > Yes Mich. We have restored cluster from metastore. > > On 6/14/2016 11:35 AM, Mich Talebzadeh wrote: > > Hi Mahendar, > > > Did you load the meta-data DB/schema from backup and now seeing this error > > > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > * > > > > http://talebzadehmich.wordpress.com > > > > On 14 June 2016 at 19:04, Mahender Sarangam > wrote: > >> ping. >> >> On 6/13/2016 1:19 PM, Mahender Sarangam wrote: >> >> Hi, >> >> We are facing issue while reading data from ORC table. We have created >> ORC table and dumped data into it. We have deleted cluster due to some >> reason. When we recreated cluster (using Metastore) and table pointing to >> same location. When we perform reading from ORC table. We see below error. >> >> SELECT col2, Col1, >> reflect("java.util.UUID", "randomUUID") AS ID, >> Source, >> 1 , >> SDate, >> EDate >> FROM Table ORC JOIN Table2 _surr; >> >> ERROR : Vertex failed, vertexName=Map 1, >> vertexId=vertex_1465411930667_0212_1_01, diagnostics=[Task failed, >> taskId=task_1465411930667_0212_1_01_000000, diagnostics=[TaskAttempt 0 >> failed, info=[Error: Failure while running task:java.lang.RuntimeException: >> java.lang.RuntimeException: java.io.IOException: java.io.IOException: ORC >> does not support type conversion from INT to STRING. >> >> >> I think issue is reflect("java.util.UUID", "randomUUID") AS ID >> >> >> I know there is Bug raised while reading data from ORC table. Is there >> any workaround apart from reloading data. >> >> -MS >> >> >> >> >> > > --001a11371e18fb5a770535416f4a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
you must excuse my ignorance

can you please elaborate on this as there seems something has gone wrong s= omewhere?


On 14 June 2016 at 19:42, Mahender Sarangam = <Mahender.BigData@outlook.com> wrote:

Yes Mich. We have restored cluster from metastore.


On 6/14/2016 11:35 AM, Mich Talebzadeh wrote:
Hi Mahendar,


Did you load the meta-data DB/schema from backup and now seeing this e= rror




On 14 June 2016 at 19:04, Mahender Sarangam <Mahen= der.BigData@outlook.com> wrote:

ping.


On 6/13/2016 1:19 PM, Mahender Sarangam wrote:

Hi,

We are facing issue while reading data from ORC table. We have created O= RC table and dumped data into it. We have deleted cluster due to some reaso= n. When we recreated cluster (using Metastore) and table pointing to same l= ocation. When we perform reading from ORC table. We see below error.

SELECT col2, Col1,
=C2=A0 reflect("java.util.UUID", "randomUUID") AS ID, =C2=A0 Source,
=C2=A01=C2=A0=C2=A0=C2=A0=C2=A0 ,
SDate,
EDate
FROM Table ORC=C2=A0 JOIN Table2 _surr;

ERROR : Vertex failed, vertexName=3DMap 1, vertexId=3Dvertex_1465411930667_0212_= 1_01, diagnostics=3D[Task failed, taskId=3Dtask_1465411930667_0212_1_01_000= 000, diagnostics=3D[TaskAttempt 0 failed, info=3D[Error: Failure while runn= ing task:java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException: java.io.IOException: ORC does not support type conver= sion from INT to STRING.


I think issue is reflect("java.util.UUID", "randomUUID") AS ID=


I know there is Bug raised while reading data from ORC table. Is there any = workaround apart from reloading data.

-MS







--001a11371e18fb5a770535416f4a--