Re: [VOTE] Release Apache Drill 1.9.0 RC1

2016-11-12 Thread Khurram Faraaz
Built from source without unit tests.
deployed binaries on a cluster.
executed some basic SQL queries (like aggregation, joins, range search etc)
from sqlline.

looks good to me.

On Sat, Nov 12, 2016 at 7:48 AM, Sudheesh Katkam 
wrote:

> Hi all,
>
> I would like to propose the second release candidate (RC1) of Apache Drill,
> version 1.9.0. Thanks to everyone who contributed to this release!
>
> + Compared to RC0, this release candidate does not contain DRILL-4373, due
> to a regression (DRILL-5034).
> + The release candidate covers a total of 73 resolved JIRAs [1].
> + The tarball artifacts are hosted at [2], and the maven artifacts are
> hosted at [3].
> + This release candidate is based on commit
> db3085498c2dc481f734733535c877dfffb9afea located at [4].
> + The artifacts are signed with the key at [5].
>
> The vote ends at 6:30 PM PT, November 16th, 2016.
>
> Here's my vote: +1
>
> Thank you,
> Sudheesh
>
> [1]
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?
> projectId=12313820&version=12337861
> [2] http://people.apache.org/~sudheesh/drill/releases/1.9.0/rc1/
> [3] https://repository.apache.org/content/repositories/
> orgapachedrill-1038/
> [4] https://github.com/sudheeshkatkam/drill/commits/drill-1.9.0
> [5] https://people.apache.org/keys/committer/sudheesh.asc
>


[jira] [Created] (DRILL-5039) NPE - CTAS PARTITION BY ()

2016-11-12 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5039:
-

 Summary: NPE - CTAS PARTITION BY ()
 Key: DRILL-5039
 URL: https://issues.apache.org/jira/browse/DRILL-5039
 Project: Apache Drill
  Issue Type: Bug
  Components: Execution - Flow
Affects Versions: 1.9.0
Reporter: Khurram Faraaz


We are seeing an NPE, when CTAS is used with PARTITION BY ( 
and all columns are projected in SELECT of CTAS.

Drill 1.9.0 
git commit ID : db30854

{noformat}
0: jdbc:drill:schema=dfs.tmp> CREATE TABLE dfs.tmp.temp_tbl
. . . . . . . . . . . . . . > PARTITION BY (col_chr)
. . . . . . . . . . . . . . > AS
. . . . . . . . . . . . . . > SELECT col_int, col_chr, col_vrchr1, col_vrchr2 , 
 col_dt, col_tim, col_tmstmp , col_flt, col_intrvl_yr , col_intrvl_day , col_bln
. . . . . . . . . . . . . . > FROM typeall_l;
Error: SYSTEM ERROR: NullPointerException

Fragment 0:0

[Error Id: ab6c199e-cb61-42dd-ae22-0090eea22ec5 on centos-01.qa.lab:31010] 
(state=,code=0)
{noformat}

{noformat}
2016-11-12 19:54:14,901 [27d88c99-a64d-0317-ba3b-d78195cf85cc:frag:0:0] ERROR 
o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException

Fragment 0:0

[Error Id: ab6c199e-cb61-42dd-ae22-0090eea22ec5 on centos-01.qa.lab:31010]
org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: 
NullPointerException

Fragment 0:0

[Error Id: ab6c199e-cb61-42dd-ae22-0090eea22ec5 on centos-01.qa.lab:31010]
at 
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543)
 ~[drill-common-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:293)
 [drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:160)
 [drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:262)
 [drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) 
[drill-common-1.9.0.jar:1.9.0]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[na:1.8.0_91]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: java.lang.NullPointerException: null
at 
org.apache.drill.exec.expr.fn.impl.ByteFunctionHelpers.compare(ByteFunctionHelpers.java:100)
 ~[vector-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.test.generated.ProjectorGen3.doEval(ProjectorTemplate.java:88)
 ~[na:na]
at 
org.apache.drill.exec.test.generated.ProjectorGen3.projectRecords(ProjectorTemplate.java:62)
 ~[na:na]
at 
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork(ProjectRecordBatch.java:199)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:93)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.WriterRecordBatch.innerNext(WriterRecordBatch.java:91)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104) 
~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:81)
 ~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94