date:20190510

[jira] [Commented] (DRILL-7237) IllegalStateException in aggregation function 'single_value' when there is a varchar datatype in the subquery results

2019-05-10 Thread ASF GitHub Bot (JIRA)



[ 
https://issues.apache.org/jira/browse/DRILL-7237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16837673#comment-16837673
 ] 

ASF GitHub Bot commented on DRILL-7237:
---

Ben-Zvi commented on pull request #1782: DRILL-7237: Fix single_value aggregate 
function for variable length types
URL: https://github.com/apache/drill/pull/1782
 
 
   
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> IllegalStateException in aggregation function 'single_value' when there is a 
> varchar datatype in the subquery results
> -
>
> Key: DRILL-7237
> URL: https://issues.apache.org/jira/browse/DRILL-7237
> Project: Apache Drill
>  Issue Type: Bug
>Affects Versions: 1.14.0, 1.15.0
>Reporter: Denys Ordynskiy
>Assignee: Volodymyr Vysotskyi
>Priority: Major
>  Labels: ready-to-commit
> Fix For: 1.17.0
>
> Attachments: drillbit.log
>
>
> *Description:*
> The following issue can be reproduced on the fix for the 
> [DRILL-7050|https://issues.apache.org/jira/browse/DRILL-7050].
> _For the query with > 1 row in subquery results where the data type of these 
> results *is not varchar*:_
> {noformat}
> SELECT
>   e.full_name,
>   (
> SELECT
>   ine.employee_id
> FROM
>   cp.`employee.json` ine
> WHERE
>   ine.position_id = e.position_id
>   ) as empl_id
> FROM
>   cp.`employee.json` e
> LIMIT 20
> {noformat}
> _We have the following correct and informative error:_
> {noformat}
> Query Failed: An Error Occurred
> org.apache.drill.common.exceptions.UserRemoteException: FUNCTION ERROR: Input 
> for single_value function has more than one row Fragment 0:0 [Error Id: 
> b770098f-b1c7-4647-9f41-9e986a0e47b7 on maprhost:31010]
> {noformat}
> _But when in the result set of the subquery we have *a varchar data type*:_
> {noformat}
> SELECT
>   e.full_name,
>   (
> SELECT
>   ine.first_name
> FROM
>   cp.`employee.json` ine
> WHERE
>   ine.position_id = e.position_id
>   ) as empl_id
> FROM
>   cp.`employee.json` e
> LIMIT 20
> {noformat}
> *Actual result:*
> _Drill throws the following error:_
> {noformat}
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: 
> IllegalStateException: Workspace variable 'value' in aggregation function 
> 'single_value' is not allowed to have variable length type. Fragment 0:0 
> Please, refer to logs for more information. [Error Id: 
> 32325ba9-d2b3-4216-acf6-8e80dfe4a56a on maprhost:31010]
> {noformat}
> Log file is in the attachment "drillbit.log"
> *Expected result:*
> Drill should return the same informative error to any of a data types in the 
> subquery result set.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (DRILL-7169) Rename drill-root ArtifactID to apache-drill

2019-05-10 Thread Boaz Ben-Zvi (JIRA)



[ 
https://issues.apache.org/jira/browse/DRILL-7169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16837599#comment-16837599
 ] 

Boaz Ben-Zvi commented on DRILL-7169:
-

I removed the "ready to commit" label until we have more agreement on the dev 
list for making this change. 

 

> Rename drill-root ArtifactID to apache-drill
> 
>
> Key: DRILL-7169
> URL: https://issues.apache.org/jira/browse/DRILL-7169
> Project: Apache Drill
>  Issue Type: Improvement
>  Components: Tools, Build  Test
>Affects Versions: 1.15.0
>Reporter: Vitalii Diravka
>Assignee: Vitalii Diravka
>Priority: Minor
> Fix For: Future
>
>
> Rename {{drill-root}} root POM ArtifactID to {{apache-drill, see:}}
> {{[https://github.com/apache/drill/blob/master/pom.xml#L32]}}
> Most of all Apache projects use short project name as artifactId.
> Rename it to {{apache-drill}} allow to use it as variable for drill build 
> process.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (DRILL-7169) Rename drill-root ArtifactID to apache-drill

2019-05-10 Thread Boaz Ben-Zvi (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-7169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Boaz Ben-Zvi updated DRILL-7169:

Labels:   (was: ready-to-commit)

> Rename drill-root ArtifactID to apache-drill
> 
>
> Key: DRILL-7169
> URL: https://issues.apache.org/jira/browse/DRILL-7169
> Project: Apache Drill
>  Issue Type: Improvement
>  Components: Tools, Build  Test
>Affects Versions: 1.15.0
>Reporter: Vitalii Diravka
>Assignee: Vitalii Diravka
>Priority: Minor
> Fix For: Future
>
>
> Rename {{drill-root}} root POM ArtifactID to {{apache-drill, see:}}
> {{[https://github.com/apache/drill/blob/master/pom.xml#L32]}}
> Most of all Apache projects use short project name as artifactId.
> Rename it to {{apache-drill}} allow to use it as variable for drill build 
> process.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Resolved] (DRILL-3995) Scalar replacement bug with Common Subexpression Elimination

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-3995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Volodymyr Vysotskyi resolved DRILL-3995.

   Resolution: Cannot Reproduce
Fix Version/s: 1.17.0

> Scalar replacement bug with Common Subexpression Elimination
> 
>
> Key: DRILL-3995
> URL: https://issues.apache.org/jira/browse/DRILL-3995
> Project: Apache Drill
>  Issue Type: Bug
>Reporter: Steven Phillips
>Priority: Major
> Fix For: 1.17.0
>
>
> The following query:
>  {code}
> select t1.full_name from cp.`employee.json` t1, cp.`department.json` t2 where 
> t1.department_id = t2.department_id and t1.position_id = t2.department_id
> {code}
> fails with the following:
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: 
> RuntimeException: Error at instruction 43: Expected an object reference, but 
> found . setValue(II)V
> 0 R I I . . . .  :  :L0
> 1 R I I . . . .  :  : LINENUMBER 249 L0
> 2 R I I . . . .  :  : ICONST_0
> 3 R I I . . . .  : I  : ISTORE 3
> 4 R I I I . . .  :  : LCONST_0
> 5 R I I I . . .  : J  : LSTORE 4
> 6 R I I I J . .  :  :L1
> 7 R I I I J . .  :  : LINENUMBER 251 L1
> 8 R I I I J . .  :  : ALOAD 0
> 9 R I I I J . .  : R  : GETFIELD 
> org/apache/drill/exec/test/generated/HashTableGen2$BatchHolder.vv20 : 
> Lorg/apache/drill/exec/vector/NullableBigIntVector;
> 00010 R I I I J . .  : R  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector.getAccessor 
> ()Lorg/apache/drill/exec/vector/NullableBigIntVector$Accessor;
> 00011 R I I I J . .  : R  : ILOAD 1
> 00012 R I I I J . .  : R I  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector$Accessor.isSet (I)I
> 00013 R I I I J . .  : I  : ISTORE 3
> 00014 R I I I J . .  :  :L2
> 00015 R I I I J . .  :  : LINENUMBER 252 L2
> 00016 R I I I J . .  :  : ILOAD 3
> 00017 R I I I J . .  : I  : ICONST_1
> 00018 R I I I J . .  : I I  : IF_ICMPNE L3
> 00019 R I I I J . .  :  :L4
> 00020 ? : LINENUMBER 253 L4
> 00021 ? : ALOAD 0
> 00022 ? : GETFIELD 
> org/apache/drill/exec/test/generated/HashTableGen2$BatchHolder.vv20 : 
> Lorg/apache/drill/exec/vector/NullableBigIntVector;
> 00023 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector.getAccessor 
> ()Lorg/apache/drill/exec/vector/NullableBigIntVector$Accessor;
> 00024 ? : ILOAD 1
> 00025 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector$Accessor.get (I)J
> 00026 ? : LSTORE 4
> 00027 R I I I J . .  :  :L3
> 00028 R I I I J . .  :  : LINENUMBER 256 L3
> 00029 R I I I J . .  :  : ILOAD 3
> 00030 R I I I J . .  : I  : ICONST_0
> 00031 R I I I J . .  : I I  : IF_ICMPEQ L5
> 00032 R I I I J . .  :  :L6
> 00033 ? : LINENUMBER 257 L6
> 00034 ? : ALOAD 0
> 00035 ? : GETFIELD 
> org/apache/drill/exec/test/generated/HashTableGen2$BatchHolder.vv24 : 
> Lorg/apache/drill/exec/vector/NullableBigIntVector;
> 00036 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/NullableBigIntVector$Mutator;
> 00037 ? : ILOAD 2
> 00038 ? : ILOAD 3
> 00039 ? : LLOAD 4
> 00040 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector$Mutator.set (IIJ)V
> 00041 R I I I J . .  :  :L5
> 00042 R I I I J . .  :  : LINENUMBER 259 L5
> 00043 R I I I J . .  :  : ALOAD 6
> 00044 ? : GETFIELD 
> org/apache/drill/exec/expr/holders/NullableBigIntHolder.isSet : I
> 00045 ? : ICONST_0
> 00046 ? : IF_ICMPEQ L7
> 00047 ? :L8
> 00048 ? : LINENUMBER 260 L8
> 00049 ? : ALOAD 0
> 00050 ? : GETFIELD 
> org/apache/drill/exec/test/generated/HashTableGen2$BatchHolder.vv27 : 
> Lorg/apache/drill/exec/vector/NullableBigIntVector;
> 00051 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/NullableBigIntVector$Mutator;
> 00052 ? : ILOAD 2
> 00053 ? : ALOAD 6
> 00054 ? : GETFIELD 
> org/apache/drill/exec/expr/holders/NullableBigIntHolder.isSet : I
> 00055 ? : ALOAD 6
> 00056 ? : GETFIELD 
> org/apache/drill/exec/expr/holders/NullableBigIntHolder.value : J
> 00057 ? : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableBigIntVector$Mutator.set (IIJ)V
> 00058 ? :L7
> 00059 ?

[jira] [Resolved] (DRILL-4098) Assembly code in drillbit.log

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-4098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Volodymyr Vysotskyi resolved DRILL-4098.

   Resolution: Fixed
Fix Version/s: 1.16.0

Fixed in DRILL-2326

> Assembly code in drillbit.log
> -
>
> Key: DRILL-4098
> URL: https://issues.apache.org/jira/browse/DRILL-4098
> Project: Apache Drill
>  Issue Type: Bug
>  Components: Execution - Flow
>Affects Versions: 1.3.0
>Reporter: Khurram Faraaz
>Priority: Major
> Fix For: 1.16.0
>
>
> We are seeing the below assembly code and the stack trace in drillbit.log 
> after a Functional test run on a 4 node cluster on CentOS using MapR-Drill 
> 1.3 RPM (latest 11/11).
> From drillbit.log
> {code}
> 2015-11-12 06:36:53,553 [29bbcc7a-36dd-dc7a-d77a-388b228896a4:frag:0:0] INFO  
> o.a.d.e.w.f.FragmentStatusReporter - 
> 29bbcc7a-36dd-dc7a-d77a-388b228896a4:0:0: State to report: RUNNING
> 2015-11-12 06:36:53,588 [29bbcc7a-36dd-dc7a-d77a-388b228896a4:frag:0:0] ERROR 
> o.a.drill.exec.compile.MergeAdapter - Failure while merging classes.
> java.lang.RuntimeException: Error at instruction 26: Expected an object 
> reference, but found . doEval(II)V
> 0 R I I . . .  :  :L0
> 1 R I I . . .  :  : LINENUMBER 104 L0
> 2 R I I . . .  :  : LCONST_0
> 3 R I I . . .  : J  : LSTORE 3
> 4 R I I J . .  :  :L1
> 5 R I I J . .  :  : LINENUMBER 106 L1
> 6 R I I J . .  :  : ALOAD 0
> 7 R I I J . .  : R  : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen4245.vv0 : 
> Lorg/apache/drill/exec/vector/BigIntVector;
> 8 R I I J . .  : R  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector.getAccessor 
> ()Lorg/apache/drill/exec/vector/BigIntVector$Accessor;
> 9 R I I J . .  : R  : ILOAD 1
> 00010 R I I J . .  : R I  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector$Accessor.get (I)J
> 00011 R I I J . .  : J  : LSTORE 3
> 00012 R I I J . .  :  :L2
> 00013 R I I J . .  :  : LINENUMBER 108 L2
> 00014 R I I J . .  :  : ALOAD 0
> 00015 R I I J . .  : R  : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen4245.vv4 : 
> Lorg/apache/drill/exec/vector/BigIntVector;
> 00016 R I I J . .  : R  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/BigIntVector$Mutator;
> 00017 R I I J . .  : R  : ILOAD 2
> 00018 R I I J . .  : R I  : LLOAD 3
> 00019 R I I J . .  : R I J  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector$Mutator.set (IJ)V
> 00020 R I I J . .  :  :L3
> 00021 R I I J . .  :  : LINENUMBER 109 L3
> 00022 R I I J . .  :  : ALOAD 0
> 00023 R I I J . .  : R  : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen4245.vv7 : 
> Lorg/apache/drill/exec/vector/BigIntVector;
> 00024 R I I J . .  : R  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/BigIntVector$Mutator;
> 00025 R I I J . .  : R  : ILOAD 2
> 00026 R I I J . .  : R I  : ALOAD 5
> 00027 ?   : GETFIELD 
> org/apache/drill/exec/expr/holders/BigIntHolder.value : J
> 00028 ?   : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector$Mutator.set (IJ)V
> 00029 ?   :L4
> 00030 ?   : LINENUMBER 110 L4
> 00031 ?   : ALOAD 0
> 00032 ?   : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen4245.vv10 : 
> Lorg/apache/drill/exec/vector/BigIntVector;
> 00033 ?   : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/BigIntVector$Mutator;
> 00034 ?   : ILOAD 2
> 00035 ?   : ALOAD 5
> 00036 ?   : GETFIELD 
> org/apache/drill/exec/expr/holders/BigIntHolder.value : J
> 00037 ?   : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector$Mutator.set (IJ)V
> 00038 ?   :L5
> 00039 ?   : LINENUMBER 111 L5
> 00040 ?   : ALOAD 0
> 00041 ?   : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen4245.vv13 : 
> Lorg/apache/drill/exec/vector/BigIntVector;
> 00042 ?   : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector.getMutator 
> ()Lorg/apache/drill/exec/vector/BigIntVector$Mutator;
> 00043 ?   : ILOAD 2
> 00044 ?   : ALOAD 5
> 00045 ?   : GETFIELD 
> org/apache/drill/exec/expr/holders/BigIntHolder.value : J
> 00046 ?   : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/BigIntVector$Mutator.set (IJ)V
> 00047 ?   :L6
> 00048 ?   : LINENUMBER 112 L6
> 00049 ?   : ALOAD 0
> 00050 ?   : GETFIELD 
>

[jira] [Resolved] (DRILL-4299) Query that involves convert_from succeeds, exception is found in drillbit.log

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-4299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Volodymyr Vysotskyi resolved DRILL-4299.

   Resolution: Fixed
Fix Version/s: 1.16.0

Fixed in DRILL-2326

> Query that involves convert_from succeeds, exception is found in drillbit.log
> -
>
> Key: DRILL-4299
> URL: https://issues.apache.org/jira/browse/DRILL-4299
> Project: Apache Drill
>  Issue Type: Bug
>  Components: Execution - Codegen
>Reporter: Victoria Markman
>Priority: Major
> Fix For: 1.16.0
>
> Attachments: data, drillbit.log
>
>
> Here is example of the exception, please refer to drillbit.log that is 
> attached.
> {code}
> 2016-01-22 00:16:12,065 [295e8b32-e2e1-6966-2b13-389cd724ac73:foreman] INFO  
> o.a.drill.exec.work.foreman.Foreman - Query text for query id 
> 295e8b32-e2e1-6966-2b13-389cd724ac73: select c_row, c_float4, 
> convert_from(convert_to(c_float4, 'FLOAT'), 'FLOAT') from data
> 2016-01-22 00:16:12,166 [295e8b32-e2e1-6966-2b13-389cd724ac73:foreman] INFO  
> o.a.d.exec.store.parquet.Metadata - Took 0 ms to get file statuses
> 2016-01-22 00:16:12,173 [295e8b32-e2e1-6966-2b13-389cd724ac73:foreman] INFO  
> o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 
> 1 using 1 threads. Time: 6ms total, 6.100645ms avg, 6ms max.
> 2016-01-22 00:16:12,173 [295e8b32-e2e1-6966-2b13-389cd724ac73:foreman] INFO  
> o.a.d.exec.store.parquet.Metadata - Fetch parquet metadata: Executed 1 out of 
> 1 using 1 threads. Earliest start: 1.338000 μs, Latest start: 1.338000 μs, 
> Average start: 1.338000 μs .
> 2016-01-22 00:16:12,173 [295e8b32-e2e1-6966-2b13-389cd724ac73:foreman] INFO  
> o.a.d.exec.store.parquet.Metadata - Took 6 ms to read file metadata
> 2016-01-22 00:16:12,229 [295e8b32-e2e1-6966-2b13-389cd724ac73:frag:0:0] INFO  
> o.a.d.e.w.fragment.FragmentExecutor - 
> 295e8b32-e2e1-6966-2b13-389cd724ac73:0:0: State change requested 
> AWAITING_ALLOCATION --> RUNNING
> 2016-01-22 00:16:12,229 [295e8b32-e2e1-6966-2b13-389cd724ac73:frag:0:0] INFO  
> o.a.d.e.w.f.FragmentStatusReporter - 
> 295e8b32-e2e1-6966-2b13-389cd724ac73:0:0: State to report: RUNNING
> 2016-01-22 00:16:12,300 [295e8b32-e2e1-6966-2b13-389cd724ac73:frag:0:0] ERROR 
> o.a.drill.exec.compile.MergeAdapter - Failure while merging classes.
> java.lang.RuntimeException: Error at instruction 147: Expected an object 
> reference, but found . doEval(II)V
> 0 R I I . . . . . . . . . . . . . . . . . . . . . .  :  :L0
> 1 R I I . . . . . . . . . . . . . . . . . . . . . .  :  : LINENUMBER 
> 60 L0
> 2 R I I . . . . . . . . . . . . . . . . . . . . . .  :  : ICONST_0
> 3 R I I . . . . . . . . . . . . . . . . . . . . . .  : I  : ISTORE 3
> 4 R I I I . . . . . . . . . . . . . . . . . . . . .  :  : FCONST_0
> 5 R I I I . . . . . . . . . . . . . . . . . . . . .  : F  : FSTORE 4
> 6 R I I I F . . . . . . . . . . . . . . . . . . . .  :  :L1
> 7 R I I I F . . . . . . . . . . . . . . . . . . . .  :  : LINENUMBER 
> 62 L1
> 8 R I I I F . . . . . . . . . . . . . . . . . . . .  :  : ALOAD 0
> 9 R I I I F . . . . . . . . . . . . . . . . . . . .  : R  : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen11.vv1 : 
> Lorg/apache/drill/exec/vector/NullableFloat4Vector;
> 00010 R I I I F . . . . . . . . . . . . . . . . . . . .  : R  : 
> INVOKEVIRTUAL org/apache/drill/exec/vector/NullableFloat4Vector.getAccessor 
> ()Lorg/apache/drill/exec/vector/NullableFloat4Vector$Accessor;
> 00011 R I I I F . . . . . . . . . . . . . . . . . . . .  : R  : ILOAD 1
> 00012 R I I I F . . . . . . . . . . . . . . . . . . . .  : R I  : 
> INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableFloat4Vector$Accessor.isSet (I)I
> 00013 R I I I F . . . . . . . . . . . . . . . . . . . .  : I  : ISTORE 3
> 00014 R I I I F . . . . . . . . . . . . . . . . . . . .  :  :L2
> 00015 R I I I F . . . . . . . . . . . . . . . . . . . .  :  : LINENUMBER 
> 63 L2
> 00016 R I I I F . . . . . . . . . . . . . . . . . . . .  :  : ILOAD 3
> 00017 R I I I F . . . . . . . . . . . . . . . . . . . .  : I  : ICONST_1
> 00018 R I I I F . . . . . . . . . . . . . . . . . . . .  : I I  : 
> IF_ICMPNE L3
> 00019 R I I I F . . . . . . . . . . . . . . . . . . . .  :  :L4
> 00020 ?  : LINENUMBER 64 L4
> 00021 ?  : ALOAD 0
> 00022 ?  : GETFIELD 
> org/apache/drill/exec/test/generated/ProjectorGen11.vv1 : 
> Lorg/apache/drill/exec/vector/NullableFloat4Vector;
> 00023 ?  : INVOKEVIRTUAL 
> org/apache/drill/exec/vector/NullableFloat4Vector.getAccessor 
>

[jira] [Commented] (DRILL-7091) Query with EXISTS and correlated subquery fails with NPE in HashJoinMemoryCalculatorImpl$BuildSidePartitioningImpl

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)



[ 
https://issues.apache.org/jira/browse/DRILL-7091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16837466#comment-16837466
 ] 

Volodymyr Vysotskyi commented on DRILL-7091:


{{HashJoinMemoryCalculatorImpl.BuildSidePartitioningImpl}} should handle such 
cases with star columns in Project, since data sources which do not support 
pushing the project into scan may be queried, and we will receive the same NPE.

> Query with EXISTS and correlated subquery fails with NPE in 
> HashJoinMemoryCalculatorImpl$BuildSidePartitioningImpl
> --
>
> Key: DRILL-7091
> URL: https://issues.apache.org/jira/browse/DRILL-7091
> Project: Apache Drill
>  Issue Type: Bug
>Affects Versions: 1.15.0
>Reporter: Volodymyr Vysotskyi
>Assignee: Boaz Ben-Zvi
>Priority: Major
>
> Steps to reproduce:
> 1. Create view:
> {code:sql}
> create view dfs.tmp.nation_view as select * from cp.`tpch/nation.parquet`;
> {code}
> Run the following query:
> {code:sql}
> SELECT n_nationkey, n_name
> FROM  dfs.tmp.nation_view a
> WHERE EXISTS (SELECT 1
> FROM cp.`tpch/region.parquet` b
> WHERE b.r_regionkey =  a.n_regionkey)
> {code}
> This query fails with NPE:
> {noformat}
> [Error Id: 9a592635-f792-4403-965c-bd2eece7e8fc on cv1:31010]
>   at 
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
>  ~[drill-common-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:364)
>  [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:219)
>  [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:330)
>  [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
>  [drill-common-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  [na:1.8.0_161]
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  [na:1.8.0_161]
>   at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
> Caused by: java.lang.NullPointerException: null
>   at 
> org.apache.drill.exec.physical.impl.join.HashJoinMemoryCalculatorImpl$BuildSidePartitioningImpl.initialize(HashJoinMemoryCalculatorImpl.java:267)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.physical.impl.join.HashJoinBatch.executeBuildPhase(HashJoinBatch.java:959)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.physical.impl.join.HashJoinBatch.innerNext(HashJoinBatch.java:525)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:141)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.test.generated.HashAggregatorGen2.doWork(HashAggTemplate.java:642)
>  ~[na:na]
>   at 
> org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.innerNext(HashAggBatch.java:295)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:186)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:126)
>  ~[drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
>   at 
> org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:116)
>

[jira] [Updated] (DRILL-6979) Add autofocus attribute to username on login page, and to query textbox on Query tab.

2019-05-10 Thread Arina Ielchiieva (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-6979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arina Ielchiieva updated DRILL-6979:

Fix Version/s: 1.16.0

> Add autofocus attribute to username on login page, and to query textbox on 
> Query tab.
> -
>
> Key: DRILL-6979
> URL: https://issues.apache.org/jira/browse/DRILL-6979
> Project: Apache Drill
>  Issue Type: Improvement
>  Components: Web Server
>Affects Versions: 1.16.0
>Reporter: Khurram Faraaz
>Assignee: Khurram Faraaz
>Priority: Minor
>  Labels: ready-to-commit, user-experience
> Fix For: 1.16.0
>
>
> Add autofocus attribute to username on login page, and to query textbox on 
> Query tab.
> The two text boxes that need the change are in these files
> ./exec/java-exec/src/main/resources/rest/query/query.ftl
> ./exec/java-exec/src/main/resources/rest/login.ftl



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (DRILL-7248) Apache Drill API returns the numeric column value as string

2019-05-10 Thread Gayathri (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-7248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gayathri updated DRILL-7248:

Summary: Apache Drill API returns the numeric column value as string  (was: 
Apache Drill API returns the column value as string)

> Apache Drill API returns the numeric column value as string
> ---
>
> Key: DRILL-7248
> URL: https://issues.apache.org/jira/browse/DRILL-7248
> Project: Apache Drill
>  Issue Type: Bug
>Affects Versions: 1.14.0
>Reporter: Gayathri
>Priority: Blocker
>
> *test.json:*
> [\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]
> +Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from 
> dfs.`\files\test.json`"};
> *Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
>  "columns": [
>  "a",
>  "b",
>  "c"
>  ],
>  "rows": [
> { "b": "1", "c": " 2.0", "a": "uxv"}
> , \{ "b": "2", "c": "3.15", "a": "uxv"}
> ]
>  }
> Here in the response, why the column values are coming as string even though 
> it a numeric.
> Can anyone please help me in this. Is there any configuration where I can 
> modify to get the response column values in proper numeric format rather than 
> a string.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (DRILL-7248) Apache Drill API returns the column value as string

2019-05-10 Thread Gayathri (JIRA)

Gayathri created DRILL-7248:
---

 Summary: Apache Drill API returns the column value as string
 Key: DRILL-7248
 URL: https://issues.apache.org/jira/browse/DRILL-7248
 Project: Apache Drill
  Issue Type: Bug
Affects Versions: 1.14.0
Reporter: Gayathri


*test.json:*

[\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]**

+Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from 
dfs.`\files\test.json`"};

*Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
"columns": [
"a",
"b",
"c"
],
"rows": [

{ "b": "1", "c": " 2.0", "a": "uxv"}

, \{ "b": "2", "c": "3.15", "a": "uxv"}

]
}

Here in the response, why the column values are coming as string even though it 
a numeric.

Can anyone please help me in this. Is there any configuration where I can 
modify to get the response column values in proper numeric format rather than a 
string.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (DRILL-7248) Apache Drill API returns the column value as string

2019-05-10 Thread Gayathri (JIRA)



 [ 
https://issues.apache.org/jira/browse/DRILL-7248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gayathri updated DRILL-7248:

Description: 
*test.json:*

[\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]

+Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from 
dfs.`\files\test.json`"};

*Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
 "columns": [
 "a",
 "b",
 "c"
 ],
 "rows": [

{ "b": "1", "c": " 2.0", "a": "uxv"}

, \{ "b": "2", "c": "3.15", "a": "uxv"}

]
 }

Here in the response, why the column values are coming as string even though it 
a numeric.

Can anyone please help me in this. Is there any configuration where I can 
modify to get the response column values in proper numeric format rather than a 
string.

  was:
*test.json:*

[\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]**

+Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from 
dfs.`\files\test.json`"};

*Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
"columns": [
"a",
"b",
"c"
],
"rows": [

{ "b": "1", "c": " 2.0", "a": "uxv"}

, \{ "b": "2", "c": "3.15", "a": "uxv"}

]
}

Here in the response, why the column values are coming as string even though it 
a numeric.

Can anyone please help me in this. Is there any configuration where I can 
modify to get the response column values in proper numeric format rather than a 
string.


> Apache Drill API returns the column value as string
> ---
>
> Key: DRILL-7248
> URL: https://issues.apache.org/jira/browse/DRILL-7248
> Project: Apache Drill
>  Issue Type: Bug
>Affects Versions: 1.14.0
>Reporter: Gayathri
>Priority: Blocker
>
> *test.json:*
> [\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]
> +Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from 
> dfs.`\files\test.json`"};
> *Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
>  "columns": [
>  "a",
>  "b",
>  "c"
>  ],
>  "rows": [
> { "b": "1", "c": " 2.0", "a": "uxv"}
> , \{ "b": "2", "c": "3.15", "a": "uxv"}
> ]
>  }
> Here in the response, why the column values are coming as string even though 
> it a numeric.
> Can anyone please help me in this. Is there any configuration where I can 
> modify to get the response column values in proper numeric format rather than 
> a string.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (DRILL-7237) IllegalStateException in aggregation function 'single_value' when there is a varchar datatype in the subquery results

[jira] [Commented] (DRILL-7169) Rename drill-root ArtifactID to apache-drill

[jira] [Updated] (DRILL-7169) Rename drill-root ArtifactID to apache-drill

[jira] [Resolved] (DRILL-3995) Scalar replacement bug with Common Subexpression Elimination

[jira] [Resolved] (DRILL-4098) Assembly code in drillbit.log

[jira] [Resolved] (DRILL-4299) Query that involves convert_from succeeds, exception is found in drillbit.log

[jira] [Commented] (DRILL-7091) Query with EXISTS and correlated subquery fails with NPE in HashJoinMemoryCalculatorImpl$BuildSidePartitioningImpl

[jira] [Updated] (DRILL-6979) Add autofocus attribute to username on login page, and to query textbox on Query tab.

[jira] [Updated] (DRILL-7248) Apache Drill API returns the numeric column value as string

[jira] [Created] (DRILL-7248) Apache Drill API returns the column value as string

[jira] [Updated] (DRILL-7248) Apache Drill API returns the column value as string

11 matches

Site Navigation

Mail list logo

Footer information