Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Sun, 19 Jun 2016 11:25:05 +0000 (UTC)
From: "Khurram Faraaz (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12932750.1453305248000.37711.1466335505199@Atlassian.JIRA>
In-Reply-To: <JIRA.12932750.1453305248000@Atlassian.JIRA>
References: <JIRA.12932750.1453305248000@Atlassian.JIRA> <JIRA.12932750.1453305248404@arcas>
Subject: [jira] [Closed] (DRILL-4291) Ensure the jdbc-all driver jar
 includes classes required to return VarChar[]
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Sun, 19 Jun 2016 11:25:07 -0000


     [ https://issues.apache.org/jira/browse/DRILL-4291?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Khurram Faraaz closed DRILL-4291.
---------------------------------

Verified using the below snippet on Drill 1.7.0 commit ID: 6286c0a4

Statement stmt =3D conn.createStatement();

                String query =3D "select * from `types.json`";
                ResultSet rs =3D stmt.executeQuery(query);

                while (rs.next()) {
                int columnCount =3D rs.getMetaData().getColumnCount();
                    for(int i =3D 1; i < columnCount+1; i++){
                        System.out.print(rs.getObject(i));
                        System.out.print('\t');
                    }
                }
                if (rs !=3D null)
                    rs.close();
                stmt.close();
                conn.close();

> Ensure the jdbc-all driver jar includes classes required to return VarCha=
r[]
> -------------------------------------------------------------------------=
---
>
>                 Key: DRILL-4291
>                 URL: https://issues.apache.org/jira/browse/DRILL-4291
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>    Affects Versions: 0.5.0
>         Environment: Linux / 1.5-SNAPSHOT
>            Reporter: Stef=C3=A1n Baxter
>            Assignee: Jacques Nadeau
>             Fix For: 1.5.0
>
>
> Hi,
> We are using the 1.5-SNAPSHOT version of the JDBC drilver (all) and we se=
em to be getting this old thing:
> https://issues.apache.org/jira/browse/DRILL-2482
> We are either doing something wrong or this or this is a regression. Has =
anyone else experienced not being able to get nested structures via the lat=
est JDBC driver?
> (I'm going to pull the lastest from master to be sure this has not been s=
olved)
> The error we get when accessing a field containing a sub-structure is :
> java.lang.NoClassDefFoundError: org/apache/hadoop/io/Text
>     at oadd.org.apache.drill.exec.util.JsonStringArrayList.<clinit>(JsonS=
tringArrayList.java:35)
>     at oadd.org.apache.drill.exec.vector.RepeatedVarCharVector$Accessor.g=
etObject(RepeatedVarCharVector.java:293)
>     at oadd.org.apache.drill.exec.vector.RepeatedVarCharVector$Accessor.g=
etObject(RepeatedVarCharVector.java:290)
>     at oadd.org.apache.drill.exec.vector.accessor.GenericAccessor.getObje=
ct(GenericAccessor.java:44)
>     at oadd.org.apache.drill.exec.vector.accessor.BoundCheckingAccessor.g=
etObject(BoundCheckingAccessor.java:148)
>     at org.apache.drill.jdbc.impl.TypeConvertingSqlAccessor.getObject(Typ=
eConvertingSqlAccessor.java:795)
>     at org.apache.drill.jdbc.impl.AvaticaDrillSqlAccessor.getObject(Avati=
caDrillSqlAccessor.java:179)
>     at oadd.net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResu=
ltSet.java:351)
>     at org.apache.drill.jdbc.impl.DrillResultSetImpl.getObject(DrillResul=
tSetImpl.java:420)
> Regards,
>  -Stefan


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)