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 446F3200D2F for ; Wed, 1 Nov 2017 21:04:10 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 42EAE160BEA; Wed, 1 Nov 2017 20:04:10 +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 625C71609EC for ; Wed, 1 Nov 2017 21:04:09 +0100 (CET) Received: (qmail 33719 invoked by uid 500); 1 Nov 2017 20:04:08 -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 33708 invoked by uid 99); 1 Nov 2017 20:04:08 -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, 01 Nov 2017 20:04:07 +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 28F01180582 for ; Wed, 1 Nov 2017 20:04:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.278 X-Spam-Level: * X-Spam-Status: No, score=1.278 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, UNPARSEABLE_RELAY=0.001] autolearn=disabled Received: from mx1-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 7_ZidjTT8B8P for ; Wed, 1 Nov 2017 20:04:04 +0000 (UTC) Received: from orange.com (mta134.mail.business.static.orange.com [80.12.70.34]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 68FEB5FAF9 for ; Wed, 1 Nov 2017 20:04:04 +0000 (UTC) Received: from opfednr05.francetelecom.fr (unknown [xx.xx.xx.69]) by opfednr27.francetelecom.fr (ESMTP service) with ESMTP id DD2CEA09EC for ; Wed, 1 Nov 2017 21:03:58 +0100 (CET) Received: from Exchangemail-eme2.itn.ftgroup (unknown [xx.xx.31.60]) by opfednr05.francetelecom.fr (ESMTP service) with ESMTP id C0F4E2007C for ; Wed, 1 Nov 2017 21:03:58 +0100 (CET) Received: from OPEXCLILM21.corporate.adroot.infra.ftgroup ([fe80::e92a:c932:907e:8f06]) by OPEXCLILM7F.corporate.adroot.infra.ftgroup ([fe80::c1d7:e278:e357:11ad%19]) with mapi id 14.03.0361.001; Wed, 1 Nov 2017 21:03:58 +0100 From: To: "user@hive.apache.org" Subject: Hive JDBC - Method not Supported Thread-Topic: Hive JDBC - Method not Supported Thread-Index: AdNPM9ZBbzOMto/rTum7tgYS42DJdwEGKP2Q Date: Wed, 1 Nov 2017 20:03:57 +0000 Message-ID: <27409_1509566638_59FA28AE_27409_121_1_ECF7BE9FC82A81409C84E3CD1A693EDB8DB70473@OPEXCLILM21.corporate.adroot.infra.ftgroup> Accept-Language: en-US, fr-FR Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.168.234.4] Content-Type: multipart/alternative; boundary="_000_ECF7BE9FC82A81409C84E3CD1A693EDB8DB70473OPEXCLILM21corp_" MIME-Version: 1.0 archived-at: Wed, 01 Nov 2017 20:04:10 -0000 --_000_ECF7BE9FC82A81409C84E3CD1A693EDB8DB70473OPEXCLILM21corp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, I'm trying to use JasperStudio with Hive using JDBC in order to produce rep= orts. As far as I can see, my Hive setup (2.3) seems to work correctly, I c= an interact with it with Hive CLI and connect using beeline. Now when it co= mes to JasperStudio, it seems to work correctly at the beginning, connectio= n is OK, I can even see my table and the fields. I use the JDBC jar provid= ed by Hive in the JDBC directory. But then I get an error message when wanting to go further: "Method Not Sup= ported", here is the full stack trace: net.sf.jasperreports.engine.JRException: java.sql.SQLFeatureNotSupportedExc= eption: Method not supported at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFie= ldsProvider.java:120) at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(= JDBCDataAdapterDescriptor.java:70) at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGe= tFields(DataQueryAdapters.java:518) at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQ= ueryDesignerContainer.java:49) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(Moda= lContext.java:119) Caused by: java.sql.SQLFeatureNotSupportedException: Method not supported at org.apache.hive.jdbc.HiveResultSetMetaData.getTableName(HiveResultSe= tMetaData.java:102) at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFie= ldsProvider.java:112) ... 4 more One can think that it is a pure JasperStudio, but actually it looks like th= is Hive issue: https://issues.apache.org/jira/browse/HIVE-3015 which was a = JDBC bug fixed later. This is why I post in this mailing list. Last but not least: I'm totally new to Hive, and a little bit confused with= version: which one should I take for production: 1.2.2? 2.1.1? 2.2.0? 2.3.= 0? What about JDBC? Thanks a lot for help, St=E9phane ___________________________________________________________________________= ______________________________________________ Ce message et ses pieces jointes peuvent contenir des informations confiden= tielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu= ce message par erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les pieces jointes. Les messages el= ectroniques etant susceptibles d'alteration, Orange decline toute responsabilite si ce message a ete altere, deforme ou = falsifie. Merci. This message and its attachments may contain confidential or privileged inf= ormation that may be protected by law; they should not be distributed, used or copied without authorisation. If you have received this email in error, please notify the sender and dele= te this message and its attachments. As emails may be altered, Orange is not liable for messages that have been = modified, changed or falsified. Thank you. --_000_ECF7BE9FC82A81409C84E3CD1A693EDB8DB70473OPEXCLILM21corp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello all,

 

I’m trying to use JasperStudio with Hive using= JDBC in order to produce reports. As far as I can see, my Hive setup (2.3)= seems to work correctly, I can interact with it with Hive CLI and connect = using beeline. Now when it comes to JasperStudio, it seems to work correctly at the beginning, connection is OK, I can even = see my table and the fields.  I use the JDBC jar provided by Hive in t= he JDBC directory.

 

But then I get an error message when wanting to go f= urther: “Method Not Supported”, here is the full stack trace:


net.sf.jasperreports.engine.JRException: java.sql.SQLFeatureNotSupportedExc= eption: Method not supported
    at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.ge= tFields(JDBCFieldsProvider.java:120)
    at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescri= ptor.getFields(JDBCDataAdapterDescriptor.java:70)
    at com.jaspersoft.studio.property.dataset.dialog.DataQue= ryAdapters.doGetFields(DataQueryAdapters.java:518)
    at com.jaspersoft.studio.data.designer.AQueryDesignerCon= tainer$1.run(AQueryDesignerContainer.java:49)
    at org.eclipse.jface.operation.ModalContext$ModalContext= Thread.run(ModalContext.java:119)
Caused by: java.sql.SQLFeatureNotSupportedException: Method not supported     at org.apache.hive.jdbc.HiveResultSetMetaData.getTableNa= me(HiveResultSetMetaData.java:102)
    at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.ge= tFields(JDBCFieldsProvider.java:112)
    ... 4 more

One can think that it is a pure JasperStudio, but ac= tually it looks like this Hive issue: https://issues.= apache.org/jira/browse/HIVE-3015 which was a JDBC bug fixed later.=

 

This is why I post in this mailing list.<= /p>

 

Last but not least: I’m totally new to Hive, a= nd a little bit confused with version: which one should I take for producti= on: 1.2.2? 2.1.1? 2.2.0? 2.3.0? What about JDBC?

 

Thanks a lot for help,

 

St=E9phane

 

______________________________________________________________________=
___________________________________________________

Ce message et ses pieces jointes peuvent contenir des informations confiden=
tielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu=
 ce message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages el=
ectroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou =
falsifie. Merci.

This message and its attachments may contain confidential or privileged inf=
ormation that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and dele=
te this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been =
modified, changed or falsified.
Thank you.
--_000_ECF7BE9FC82A81409C84E3CD1A693EDB8DB70473OPEXCLILM21corp_--