[jira] [Updated] (DRILL-5607) NullPointer Exception on jdbc source using limit 0
[
https://issues.apache.org/jira/browse/DRILL-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-5607:
---
Affects Version/s: 1.12.0
Description:
Querying a jdbc datasource in a 2 node cluster when 1 node is down throws an
exception when 'limit 0' is used to discover the schema:
{code}
0: jdbc:drill:zk=localhost:2181> !verbose
verbose: on
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 1;
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| person_id | first_name | last_name | address | city | state | zip | json |
bigint_field | smallint_field | numeric_field | boolean_field | double_field |
float_field | real_field | time_field | timestamp_field | date_field |
datetime_field | year_field | text_field | tiny_text_field | medium_text_field
| long_text_field | blob_field | bit_field | enum_field |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| 1 | first_name_1 | last_name_1 | 1401 John F Kennedy Blvd | Philadelphia | PA
| 19107 | { a : 5, b : 6 } | 123456789 | 1 | 10.01 | false | 1.0 | 1.1 | 1.2 |
12:00:01 | 2012-02-29 12:00:01.0 | 2012-02-29 | 2012-02-29 12:00:01.0 |
2015-01-01 | It is a long established fact that a reader will be distracted by
the readable content of a page when looking at its layout | xxx | a medium
piece of text | a longer piece of text this is going on. | [B@79c5636f |
true | XXX |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
1 row selected (0,257 seconds)
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 0;
Error: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
(state=,code=0)
java.sql.SQLException: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
at
org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
at
org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
at sqlline.Commands.execute(Commands.java:841)
at sqlline.Commands.sql(Commands.java:751)
at sqlline.SqlLine.dispatch(SqlLine.java:746)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244)
at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
at
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Affects Version/s: 1.12.0
Still existis in 1.12 release.
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0, 1.10.0, 1.11.0, 1.12.0
> Environment: Latest 1.9 release also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16284190#comment-16284190
]
Holger Kiel commented on DRILL-5702:
+1 LGTM
Thx!
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Assignee: Vitalii Diravka
>Priority: Blocker
> Fix For: 1.12.0
>
> Attachments: drill-jdbc-all-1.12.0-SNAPSHOT.jar
>
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Comment Edited] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16277204#comment-16277204
]
Holger Kiel edited comment on DRILL-5702 at 12/4/17 6:29 PM:
-
Please have a look at file "profile.props" in drill-jdbc-all-1.12.0.jar. This
is part of the content:
{code}
package.namespace.prefix=${package.namespace.prefix}
{code}
When I'm building everything from the repository, my jdbc Driver has the
following instead:
{code}
package.namespace.prefix=oadd.
{code}
The latter works for me.
was (Author: korlawulki):
Please have a look at file "profile.props" in drill-jdbc-all-1.12.0.jar. This
is part of the content:
{code}
package.namespace.prefix=${package.namespace.prefix}
{code}
When I'm building everything from the repository, my jdbc Driver hat the
following instead:
{code}
package.namespace.prefix=oadd.
{code}
The latter works for me.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Assignee: Vitalii Diravka
>Priority: Blocker
> Fix For: 1.12.0
>
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16277204#comment-16277204
]
Holger Kiel commented on DRILL-5702:
Please have a look at file "profile.props" in drill-jdbc-all-1.12.0.jar. This
is part of the content:
{code}
package.namespace.prefix=${package.namespace.prefix}
{code}
When I'm building everything from the repository, my jdbc Driver hat the
following instead:
{code}
package.namespace.prefix=oadd.
{code}
The latter works for me.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Assignee: Vitalii Diravka
>Priority: Blocker
> Fix For: 1.12.0
>
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16275858#comment-16275858
]
Holger Kiel commented on DRILL-5702:
The authenticator is taken from
http://drill.apache.org/docs/creating-custom-authenticators/
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Assignee: Vitalii Diravka
>Priority: Blocker
> Fix For: 1.12.0
>
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16275535#comment-16275535
]
Holger Kiel commented on DRILL-5702:
I'm facing this on different plattforms (Ubuntu 16.04 & SLES as server OS) and
Windows7 & 10 & Ubuntu as clients. Hadoop is version 2.7.3 on the server side.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Comment Edited] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274967#comment-16274967
]
Holger Kiel edited comment on DRILL-5702 at 12/1/17 9:00 PM:
-
WIth drill-jdbc-all-1.12.0.jar (from rc0 binary) connecting to 1.12.0rc0 server:
{code}
Unexpected driver error occurred while connecting to database
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
{code}
was (Author: korlawulki):
WIth drill-jdbc-all-1.12.0.jar (from rc0 binary) connecting to 1.12.0rc0 server:
Unexpected driver error occurred while connecting to database
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Comment Edited] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274967#comment-16274967
]
Holger Kiel edited comment on DRILL-5702 at 12/1/17 8:59 PM:
-
WIth drill-jdbc-all-1.12.0.jar (from rc0 binary) connecting to 1.12.0rc0 server:
Unexpected driver error occurred while connecting to database
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
was (Author: korlawulki):
WIth drill-jdbc-all-1.12.0.jar (from rc0 binary) connecting to 1.12.0rc0 server:
Unexpected driver error occurred while connecting to database
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class
*${package.namespace.prefix}*org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
*{color:red}${package.namespace.prefix}{color}*org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274967#comment-16274967
]
Holger Kiel commented on DRILL-5702:
WIth drill-jdbc-all-1.12.0.jar (from rc0 binary) connecting to 1.12.0rc0 server:
Unexpected driver error occurred while connecting to database
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class
*${package.namespace.prefix}*org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
*{color:red}${package.namespace.prefix}{color}*org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Comment Edited] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274928#comment-16274928
]
Holger Kiel edited comment on DRILL-5702 at 12/1/17 8:27 PM:
-
The error occurs with prebuild 1.11 driver connecting to 1.11 drillbit and with
prebuild 1.12 driver (from rc0) connecting to 1.12 drillbit.
was (Author: korlawulki):
The error occurs with prebuild 1.11 driver connecting to 1.11 drillbit an with
prebuild 1.12 driver (from rc0) connecting to 1.12 drillbit.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274928#comment-16274928
]
Holger Kiel commented on DRILL-5702:
The error occurs with prebuild 1.11 driver connecting to 1.11 drillbit an with
prebuild 1.12 driver (from rc0) connecting to 1.12 drillbit.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16271584#comment-16271584
]
Holger Kiel commented on DRILL-5702:
Same problem with 1.12.0rc0 binary package:
http://home.apache.org/~arina/drill/releases/1.12.0/rc0/
Where as when compiling from latested repository, the jdbc-driver binary is
fine.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (DRILL-5702) Jdbc Driver Class not found
[
https://issues.apache.org/jira/browse/DRILL-5702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16266142#comment-16266142
]
Holger Kiel commented on DRILL-5702:
All files were taken from the binary distribution archive. When building from
source, the error (Maven property appearing in the classpath) doesn't occur.
> Jdbc Driver Class not found
> ---
>
> Key: DRILL-5702
> URL: https://issues.apache.org/jira/browse/DRILL-5702
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
>Affects Versions: 1.11.0
>Reporter: Holger Kiel
>Priority: Critical
>
> Cannot connect to drill cluster after upgrade to new Jar
> drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
> drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
> applications:
> {code}
> java.lang.RuntimeException: java.lang.RuntimeException:
> java.lang.ClassNotFoundException: Class
> ${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
> not found
> at
> oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
> at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
> at
> oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
> at
> oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
> at
> oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
> at
> oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at
> oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> {code}
> Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Created] (DRILL-5702) Jdbc Driver Class not found
Holger Kiel created DRILL-5702:
--
Summary: Jdbc Driver Class not found
Key: DRILL-5702
URL: https://issues.apache.org/jira/browse/DRILL-5702
Project: Apache Drill
Issue Type: Bug
Components: Client - JDBC
Affects Versions: 1.11.0
Reporter: Holger Kiel
Priority: Critical
Cannot connect to drill cluster after upgrade to new Jar
drill-jdbc-all-1.11.0.jar. When replacing Jar file with older release
drill-jdbc-all-1.10.0.jar, connection works again. Tested with various client
applications:
{code}
java.lang.RuntimeException: java.lang.RuntimeException:
java.lang.ClassNotFoundException: Class
${package.namespace.prefix}org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback
not found
at
oadd.org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2227)
at oadd.org.apache.hadoop.security.Groups.(Groups.java:80)
at oadd.org.apache.hadoop.security.Groups.(Groups.java:74)
at
oadd.org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)
at
oadd.org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283)
at
oadd.org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)
at
oadd.org.apache.drill.exec.rpc.security.plain.PlainFactory.createAndLoginUser(PlainFactory.java:63)
at
oadd.org.apache.drill.exec.rpc.user.UserClient.authenticate(UserClient.java:244)
at
oadd.org.apache.drill.exec.rpc.user.UserClient.connect(UserClient.java:171)
at
oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:432)
at
oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:379)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:158)
at
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
at
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at
oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
{code}
Workaround is using the old driver version.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Updated] (DRILL-5607) NullPointer Exception on jdbc source using limit 0
[
https://issues.apache.org/jira/browse/DRILL-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-5607:
---
Affects Version/s: 1.11.0
Description:
Querying a jdbc datasource in a 2 node cluster when 1 node is down throws an
exception when 'limit 0' is used to discover the schema:
{code}
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 1;
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| person_id | first_name | last_name | address | city | state | zip | json |
bigint_field | smallint_field | numeric_field | boolean_field | double_field |
float_field | real_field | time_field | timestamp_field | date_field |
datetime_field | year_field | text_field | tiny_text_field | medium_text_field
| long_text_field | blob_field | bit_field | enum_field |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| 1 | first_name_1 | last_name_1 | 1401 John F Kennedy Blvd | Philadelphia | PA
| 19107 | { a : 5, b : 6 } | 123456789 | 1 | 10.01 | false | 1.0 | 1.1 | 1.2 |
12:00:01 | 2012-02-29 12:00:01.0 | 2012-02-29 | 2012-02-29 12:00:01.0 |
2015-01-01 | It is a long established fact that a reader will be distracted by
the readable content of a page when looking at its layout | xxx | a medium
piece of text | a longer piece of text this is going on. | [B@79c5636f |
true | XXX |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
1 row selected (0,257 seconds)
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 0;
Error: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
(state=,code=0)
java.sql.SQLException: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
at
org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
at
org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
at sqlline.Commands.execute(Commands.java:841)
at sqlline.Commands.sql(Commands.java:751)
at sqlline.SqlLine.dispatch(SqlLine.java:746)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244)
at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
at
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Affects Version/s: 1.11.0
Still exists in 1.11.0 release:
{code}
[Error Id: b729345a-d46d-4b3c-89fd-d9bb601926b4 on localhost:31010]
org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
NullPointerException
[Error Id: b729345a-d46d-4b3c-89fd-d9bb601926b4 on localhost:31010]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:550)
~[drill-common-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:847)
[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:977)
[drill-java-exec-1.11.0.jar:1.11.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:297)
[drill-java-exec-1.11.0.jar:1.11.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[na:1.8.0_131]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[na:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131]
Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected
exception during fragment initialization: null
... 4 common frames omitted
Caused by: java.lang.NullPointerException: null
at
org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit(FindHardDistributionScans.java:55)
~[drill-java-exec-1.11.0.jar:1.11.0]
at org.apache.calcite.rel.core.TableScan.accept(TableScan.java:164)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:273)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:273)
~[calcite-core-1.4.0-drill-r21.jar:1.4.0-drill-r21]
at
org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode(FindHardDistributionScans.java:45)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel(DefaultSqlHandler.java:264)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:292)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:169)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:131)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:79)
~[drill-java-exec-1.11.0.jar:1.11.0]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:1050)
[drill-java-exec-1.11.0.jar:1.11.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:280)
[drill-java-exec-1.11.0.jar:1.11.0]
... 3 common frames omitted
2017-07-29 13:41:32,990 [qtp1765040384-42] ERROR
o.a.d.e.server.rest.QueryResources - Query from Web UI Failed
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
NullPointerException
[Error Id: b729345a-d46d-4b3c-89fd-d9bb601926b4 on localhost:31010]
at
org.apache.drill.exec.rpc.AbstractDisposableUserClientConnection.sendResult(AbstractDisposableUserClientConnection.java:85)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:868)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:977)
~[drill-java-exec-1.11.0.jar:1.11.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:297)
~[drill-java-exec-1.11.0.jar:1.11.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[na:1.8.0_131]
at
[jira] [Updated] (DRILL-5607) NullPointer Exception on jdbc source using limit 0
[
https://issues.apache.org/jira/browse/DRILL-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-5607:
---
Description:
Querying a jdbc datasource throws an exception when 'limit 0' is used to
discover the schema:
{code}
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 1;
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| person_id | first_name | last_name | address | city | state | zip | json |
bigint_field | smallint_field | numeric_field | boolean_field | double_field |
float_field | real_field | time_field | timestamp_field | date_field |
datetime_field | year_field | text_field | tiny_text_field | medium_text_field
| long_text_field | blob_field | bit_field | enum_field |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| 1 | first_name_1 | last_name_1 | 1401 John F Kennedy Blvd | Philadelphia | PA
| 19107 | { a : 5, b : 6 } | 123456789 | 1 | 10.01 | false | 1.0 | 1.1 | 1.2 |
12:00:01 | 2012-02-29 12:00:01.0 | 2012-02-29 | 2012-02-29 12:00:01.0 |
2015-01-01 | It is a long established fact that a reader will be distracted by
the readable content of a page when looking at its layout | xxx | a medium
piece of text | a longer piece of text this is going on. | [B@79c5636f |
true | XXX |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
1 row selected (0,257 seconds)
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 0;
Error: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
(state=,code=0)
java.sql.SQLException: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
at
org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
at
org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
at sqlline.Commands.execute(Commands.java:841)
at sqlline.Commands.sql(Commands.java:751)
at sqlline.SqlLine.dispatch(SqlLine.java:746)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244)
at
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
at
[jira] [Updated] (DRILL-5607) NullPointer Exception on jdbc source using limit 0
[
https://issues.apache.org/jira/browse/DRILL-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-5607:
---
Environment:
mariadb 10.0.29
OpenJDK build 1.8.0_131-8u131-b11-0ubuntu1.16.04.2-b11
was:mariadb 10.0.29
> NullPointer Exception on jdbc source using limit 0
> --
>
> Key: DRILL-5607
> URL: https://issues.apache.org/jira/browse/DRILL-5607
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
>Affects Versions: 1.10.0
> Environment: mariadb 10.0.29
> OpenJDK build 1.8.0_131-8u131-b11-0ubuntu1.16.04.2-b11
>Reporter: Holger Kiel
>
> Querying a jdbc datasource throws an exception when 'limit 0' is used to
> discover the schema:
> {code}
> 0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
> limit 1;
> +---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
> | person_id | first_name | last_name | address | city | state | zip | json |
> bigint_field | smallint_field | numeric_field | boolean_field | double_field
> | float_field | real_field | time_field | timestamp_field | date_field |
> datetime_field | year_field | text_field | tiny_text_field |
> medium_text_field | long_text_field | blob_field | bit_field | enum_field |
> +---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
> | 1 | first_name_1 | last_name_1 | 1401 John F Kennedy Blvd | Philadelphia |
> PA | 19107 | { a : 5, b : 6 } | 123456789 | 1 | 10.01 | false | 1.0 | 1.1 |
> 1.2 | 12:00:01 | 2012-02-29 12:00:01.0 | 2012-02-29 | 2012-02-29 12:00:01.0 |
> 2015-01-01 | It is a long established fact that a reader will be distracted
> by the readable content of a page when looking at its layout | xxx | a medium
> piece of text | a longer piece of text this is going on. | [B@79c5636f |
> true | XXX |
> +---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
> 1 row selected (0,257 seconds)
> 0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
> *limit 0*;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
> (state=,code=0)
> java.sql.SQLException: SYSTEM ERROR: NullPointerException
> [Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
> at
> org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
> at
> org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
> at
> org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
> at
> org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
> at
> org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
> at
> org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180)
> at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
> at
> org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
> at
> org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
> at sqlline.Commands.execute(Commands.java:841)
> at sqlline.Commands.sql(Commands.java:751)
> at sqlline.SqlLine.dispatch(SqlLine.java:746)
> at sqlline.SqlLine.begin(SqlLine.java:621)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
> ERROR: NullPointerException
> [Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
> at
>
[jira] [Created] (DRILL-5607) NullPointer Exception on jdbc source using limit 0
Holger Kiel created DRILL-5607:
--
Summary: NullPointer Exception on jdbc source using limit 0
Key: DRILL-5607
URL: https://issues.apache.org/jira/browse/DRILL-5607
Project: Apache Drill
Issue Type: Bug
Components: Metadata
Affects Versions: 1.10.0
Environment: mariadb 10.0.29
Reporter: Holger Kiel
Querying a jdbc datasource throws an exception when 'limit 0' is used to
discover the schema:
{code}
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
limit 1;
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| person_id | first_name | last_name | address | city | state | zip | json |
bigint_field | smallint_field | numeric_field | boolean_field | double_field |
float_field | real_field | time_field | timestamp_field | date_field |
datetime_field | year_field | text_field | tiny_text_field | medium_text_field
| long_text_field | blob_field | bit_field | enum_field |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
| 1 | first_name_1 | last_name_1 | 1401 John F Kennedy Blvd | Philadelphia | PA
| 19107 | { a : 5, b : 6 } | 123456789 | 1 | 10.01 | false | 1.0 | 1.1 | 1.2 |
12:00:01 | 2012-02-29 12:00:01.0 | 2012-02-29 | 2012-02-29 12:00:01.0 |
2015-01-01 | It is a long established fact that a reader will be distracted by
the readable content of a page when looking at its layout | xxx | a medium
piece of text | a longer piece of text this is going on. | [B@79c5636f |
true | XXX |
+---++---+-+--+---+-+--+--++---+---+--+-+++-+++++-+---+-++---++
1 row selected (0,257 seconds)
0: jdbc:drill:zk=localhost:2181> select * from mysql.drill_mysql_test.person
*limit 0*;
Error: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
(state=,code=0)
java.sql.SQLException: SYSTEM ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
at
org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:561)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1895)
at
org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:61)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
at
org.apache.drill.jdbc.impl.DrillMetaImpl.prepareAndExecute(DrillMetaImpl.java:1100)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.prepareAndExecuteInternal(DrillConnectionImpl.java:180)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:121)
at
org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:101)
at sqlline.Commands.execute(Commands.java:841)
at sqlline.Commands.sql(Commands.java:751)
at sqlline.SqlLine.dispatch(SqlLine.java:746)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: NullPointerException
[Error Id: 977858d8-ed05-4a94-a28b-931ee870826f on localhost:31010]
at
org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343)
at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274)
at
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244)
at
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Affects Version/s: 1.10.0
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0, 1.10.0
> Environment: Latest 1.9 release also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[jira] [Commented] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15713265#comment-15713265
]
Holger Kiel commented on DRILL-4984:
Still a bug in 1.9.0 release.
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 release also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Affects Version/s: 1.9.0
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 release also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Environment:
Latest 1.9 release also 1.8 release version,
mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
was:
Latest 1.9 Snapshot, also 1.8 release version,
mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 release also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Fix Version/s: (was: 1.9.0)
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Fix Version/s: 1.9.0
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
> Fix For: 1.9.0
>
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Holger Kiel updated DRILL-4984:
---
Affects Version/s: (was: 1.9.0)
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15681063#comment-15681063
]
Holger Kiel commented on DRILL-4984:
You are probably right. One shouldn't leave "conatins" uninitialized. And there
is another potential problem with a Null pointer later on. The following
modifications work at least for me:
{code}
---
drill/exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/FindHardDistributionScans.java
2016-08-20 08:04:52.0 +0200
+++
drill-new/exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/FindHardDistributionScans.java
2016-11-20 11:35:27.962504718 +0100
@@ -21,6 +21,7 @@
import org.apache.calcite.rel.RelShuttleImpl;
import org.apache.calcite.rel.core.TableScan;
import org.apache.drill.common.exceptions.DrillRuntimeException;
+import org.apache.drill.exec.physical.base.GroupScan;
import org.apache.drill.exec.planner.fragment.DistributionAffinity;
import org.apache.drill.exec.planner.logical.DrillTable;
import org.apache.drill.exec.planner.logical.DrillTranslatableTable;
@@ -31,7 +32,7 @@
* Visitor to scan the RelNode tree and find if it contains any Scans that
require hard distribution requirements.
*/
class FindHardDistributionScans extends RelShuttleImpl {
- private boolean contains;
+ private boolean contains = false;
/**
* Can the given relTree be executed in single fragment mode?
For now this returns false when the
@@ -50,17 +51,28 @@
@Override
public RelNode visit(TableScan scan) {
DrillTable unwrap;
+DrillTranslatableTable unwrap2;
+GroupScan groupScan;
+
unwrap = scan.getTable().unwrap(DrillTable.class);
if (unwrap == null) {
- unwrap =
scan.getTable().unwrap(DrillTranslatableTable.class).getDrillTable();
+ unwrap2 = scan.getTable().unwrap(DrillTranslatableTable.class);
+ if(unwrap2 != null) {
+unwrap = unwrap2.getDrillTable();
+ }
}
-try {
- if (unwrap.getGroupScan().getDistributionAffinity() ==
DistributionAffinity.HARD) {
-contains = true;
+if (unwrap != null) {
+ try {
+groupScan = unwrap.getGroupScan();
+if (groupScan != null) {
+ if (groupScan.getDistributionAffinity() ==
DistributionAffinity.HARD) {
+contains = true;
+ }
+}
+ } catch (final IOException e) {
+throw new DrillRuntimeException("Failed to get GroupScan from table.");
}
-} catch (final IOException e) {
- throw new DrillRuntimeException("Failed to get GroupScan from table.");
}
return scan;
}
{code}
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
>
[jira] [Commented] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15675285#comment-15675285
]
Holger Kiel commented on DRILL-4984:
This one is important for BI Tools, as they are using it for schema discovery.
Currently, JasperReports Studio for example doesn't work anymore.
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
[
https://issues.apache.org/jira/browse/DRILL-4984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15622085#comment-15622085
]
Holger Kiel commented on DRILL-4984:
Could be solved by adding a check for null in
{{FindHardDistributionScans.java}} @line 55 before calling {{getDrillTable()}}:
{code}
unwrap = scan.getTable().unwrap(DrillTranslatableTable.class).getDrillTable();
{code}
> Limit 0 raises NullPointerException on JDBC storage sources
> ---
>
> Key: DRILL-4984
> URL: https://issues.apache.org/jira/browse/DRILL-4984
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.8.0, 1.9.0
> Environment: Latest 1.9 Snapshot, also 1.8 release version,
> mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
>Reporter: Holger Kiel
>
> NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
> storage source (e.g. Mysql):
> {code}
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
> Error: SYSTEM ERROR: NullPointerException
> [Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: null
> org.apache.drill.exec.work.foreman.Foreman.run():281
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745
> Caused By (java.lang.NullPointerException) null
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
> org.apache.calcite.rel.core.TableScan.accept():166
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
> org.apache.calcite.rel.RelShuttleImpl.visitChild():53
> org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
> org.apache.calcite.rel.RelShuttleImpl.visit():126
> org.apache.calcite.rel.AbstractRelNode.accept():256
>
> org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
> org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
> org.apache.drill.exec.work.foreman.Foreman.run():264
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> 0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
> +-+-+++-+
> | id | first_name | last_name| full_name | manager_id |
> +-+-+++-+
> | 1 | null| Administrator | admin | 0 |
> +-+-+++-+
> 1 row selected (0,235 seconds)
> {code}
> Other datasources are okay:
> {code}
> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> | fqn | filename | filepath | suffix | employee_id | full_name |
> first_name | last_name | position_id | position_title | store_id |
> department_id | birth_date | hire_date | salary | supervisor_id |
> education_level | marital_status | gender | management_role |
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> +--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
> No rows selected (0,309 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (DRILL-4984) Limit 0 raises NullPointerException on JDBC storage sources
Holger Kiel created DRILL-4984:
--
Summary: Limit 0 raises NullPointerException on JDBC storage
sources
Key: DRILL-4984
URL: https://issues.apache.org/jira/browse/DRILL-4984
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.8.0, 1.9.0
Environment: Latest 1.9 Snapshot, also 1.8 release version,
mysql-connector-java-5.1.30, mysql-connector-java-5.1.40
Reporter: Holger Kiel
NullPointerExceptions occur when a query with 'limit 0' is executed on a jdbc
storage source (e.g. Mysql):
{code}
0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 0;
Error: SYSTEM ERROR: NullPointerException
[Error Id: 6cd676fc-6db9-40b3-81d5-c2db044aeb77 on localhost:31010]
(org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
during fragment initialization: null
org.apache.drill.exec.work.foreman.Foreman.run():281
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.lang.NullPointerException) null
org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.visit():55
org.apache.calcite.rel.core.TableScan.accept():166
org.apache.calcite.rel.RelShuttleImpl.visitChild():53
org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
org.apache.calcite.rel.RelShuttleImpl.visit():126
org.apache.calcite.rel.AbstractRelNode.accept():256
org.apache.calcite.rel.RelShuttleImpl.visitChild():53
org.apache.calcite.rel.RelShuttleImpl.visitChildren():68
org.apache.calcite.rel.RelShuttleImpl.visit():126
org.apache.calcite.rel.AbstractRelNode.accept():256
org.apache.drill.exec.planner.sql.handlers.FindHardDistributionScans.canForceSingleMode():45
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():262
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():290
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():123
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():97
org.apache.drill.exec.work.foreman.Foreman.runSQL():1008
org.apache.drill.exec.work.foreman.Foreman.run():264
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745 (state=,code=0)
0: jdbc:drill:zk=local> select * from mysql.sugarcrm.sales_person limit 1;
+-+-+++-+
| id | first_name | last_name| full_name | manager_id |
+-+-+++-+
| 1 | null| Administrator | admin | 0 |
+-+-+++-+
1 row selected (0,235 seconds)
{code}
Other datasources are okay:
{code}
0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 0;
+--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
| fqn | filename | filepath | suffix | employee_id | full_name |
first_name | last_name | position_id | position_title | store_id |
department_id | birth_date | hire_date | salary | supervisor_id |
education_level | marital_status | gender | management_role |
+--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
+--+---+---+-+--++-++--+-+---++-++-++--+-+-+--+
No rows selected (0,309 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
