[jira] [Closed] (DRILL-4291) Ensure the jdbc-all driver jar includes classes required to return VarChar[]

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-4291?page=com.atlassian.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 = conn.createStatement();

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

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

> Ensure the jdbc-all driver jar includes classes required to return VarChar[]
> ----------------------------------------------------------------------------
>
>                 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án 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 seem 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 latest JDBC driver?
> (I'm going to pull the lastest from master to be sure this has not been solved)
> 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>(JsonStringArrayList.java:35)
>     at oadd.org.apache.drill.exec.vector.RepeatedVarCharVector$Accessor.getObject(RepeatedVarCharVector.java:293)
>     at oadd.org.apache.drill.exec.vector.RepeatedVarCharVector$Accessor.getObject(RepeatedVarCharVector.java:290)
>     at oadd.org.apache.drill.exec.vector.accessor.GenericAccessor.getObject(GenericAccessor.java:44)
>     at oadd.org.apache.drill.exec.vector.accessor.BoundCheckingAccessor.getObject(BoundCheckingAccessor.java:148)
>     at org.apache.drill.jdbc.impl.TypeConvertingSqlAccessor.getObject(TypeConvertingSqlAccessor.java:795)
>     at org.apache.drill.jdbc.impl.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:179)
>     at oadd.net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:351)
>     at org.apache.drill.jdbc.impl.DrillResultSetImpl.getObject(DrillResultSetImpl.java:420)
> Regards,
>  -Stefan



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