[jira] [Created] (DRILL-7051) Upgrade jetty
Veera Naranammalpuram created DRILL-7051:
Summary: Upgrade jetty
Key: DRILL-7051
URL: https://issues.apache.org/jira/browse/DRILL-7051
Project: Apache Drill
Issue Type: Improvement
Components: Web Server
Affects Versions: 1.15.0
Reporter: Veera Naranammalpuram
Is Drill using a version of jetty web server that's really old? The jar's
suggest it's using jetty 9.1 that was built sometime in 2014?
{noformat}
-rw-r--r-- 1 veeranaranammalpuram staff 15988 Nov 20 2017
jetty-continuation-9.1.1.v20140108.jar
-rw-r--r-- 1 veeranaranammalpuram staff 103288 Nov 20 2017
jetty-http-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 101519 Nov 20 2017
jetty-io-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 95906 Nov 20 2017
jetty-security-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 401593 Nov 20 2017
jetty-server-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 110992 Nov 20 2017
jetty-servlet-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 119215 Nov 20 2017
jetty-servlets-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 341683 Nov 20 2017
jetty-util-9.1.5.v20140505.jar
-rw-r--r-- 1 veeranaranammalpuram staff 38707 Dec 21 15:42
jetty-util-ajax-9.3.19.v20170502.jar
-rw-r--r-- 1 veeranaranammalpuram staff 111466 Nov 20 2017
jetty-webapp-9.1.1.v20140108.jar
-rw-r--r-- 1 veeranaranammalpuram staff 41763 Nov 20 2017
jetty-xml-9.1.1.v20140108.jar {noformat}
This version is shown as deprecated:
[https://www.eclipse.org/jetty/documentation/current/what-jetty-version.html#d0e203]
Opening this to upgrade jetty to the latest stable supported version.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (DRILL-7048) Implement JDBC Statement.setMaxRows() with System Option
[ https://issues.apache.org/jira/browse/DRILL-7048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-7048: Summary: Implement JDBC Statement.setMaxRows() with System Option (was: Implement JDBC Statement.setMaxRows() ) > Implement JDBC Statement.setMaxRows() with System Option > > > Key: DRILL-7048 > URL: https://issues.apache.org/jira/browse/DRILL-7048 > Project: Apache Drill > Issue Type: New Feature > Components: Client - JDBC, Query Planning & Optimization >Affects Versions: 1.15.0 >Reporter: Kunal Khatua >Assignee: Kunal Khatua >Priority: Major > Fix For: 1.16.0 > > > With DRILL-6960, the webUI will get an auto-limit on the number of results > fetched. > Since more of the plumbing is already there, it makes sense to provide the > same for the JDBC client. > In addition, it would be nice if the Server can have a pre-defined value as > well (default 0; i.e. no limit) so that an _admin_ would be able to ensure a > max limit on the resultset size as well. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (DRILL-7050) RexNode convert exception in subquery
[
https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pritesh Maker reassigned DRILL-7050:
Assignee: Hanumath Rao Maduri
> RexNode convert exception in subquery
> -
>
> Key: DRILL-7050
> URL: https://issues.apache.org/jira/browse/DRILL-7050
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.14.0, 1.15.0
>Reporter: Oleg Zinoviev
>Assignee: Hanumath Rao Maduri
>Priority: Major
>
> If the query contains a subquery whose filters are associated with the main
> query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent
> Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
> Steps to reproduce:
> 1) Create source table (or view, doesn't matter)
> {code:sql}
> create table dfs.root.source as (
> select 1 as id union all select 2 as id
> )
> {code}
> 2) Execute query
> {code:sql}
> select t1.id,
> (select count(t2.id)
> from dfs.root.source t2 where t2.id = t1.id)
> from dfs.root.source t1
> {code}
> Reason:
> Method
> {code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
> call {code:java}RexBuilder.makeCorrel{code} in some cases
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Closed] (DRILL-7022) Partition pruning is not happening the first time after the metadata auto refresh
[
https://issues.apache.org/jira/browse/DRILL-7022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anton Gozhiy closed DRILL-7022.
---
> Partition pruning is not happening the first time after the metadata auto
> refresh
> -
>
> Key: DRILL-7022
> URL: https://issues.apache.org/jira/browse/DRILL-7022
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata, Storage - Parquet
>Affects Versions: 1.15.0
>Reporter: Anton Gozhiy
>Assignee: Volodymyr Vysotskyi
>Priority: Major
> Labels: ready-to-commit
> Fix For: 1.16.0
>
>
> *Data creation:*
> # Create table:
> {code:sql}
> create table dfs.tmp.`orders`
> partition by (o_orderstatus)
> as select * from cp.`tpch/orders.parquet`
> {code}
> # Create table metadata:
> {code:sql}
> refresh table metadata dfs.tmp.`orders`
> {code}
> *Steps:*
> # Modify the table to trigger metadata auto refresh:
> {noformat}
> hadoop fs -mkdir /tmp/orders/111
> {noformat}
> # Run the query:
> {code:sql}
> explain plan for
> select * from dfs.tmp.`orders`
> where o_orderstatus = 'O' and o_orderdate < '1995-03-10'
> {code}
> *Expected result:*
> Partition pruning happens:
> {noformat}
> ... numFiles=1, numRowGroups=1, usedMetadataFile=true ...
> {noformat}
> *Actual result:*
> Partition pruning doesn't happen:
> {noformat}
> ... numFiles=1, numRowGroups=3, usedMetadataFile=true
> {noformat}
> *Note:* It is being reproduced only the first time after auto refresh, after
> repeating the query it works as expected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (DRILL-7022) Partition pruning is not happening the first time after the metadata auto refresh
[
https://issues.apache.org/jira/browse/DRILL-7022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16775348#comment-16775348
]
Anton Gozhiy commented on DRILL-7022:
-
Tested with Drill 1.16.0-SNAPSHOT (commit
ad63b70478674185c438682fc0ccd7ca191da1d5)
Cases verified:
- The case from the bug.
- Verified that metadata was regenerated only one time after the modification.
- Removed the metadata and ran queries.
- Generated it again.
> Partition pruning is not happening the first time after the metadata auto
> refresh
> -
>
> Key: DRILL-7022
> URL: https://issues.apache.org/jira/browse/DRILL-7022
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata, Storage - Parquet
>Affects Versions: 1.15.0
>Reporter: Anton Gozhiy
>Assignee: Volodymyr Vysotskyi
>Priority: Major
> Labels: ready-to-commit
> Fix For: 1.16.0
>
>
> *Data creation:*
> # Create table:
> {code:sql}
> create table dfs.tmp.`orders`
> partition by (o_orderstatus)
> as select * from cp.`tpch/orders.parquet`
> {code}
> # Create table metadata:
> {code:sql}
> refresh table metadata dfs.tmp.`orders`
> {code}
> *Steps:*
> # Modify the table to trigger metadata auto refresh:
> {noformat}
> hadoop fs -mkdir /tmp/orders/111
> {noformat}
> # Run the query:
> {code:sql}
> explain plan for
> select * from dfs.tmp.`orders`
> where o_orderstatus = 'O' and o_orderdate < '1995-03-10'
> {code}
> *Expected result:*
> Partition pruning happens:
> {noformat}
> ... numFiles=1, numRowGroups=1, usedMetadataFile=true ...
> {noformat}
> *Actual result:*
> Partition pruning doesn't happen:
> {noformat}
> ... numFiles=1, numRowGroups=3, usedMetadataFile=true
> {noformat}
> *Note:* It is being reproduced only the first time after auto refresh, after
> repeating the query it works as expected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (DRILL-7050) RexNode convert exception in subquery
[
https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleg Zinoviev updated DRILL-7050:
-
Description:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent Drill
expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
Steps to reproduce:
1) Create source table (or view, doesn't matter)
{code:sql}
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
{code}
2) Execute query
{code:sql}
select t1.id,
(select count(t2.id)
from dfs.root.source t2 where t2.id = t1.id)
from dfs.root.source t1
{code}
Reason:
Method
{code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
call {code:java}RexBuilder.makeCorrel{code} in some cases
was:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent Drill
expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
Steps to reproduce:
1) Create source table (or view, doesn't matter)
{code:sql}
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
{code}
2) Execute query
{code:sql}
select t1.id,
(select count(t2.id)
from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
{code}
Reason:
Method
{code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
call {code:java}RexBuilder.makeCorrel{code} in some cases
> RexNode convert exception in subquery
> -
>
> Key: DRILL-7050
> URL: https://issues.apache.org/jira/browse/DRILL-7050
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.14.0, 1.15.0
>Reporter: Oleg Zinoviev
>Priority: Major
>
> If the query contains a subquery whose filters are associated with the main
> query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent
> Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
> Steps to reproduce:
> 1) Create source table (or view, doesn't matter)
> {code:sql}
> create table dfs.root.source as (
> select 1 as id union all select 2 as id
> )
> {code}
> 2) Execute query
> {code:sql}
> select t1.id,
> (select count(t2.id)
> from dfs.root.source t2 where t2.id = t1.id)
> from dfs.root.source t1
> {code}
> Reason:
> Method
> {code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
> call {code:java}RexBuilder.makeCorrel{code} in some cases
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (DRILL-7050) RexNode convert exception in subquery
[
https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleg Zinoviev updated DRILL-7050:
-
Description:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent Drill
expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
Steps to reproduce:
1) Create source table (or view, doesn't matter)
{code:sql}
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
{code}
2) Execute query
{code:sql}
select t1.id,
(select count(t2.id)
from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
{code}
Reason:
Method
{code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
call {code:java}RexBuilder.makeCorrel{code} in some cases
was:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: ```PLAN ERROR: Cannot convert RexNode to equivalent
Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable```
Steps to reproduce:
1) Create source table (or view, doesn't matter)
{code:sql}
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
{code}
2) Execute query
{code:sql}
select t1.id,
(select count(t2.id)
from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
{code}
Reason:
Method
{code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
call {code:java}RexBuilder.makeCorrel{code} in some cases
> RexNode convert exception in subquery
> -
>
> Key: DRILL-7050
> URL: https://issues.apache.org/jira/browse/DRILL-7050
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.14.0, 1.15.0
>Reporter: Oleg Zinoviev
>Priority: Major
>
> If the query contains a subquery whose filters are associated with the main
> query, an error occurs: *PLAN ERROR: Cannot convert RexNode to equivalent
> Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable*
> Steps to reproduce:
> 1) Create source table (or view, doesn't matter)
> {code:sql}
> create table dfs.root.source as (
> select 1 as id union all select 2 as id
> )
> {code}
> 2) Execute query
> {code:sql}
> select t1.id,
> (select count(t2.id)
> from storage.datasets.source t2 where t2.id = t1.id)
> from storage.datasets.source t1
> {code}
> Reason:
> Method
> {code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
> call {code:java}RexBuilder.makeCorrel{code} in some cases
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Created] (DRILL-7050) RexNode convert exception in subquery
Oleg Zinoviev created DRILL-7050: Summary: RexNode convert exception in subquery Key: DRILL-7050 URL: https://issues.apache.org/jira/browse/DRILL-7050 Project: Apache Drill Issue Type: Bug Affects Versions: 1.15.0, 1.14.0 Reporter: Oleg Zinoviev If the query contains a subquery whose filters are associated with the main query, an error occurs: ```PLAN ERROR: Cannot convert RexNode to equivalent Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable``` Steps to reproduce: 1) Create source table (or view, doesn't matter) ```sql create table dfs.root.source as ( select 1 as id union all select 2 as id ) ``` 2) Execute query ```sql select t1.id, (select count(t2.id) from storage.datasets.source t2 where t2.id = t1.id) from storage.datasets.source t1 ``` Reason: Method ```org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp``` call ```RexBuilder.makeCorrel``` in some cases -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (DRILL-7050) RexNode convert exception in subquery
[
https://issues.apache.org/jira/browse/DRILL-7050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleg Zinoviev updated DRILL-7050:
-
Description:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: ```PLAN ERROR: Cannot convert RexNode to equivalent
Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable```
Steps to reproduce:
1) Create source table (or view, doesn't matter)
{code:sql}
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
{code}
2) Execute query
{code:sql}
select t1.id,
(select count(t2.id)
from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
{code}
Reason:
Method
{code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
call {code:java}RexBuilder.makeCorrel{code} in some cases
was:
If the query contains a subquery whose filters are associated with the main
query, an error occurs: ```PLAN ERROR: Cannot convert RexNode to equivalent
Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable```
Steps to reproduce:
1) Create source table (or view, doesn't matter)
```sql
create table dfs.root.source as (
select 1 as id union all select 2 as id
)
```
2) Execute query
```sql
select t1.id,
(select count(t2.id)
from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
```
Reason:
Method ```org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp```
call ```RexBuilder.makeCorrel``` in some cases
> RexNode convert exception in subquery
> -
>
> Key: DRILL-7050
> URL: https://issues.apache.org/jira/browse/DRILL-7050
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.14.0, 1.15.0
>Reporter: Oleg Zinoviev
>Priority: Major
>
> If the query contains a subquery whose filters are associated with the main
> query, an error occurs: ```PLAN ERROR: Cannot convert RexNode to equivalent
> Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable```
> Steps to reproduce:
> 1) Create source table (or view, doesn't matter)
> {code:sql}
> create table dfs.root.source as (
> select 1 as id union all select 2 as id
> )
> {code}
> 2) Execute query
> {code:sql}
> select t1.id,
> (select count(t2.id)
> from storage.datasets.source t2 where t2.id = t1.id)
> from storage.datasets.source t1
> {code}
> Reason:
> Method
> {code:java}org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp{code}
> call {code:java}RexBuilder.makeCorrel{code} in some cases
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (DRILL-7042) Apache Drill v1.15.0 failed to generate deb/rpm package
[ https://issues.apache.org/jira/browse/DRILL-7042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16775024#comment-16775024 ] Naresh Bhat commented on DRILL-7042: The patches are maintained here https://git.linaro.org/people/naresh.bhat/apache/drill.git/ from "v1.15.0_v1" > Apache Drill v1.15.0 failed to generate deb/rpm package > --- > > Key: DRILL-7042 > URL: https://issues.apache.org/jira/browse/DRILL-7042 > Project: Apache Drill > Issue Type: Improvement > Components: Tools, Build & Test >Affects Versions: 1.15.0 > Environment: Ubuntu/Debian/CentOS installed on ARM64 server machine. >Reporter: Naresh Bhat >Assignee: Naresh Bhat >Priority: Major > Fix For: 1.16.0 > > > I tried to create a debian/rpm package on ARM64 machine, But it failed to > generate the debian/rpm package on Ubuntu/CentOS machine. It is required to > fix the pom.xml file under distribution folder. > Error logs while generating DEB package: > = > drill$ git branch > master > * v1.15.0 > drill$ mvn clean -X package -Pdeb -DskipTests > . > .. > [INFO] Creating debian package: target/drill-1.15.0.deb > [INFO] Building data > [ERROR] Failed to create debian package target/drill-1.15.0.deb > org.vafer.jdeb.PackagingException: Failed to create debian package > target/drill-1.15.0.deb > at org.vafer.jdeb.maven.DebMaker.makeDeb (DebMaker.java:247) > at org.vafer.jdeb.maven.DebMojo.execute (DebMojo.java:416) > at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo > (DefaultBuildPluginManager.java:137) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:210) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:148) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:117) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:81) > at > org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build > (SingleThreadedBuilder.java:56) > at org.apache.maven.lifecycle.internal.LifecycleStarter.execute > (LifecycleStarter.java:128) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) > at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105) > at org.apache.maven.cli.MavenCli.execute (MavenCli.java:956) > at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:288) > at org.apache.maven.cli.MavenCli.main (MavenCli.java:192) > at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke > (NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke (Method.java:498) > at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced > (Launcher.java:289) > at org.codehaus.plexus.classworlds.launcher.Launcher.launch > (Launcher.java:229) > at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode > (Launcher.java:415) > at org.codehaus.plexus.classworlds.launcher.Launcher.main > (Launcher.java:356) > Caused by: org.vafer.jdeb.PackagingException: Could not create deb package > at org.vafer.jdeb.Processor.createDeb (Processor.java:172) > at org.vafer.jdeb.maven.DebMaker.makeDeb (DebMaker.java:244) > at org.vafer.jdeb.maven.DebMojo.execute (DebMojo.java:416) > at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo > (DefaultBuildPluginManager.java:137) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:210) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:148) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:117) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:81) > at > org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build > (SingleThreadedBuilder.java:56) > at org.apache.maven.lifecycle.internal.LifecycleStarter.execute > (LifecycleStarter.java:128) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) > at org.apache.m
[jira] [Commented] (DRILL-7042) Apache Drill v1.15.0 failed to generate deb/rpm package
[ https://issues.apache.org/jira/browse/DRILL-7042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774974#comment-16774974 ] Naresh Bhat commented on DRILL-7042: I have installed and tested RPM/DEB packages. I also did a query to sample data on Ubuntu/CentOS installed ARM64 machines. Which works fine. > Apache Drill v1.15.0 failed to generate deb/rpm package > --- > > Key: DRILL-7042 > URL: https://issues.apache.org/jira/browse/DRILL-7042 > Project: Apache Drill > Issue Type: Improvement > Components: Tools, Build & Test >Affects Versions: 1.15.0 > Environment: Ubuntu/Debian/CentOS installed on ARM64 server machine. >Reporter: Naresh Bhat >Assignee: Naresh Bhat >Priority: Major > Fix For: 1.16.0 > > > I tried to create a debian/rpm package on ARM64 machine, But it failed to > generate the debian/rpm package on Ubuntu/CentOS machine. It is required to > fix the pom.xml file under distribution folder. > Error logs while generating DEB package: > = > drill$ git branch > master > * v1.15.0 > drill$ mvn clean -X package -Pdeb -DskipTests > . > .. > [INFO] Creating debian package: target/drill-1.15.0.deb > [INFO] Building data > [ERROR] Failed to create debian package target/drill-1.15.0.deb > org.vafer.jdeb.PackagingException: Failed to create debian package > target/drill-1.15.0.deb > at org.vafer.jdeb.maven.DebMaker.makeDeb (DebMaker.java:247) > at org.vafer.jdeb.maven.DebMojo.execute (DebMojo.java:416) > at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo > (DefaultBuildPluginManager.java:137) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:210) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:148) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:117) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:81) > at > org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build > (SingleThreadedBuilder.java:56) > at org.apache.maven.lifecycle.internal.LifecycleStarter.execute > (LifecycleStarter.java:128) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) > at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105) > at org.apache.maven.cli.MavenCli.execute (MavenCli.java:956) > at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:288) > at org.apache.maven.cli.MavenCli.main (MavenCli.java:192) > at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke > (NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke (Method.java:498) > at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced > (Launcher.java:289) > at org.codehaus.plexus.classworlds.launcher.Launcher.launch > (Launcher.java:229) > at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode > (Launcher.java:415) > at org.codehaus.plexus.classworlds.launcher.Launcher.main > (Launcher.java:356) > Caused by: org.vafer.jdeb.PackagingException: Could not create deb package > at org.vafer.jdeb.Processor.createDeb (Processor.java:172) > at org.vafer.jdeb.maven.DebMaker.makeDeb (DebMaker.java:244) > at org.vafer.jdeb.maven.DebMojo.execute (DebMojo.java:416) > at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo > (DefaultBuildPluginManager.java:137) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:210) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute > (MojoExecutor.java:148) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:117) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject > (LifecycleModuleBuilder.java:81) > at > org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build > (SingleThreadedBuilder.java:56) > at org.apache.maven.lifecycle.internal.LifecycleStarter.execute > (LifecycleStarter.java:128) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305) > at org.apache.maven.DefaultMaven.doExecute (DefaultMav
[jira] [Updated] (DRILL-6734) Unable to find value vector of path `EXPR$0`, returning null instance.
[
https://issues.apache.org/jira/browse/DRILL-6734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitalii Diravka updated DRILL-6734:
---
Labels: ready-to-commit (was: )
> Unable to find value vector of path `EXPR$0`, returning null instance.
> --
>
> Key: DRILL-6734
> URL: https://issues.apache.org/jira/browse/DRILL-6734
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
>Affects Versions: 1.14.0
> Environment: Apache Drill version 1.14.0 running on CentOS 7.0.1406.
> MySQL version 5.5.43 running on CentOS 6.4.
> MySQL connector/j version 5.1.44.
>Reporter: Cheolgoo Kang
>Assignee: Volodymyr Vysotskyi
>Priority: Major
> Labels: ready-to-commit
> Fix For: 1.16.0
>
>
> Expressions in a query against JDBC without alias returns null as their value.
> I was trying to run this sample query to retrieve count of a MySQL table
> connected to Drill through the RDBMS storage plugin:
> {code}
> select count(*) from ngmysql.information_schema.`PROCESSLIST`
> {code}
> which returns
> {code}
> EXPR$0
> -
>
> {code}
> and you could find this warning from the log:
> {quote}
> Unable to find value vector of path `EXPR$0`, returning null instance.
> {quote}
> But it works fine if you give an alias to the expression like this:
> {code}
> select count(*) as num from ngmysql.information_schema.`PROCESSLIST`;
> {code}
> which would end up giving this:
> {code}
> num
> --
> 16
> {code}
> Here's the portion of logs regarding the sample query:
> {code}
> 2018-09-07 21:44:52,709 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:foreman] INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 246d0eaa-f8e6-9536-af0c-1df3932cce9f: select count(*) from
> ngmysql.information_schema.`PROCESSLIST`
> 2018-09-07 21:44:52,752 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 246d0eaa-f8e6-9536-af0c-1df3932cce9f:0:0: State change requested
> AWAITING_ALLOCATION --> RUNNING
> 2018-09-07 21:44:52,753 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 246d0eaa-f8e6-9536-af0c-1df3932cce9f:0:0: State to report: RUNNING
> 2018-09-07 21:44:52,756 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:frag:0:0] WARN
> o.a.d.e.e.ExpressionTreeMaterializer - Unable to find value vector of path
> `EXPR$0`, returning null instance.
> 2018-09-07 21:44:52,759 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 246d0eaa-f8e6-9536-af0c-1df3932cce9f:0:0: State change requested RUNNING -->
> FINISHED
> 2018-09-07 21:44:52,760 [246d0eaa-f8e6-9536-af0c-1df3932cce9f:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 246d0eaa-f8e6-9536-af0c-1df3932cce9f:0:0: State to report: FINISHED
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (DRILL-7042) Apache Drill v1.15.0 failed to generate deb/rpm package
[ https://issues.apache.org/jira/browse/DRILL-7042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774969#comment-16774969 ] Naresh Bhat commented on DRILL-7042: drill$ sudo dpkg -i target/drill-1.15.0.deb (Reading database ... 244741 files and directories currently installed.) Preparing to unpack target/drill-1.15.0.deb ... Unpacking drill (1.0-SNAPSHOT) over (1.0-SNAPSHOT) ... Setting up drill (1.0-SNAPSHOT) ... Processing triggers for systemd (237-3ubuntu10.11) ... Processing triggers for ureadahead (0.100.0-20) ... drill$ sudo dpkg -L drill /opt /opt/drill /opt/drill//git.properties /opt/drill//KEYS /opt/drill//LICENSE /opt/drill//NOTICE /opt/drill//README.md /opt/drill/jars /opt/drill/jars//3rdparty /opt/drill/jars/3rdparty /opt/drill/jars//3rdparty/fedora /opt/drill/jars//3rdparty/linux /opt/drill/jars//3rdparty/osx /opt/drill/jars//3rdparty/windows /opt/drill/jars//classb /opt/drill/jars//ext /opt/drill/jars//jdbc-driver /opt/drill/jars//tools /opt/drill/jars//3rdparty/HikariCP-2.5.1.jar /opt/drill/jars//3rdparty/aggdesigner-algorithm-6.0.jar /opt/drill/jars//3rdparty/animal-sniffer-annotations-1.14.jar /opt/drill/jars//3rdparty/annotations-2.0.1.jar /opt/drill/jars//3rdparty/antlr-runtime-3.5.2.jar /opt/drill/jars//3rdparty/antlr4-runtime-4.7.1.jar /opt/drill/jars//3rdparty/aopalliance-1.0.jar /opt/drill/jars//3rdparty/apacheds-i18n-2.0.0-M15.jar /opt/drill/jars//3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar /opt/drill/jars//3rdparty/api-asn1-api-1.0.0-M20.jar /opt/drill/jars//3rdparty/api-util-1.0.0-M20.jar /opt/drill/jars//3rdparty/asm-7.0.jar /opt/drill/jars//3rdparty/asm-analysis-7.0.jar /opt/drill/jars//3rdparty/asm-commons-7.0.jar /opt/drill/jars//3rdparty/asm-tree-7.0.jar /opt/drill/jars//3rdparty/asm-util-7.0.jar /opt/drill/jars//3rdparty/async-1.4.1.jar /opt/drill/jars//3rdparty/audience-annotations-0.5.0.jar /opt/drill/jars//3rdparty/avatica-1.12.0.jar /opt/drill/jars//3rdparty/avro-1.8.2.jar /opt/drill/jars//3rdparty/avro-ipc-1.8.2.jar /opt/drill/jars//3rdparty/avro-mapred-1.8.2.jar /opt/drill/jars//3rdparty/aws-java-sdk-1.7.4.jar /opt/drill/jars//3rdparty/bcpkix-jdk15on-1.60.jar /opt/drill/jars//3rdparty/bcprov-jdk15on-1.60.jar /opt/drill/jars//3rdparty/bonecp-0.8.0.RELEASE.jar /opt/drill/jars//3rdparty/byte-buddy-1.9.3.jar /opt/drill/jars//3rdparty/byte-buddy-agent-1.9.3.jar /opt/drill/jars//3rdparty/calcite-core-1.17.0-drill-r2.jar /opt/drill/jars//3rdparty/calcite-linq4j-1.17.0-drill-r2.jar /opt/drill/jars//3rdparty/commons-beanutils-1.9.2.jar /opt/drill/jars//3rdparty/commons-beanutils-core-1.8.0.jar /opt/drill/jars//3rdparty/commons-cli-1.2.jar /opt/drill/jars//3rdparty/commons-codec-1.10.jar /opt/drill/jars//3rdparty/commons-collections-3.2.2.jar /opt/drill/jars//3rdparty/commons-compiler-3.0.11.jar /opt/drill/jars//3rdparty/commons-compress-1.4.1.jar /opt/drill/jars//3rdparty/commons-configuration-1.6.jar /opt/drill/jars//3rdparty/commons-crypto-1.0.0.jar /opt/drill/jars//3rdparty/commons-dbcp-1.4.jar /opt/drill/jars//3rdparty/commons-dbcp2-2.4.0.jar /opt/drill/jars//3rdparty/commons-digester-1.8.jar /opt/drill/jars//3rdparty/commons-httpclient-3.1.jar /opt/drill/jars//3rdparty/commons-io-2.4.jar /opt/drill/jars//3rdparty/commons-lang-2.6.jar /opt/drill/jars//3rdparty/commons-lang3-3.2.jar /opt/drill/jars//3rdparty/commons-math-2.2.jar /opt/drill/jars//3rdparty/commons-math3-3.1.1.jar /opt/drill/jars//3rdparty/commons-net-3.1.jar /opt/drill/jars//3rdparty/commons-pool-1.6.jar /opt/drill/jars//3rdparty/commons-pool2-2.6.0.jar /opt/drill/jars//3rdparty/commons-text-1.4.jar /opt/drill/jars//3rdparty/commons-validator-1.6.jar /opt/drill/jars//3rdparty/config-1.0.0.jar /opt/drill/jars//3rdparty/converter-jackson-2.1.0.jar /opt/drill/jars//3rdparty/curator-client-2.7.1.jar /opt/drill/jars//3rdparty/curator-framework-2.7.1.jar /opt/drill/jars//3rdparty/curator-recipes-2.7.1.jar /opt/drill/jars//3rdparty/curator-x-discovery-2.7.1.jar /opt/drill/jars//3rdparty/datanucleus-api-jdo-4.2.4.jar /opt/drill/jars//3rdparty/datanucleus-core-4.1.17.jar /opt/drill/jars//3rdparty/datanucleus-rdbms-4.1.19.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.lilith.sender-0.9.44.jar /opt/drill/jars//3rdparty/de.huxhorn.sulky.codec-0.9.17.jar /opt/drill/jars//3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar /opt/drill/jars
[jira] [Commented] (DRILL-7042) Apache Drill v1.15.0 failed to generate deb/rpm package
[ https://issues.apache.org/jira/browse/DRILL-7042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774966#comment-16774966 ] Naresh Bhat commented on DRILL-7042: [centos@centos noarch]$ rpm -qlp drill-1.0-SNAPSHOT.noarch.rpm /etc/drill/conf /etc/drill/conf/core-site-example.xml /etc/drill/conf/distrib-env.sh /etc/drill/conf/distrib-setup.sh /etc/drill/conf/drill-am-log.xml /etc/drill/conf/drill-env.sh /etc/drill/conf/drill-on-yarn-example.conf /etc/drill/conf/drill-override-example.conf /etc/drill/conf/drill-override.conf /etc/drill/conf/drill-setup.sh /etc/drill/conf/drill-sqlline-override-example.conf /etc/drill/conf/logback.xml /etc/drill/conf/saffron.properties /etc/drill/conf/storage-plugins-override-example.conf /etc/drill/conf/yarn-client-log.xml /etc/init.d/drillbit /opt/drill/KEYS /opt/drill/LICENSE /opt/drill/NOTICE /opt/drill/README.md /opt/drill/bin /opt/drill/bin/auto-setup.sh /opt/drill/bin/drill-am.sh /opt/drill/bin/drill-conf /opt/drill/bin/drill-config.sh /opt/drill/bin/drill-embedded /opt/drill/bin/drill-localhost /opt/drill/bin/drill-on-yarn.sh /opt/drill/bin/drillbit.sh /opt/drill/bin/hadoop-excludes.txt /opt/drill/bin/runbit /opt/drill/bin/sqlline /opt/drill/bin/sqlline.bat /opt/drill/bin/submit_plan /opt/drill/bin/yarn-drillbit.sh /opt/drill/git.properties /opt/drill/jars /opt/drill/jars/3rdparty /opt/drill/jars/3rdparty/HikariCP-2.5.1.jar /opt/drill/jars/3rdparty/aggdesigner-algorithm-6.0.jar /opt/drill/jars/3rdparty/animal-sniffer-annotations-1.14.jar /opt/drill/jars/3rdparty/annotations-2.0.1.jar /opt/drill/jars/3rdparty/antlr-runtime-3.5.2.jar /opt/drill/jars/3rdparty/antlr4-runtime-4.7.1.jar /opt/drill/jars/3rdparty/aopalliance-1.0.jar /opt/drill/jars/3rdparty/apacheds-i18n-2.0.0-M15.jar /opt/drill/jars/3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar /opt/drill/jars/3rdparty/api-asn1-api-1.0.0-M20.jar /opt/drill/jars/3rdparty/api-util-1.0.0-M20.jar /opt/drill/jars/3rdparty/asm-7.0.jar /opt/drill/jars/3rdparty/asm-analysis-7.0.jar /opt/drill/jars/3rdparty/asm-commons-7.0.jar /opt/drill/jars/3rdparty/asm-tree-7.0.jar /opt/drill/jars/3rdparty/asm-util-7.0.jar /opt/drill/jars/3rdparty/async-1.4.1.jar /opt/drill/jars/3rdparty/audience-annotations-0.5.0.jar /opt/drill/jars/3rdparty/avatica-1.12.0.jar /opt/drill/jars/3rdparty/avro-1.8.2.jar /opt/drill/jars/3rdparty/avro-ipc-1.8.2.jar /opt/drill/jars/3rdparty/avro-mapred-1.8.2.jar /opt/drill/jars/3rdparty/aws-java-sdk-1.7.4.jar /opt/drill/jars/3rdparty/bcpkix-jdk15on-1.60.jar /opt/drill/jars/3rdparty/bcprov-jdk15on-1.60.jar /opt/drill/jars/3rdparty/bonecp-0.8.0.RELEASE.jar /opt/drill/jars/3rdparty/byte-buddy-1.9.3.jar /opt/drill/jars/3rdparty/byte-buddy-agent-1.9.3.jar /opt/drill/jars/3rdparty/calcite-core-1.17.0-drill-r2.jar /opt/drill/jars/3rdparty/calcite-linq4j-1.17.0-drill-r2.jar /opt/drill/jars/3rdparty/commons-beanutils-1.9.2.jar /opt/drill/jars/3rdparty/commons-beanutils-core-1.8.0.jar /opt/drill/jars/3rdparty/commons-cli-1.2.jar /opt/drill/jars/3rdparty/commons-codec-1.10.jar /opt/drill/jars/3rdparty/commons-collections-3.2.2.jar /opt/drill/jars/3rdparty/commons-compiler-3.0.11.jar /opt/drill/jars/3rdparty/commons-compress-1.4.1.jar /opt/drill/jars/3rdparty/commons-configuration-1.6.jar /opt/drill/jars/3rdparty/commons-crypto-1.0.0.jar /opt/drill/jars/3rdparty/commons-dbcp-1.4.jar /opt/drill/jars/3rdparty/commons-dbcp2-2.4.0.jar /opt/drill/jars/3rdparty/commons-digester-1.8.jar /opt/drill/jars/3rdparty/commons-httpclient-3.1.jar /opt/drill/jars/3rdparty/commons-io-2.4.jar /opt/drill/jars/3rdparty/commons-lang-2.6.jar /opt/drill/jars/3rdparty/commons-lang3-3.2.jar /opt/drill/jars/3rdparty/commons-math-2.2.jar /opt/drill/jars/3rdparty/commons-math3-3.1.1.jar /opt/drill/jars/3rdparty/commons-net-3.1.jar /opt/drill/jars/3rdparty/commons-pool-1.6.jar /opt/drill/jars/3rdparty/commons-pool2-2.6.0.jar /opt/drill/jars/3rdparty/commons-text-1.4.jar /opt/drill/jars/3rdparty/commons-validator-1.6.jar /opt/drill/jars/3rdparty/config-1.0.0.jar /opt/drill/jars/3rdparty/converter-jackson-2.1.0.jar /opt/drill/jars/3rdparty/curator-client-2.7.1.jar /opt/drill/jars/3rdparty/curator-framework-2.7.1.jar /opt/drill/jars/3rdparty/curator-recipes-2.7.1.jar /opt/drill/jars/3rdparty/curator-x-discovery-2.7.1.jar /opt/drill/jars/3rdparty/datanucleus-api-jdo-4.2.4.jar /opt/drill/jars/3rdparty/datanucleus-core-4.1.17.jar /opt/drill/jars/3rdparty/datanucleus-rdbms-4.1.19.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar /opt/drill/jars/3rdparty/de.huxhorn.lilith.log
