[jira] [Updated] (DRILL-6369) typeof() fails for constants

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-6369: --- Fix Version/s: 1.16.0 > typeof() fails for constants > >

[jira] [Resolved] (DRILL-6260) Query fails with "ERROR: Non-scalar sub-query used in an expression" when it contains a cast expression around a scalar sub-query

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-6260. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in DRILL-5188 > Query fails w

[jira] [Resolved] (DRILL-6066) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-6066. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 Looks like it was fixed a

[jira] [Resolved] (DRILL-4403) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4403. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 Looks like it was fixed a

[jira] [Commented] (DRILL-6013) requesting INFORMATION_SCHEMA with a postgresql connector generates a null pointer exception

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16782380#comment-16782380 ] Volodymyr Vysotskyi commented on DRILL-6013: [~glehmann], could you please co

[jira] [Commented] (DRILL-5793) NPE on close

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16782382#comment-16782382 ] Volodymyr Vysotskyi commented on DRILL-5793: [~khfaraaz], could you please ch

[jira] [Resolved] (DRILL-5773) Project pushdown into a subquery with select *

2019-03-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5773. Resolution: Fixed Fix Version/s: 1.16.0 Looks like it was fixed in the scope

[jira] [Updated] (DRILL-5713) Doing joins on tables that share column names in a JDBC store returns incorrect results

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-5713: --- Description: If there are two tables in Postgres that share column names, incorrect r

[jira] [Resolved] (DRILL-5713) Doing joins on tables that share column names in a JDBC store returns incorrect results

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5713. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in the scope of DRILL-6734 >

[jira] [Resolved] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4374. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 > Drill rewrites Postgres

[jira] [Resolved] (DRILL-4211) Column aliases not pushed down to JDBC stores in some cases when Drill expects aliased columns to be returned.

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4211. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in the scope of DRILL-6734 >

[jira] [Created] (DRILL-7072) Query with semi join fails for JDBC storage plugin

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7072: -- Summary: Query with semi join fails for JDBC storage plugin Key: DRILL-7072 URL: https://issues.apache.org/jira/browse/DRILL-7072 Project: Apache Drill

[jira] [Resolved] (DRILL-4436) Result data gets mixed up when various tables have a column "label"

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4436. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in DRILL-6734 > Result data g

[jira] [Resolved] (DRILL-4939) to_date function returns incorrect result

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4939. Resolution: Not A Problem Fix Version/s: 1.16.0 > to_date function returns i

[jira] [Resolved] (DRILL-4400) Cannot apply 'NOT' to arguments of type 'NOT'.

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4400. Resolution: Fixed Fix Version/s: 1.16.0 Fixed after Calcite upgrade > Canno

[jira] [Resolved] (DRILL-4395) equi-inner join of two tables in Postgres returns null one of the projected columns

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4395. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in DRILL-6734 > equi-inner jo

[jira] [Resolved] (DRILL-416) Make Drill work with SELECT without FROM

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-416. --- Resolution: Fixed Fix Version/s: (was: Future) 1.16.0 Qu

[jira] [Resolved] (DRILL-4677) Cast to TIMESTAMP within value constructor results in IllegalArgumentException

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4677. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 This issue is not reprodu

[jira] [Resolved] (DRILL-4902) nested aggregate query does not complain about missing GROUP BY clause

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4902. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 The query from descriptio

[jira] [Resolved] (DRILL-4407) Group by subquery causes Java NPE

2019-03-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4407. Resolution: Fixed Fix Version/s: 1.16.0 The second problem was fixed in DRIL

[jira] [Updated] (DRILL-5603) Replace String file paths to Hadoop Path

2019-03-04 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-5603: --- Labels: ready-to-commit (was: ) Reviewer: Volodymyr Vysotskyi (was: Aman Sinha

[jira] [Updated] (DRILL-7069) Poor performance of transformBinaryInMetadataCache

2019-03-04 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7069: --- Labels: ready-to-commit (was: ) Reviewer: Volodymyr Vysotskyi > Poor performan

[jira] [Commented] (DRILL-7069) Poor performance of transformBinaryInMetadataCache

2019-03-04 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16783166#comment-16783166 ] Volodymyr Vysotskyi commented on DRILL-7069: [~ben-zvi], could you please cha

[jira] [Updated] (DRILL-6846) Store test results

2019-03-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-6846: --- Labels: ready-to-commit (was: ) > Store test results > -- > >

[jira] [Created] (DRILL-7076) NPE is logged when querying postgres tables

2019-03-05 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7076: -- Summary: NPE is logged when querying postgres tables Key: DRILL-7076 URL: https://issues.apache.org/jira/browse/DRILL-7076 Project: Apache Drill

[jira] [Updated] (DRILL-7076) NPE is logged when querying postgres tables

2019-03-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7076: --- Affects Version/s: (was: 1.15.0) 1.16.0 > NPE is logged wh

[jira] [Updated] (DRILL-7056) Drill fails with NPE when starting in distributed mode and 31010 port is used

2019-03-06 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7056: --- Labels: ready-to-commit (was: ) > Drill fails with NPE when starting in distributed

[jira] [Resolved] (DRILL-4408) re-written query projecting an aggregate on a boolean not supported by Postgres

2019-03-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4408. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in DRILL-5188 > re-written qu

[jira] [Assigned] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi reassigned DRILL-6524: -- Assignee: Volodymyr Vysotskyi > Two CASE statements in projection influence re

[jira] [Updated] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-6524: --- Fix Version/s: 1.16.0 > Two CASE statements in projection influence results of each o

[jira] [Commented] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788807#comment-16788807 ] Volodymyr Vysotskyi commented on DRILL-6524: The problem here is connected wi

[jira] [Assigned] (DRILL-2326) scalar replacement fails in TestConvertFunctions.testBigIntVarCharReturnTripConvertLogical()

2019-03-10 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi reassigned DRILL-2326: -- Assignee: Volodymyr Vysotskyi > scalar replacement fails in > TestConvertFunc

[jira] [Updated] (DRILL-2326) scalar replacement fails in TestConvertFunctions.testBigIntVarCharReturnTripConvertLogical()

2019-03-10 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-2326: --- Fix Version/s: (was: Future) 1.16.0 > scalar replacement fails

[jira] [Created] (DRILL-7088) Remove deprecated decimal data types

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7088: -- Summary: Remove deprecated decimal data types Key: DRILL-7088 URL: https://issues.apache.org/jira/browse/DRILL-7088 Project: Apache Drill Issue T

[jira] [Updated] (DRILL-7073) CREATE SCHEMA command / TupleSchema / ColumnMetadata improvements

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7073: --- Labels: ready-to-commit (was: ) Reviewer: Paul Rogers > CREATE SCHEMA command

[jira] [Created] (DRILL-7089) Implement caching of BaseMetadata classes

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7089: -- Summary: Implement caching of BaseMetadata classes Key: DRILL-7089 URL: https://issues.apache.org/jira/browse/DRILL-7089 Project: Apache Drill Is

[jira] [Resolved] (DRILL-2426) Apache Drill Storage Plugin for MYSQL

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-2426. Resolution: Fixed Fix Version/s: (was: Future) 1.2.0

[jira] [Resolved] (DRILL-4312) JDBC PlugIN - MySQL Causes errors in Drill INFORMATION_SCHEMA

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4312. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 > JDBC PlugIN - MySQL Cau

[jira] [Resolved] (DRILL-6013) requesting INFORMATION_SCHEMA with a postgresql connector generates a null pointer exception

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-6013. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 > requesting INFORMATION_

[jira] [Commented] (DRILL-4682) Allow full schema identifier in SELECT clause

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789567#comment-16789567 ] Volodymyr Vysotskyi commented on DRILL-4682: Another case which should be con

[jira] [Resolved] (DRILL-5295) Unable to query INFORMATION_SCHEMA.`TABLES` if MySql storage plugin enabled

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5295. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 > Unable to query INFORMA

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

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7091: -- Summary: Query with EXISTS and correlated subquery fails with NPE in HashJoinMemoryCalculatorImpl$BuildSidePartitioningImpl Key: DRILL-7091 URL: https://issues.apache.

[jira] [Resolved] (DRILL-5161) Several TestConvertFunctions tests produce scalar replacement errors

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5161. Resolution: Duplicate Fix Version/s: 1.16.0 > Several TestConvertFunctions t

[jira] [Updated] (DRILL-2326) scalar replacement fails in TestConvertFunctions.testBigIntVarCharReturnTripConvertLogical()

2019-03-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-2326: --- Labels: ready-to-commit (was: ) > scalar replacement fails in > TestConvertFunction

[jira] [Resolved] (DRILL-4004) Fix bugs in JDK8 Tests before updating enforcer to JDK8

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4004. Resolution: Fixed Fix Version/s: 1.13.0 Fixed in DRILL-4329 > Fix bugs in J

[jira] [Updated] (DRILL-4093) Use CalciteSchema from Calcite master branch

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-4093: --- Fix Version/s: 1.13.0 > Use CalciteSchema from Calcite master branch > --

[jira] [Updated] (DRILL-4093) Use CalciteSchema from Calcite master branch

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-4093: --- Issue Type: Task (was: Bug) > Use CalciteSchema from Calcite master branch > ---

[jira] [Resolved] (DRILL-4093) Use CalciteSchema from Calcite master branch

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4093. Resolution: Done Done in the scope of DRILL-3993. > Use CalciteSchema from Calcite

[jira] [Comment Edited] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788807#comment-16788807 ] Volodymyr Vysotskyi edited comment on DRILL-6524 at 3/12/19 4:33 PM: --

[jira] [Comment Edited] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16788807#comment-16788807 ] Volodymyr Vysotskyi edited comment on DRILL-6524 at 3/12/19 4:38 PM: --

[jira] [Commented] (DRILL-6524) Two CASE statements in projection influence results of each other

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16790756#comment-16790756 ] Volodymyr Vysotskyi commented on DRILL-6524: In the second commit of the pull

[jira] [Assigned] (DRILL-5683) Incorrect query result when query uses NOT(IS NOT NULL) expression

2019-03-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi reassigned DRILL-5683: -- Assignee: Volodymyr Vysotskyi (was: Vitalii Diravka) > Incorrect query result

[jira] [Resolved] (DRILL-5683) Incorrect query result when query uses NOT(IS NOT NULL) expression

2019-03-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5683. Resolution: Fixed Fix Version/s: 1.16.0 Fixed in DRILL-6524 > Incorrect que

[jira] [Resolved] (DRILL-5581) Query with CASE statement returns wrong results

2019-03-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-5581. Resolution: Fixed Assignee: Volodymyr Vysotskyi (was: Karthikeyan Maniv

[jira] [Resolved] (DRILL-6722) Query from parquet with case-then and arithmetic operation returns a wrong result

2019-03-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-6722. Resolution: Fixed Assignee: Volodymyr Vysotskyi Fix Version/s: 1.16.

[jira] [Updated] (DRILL-7105) Error while building the Drill native client

2019-03-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7105: --- Labels: ready-to-commit (was: ) > Error while building the Drill native client > ---

[jira] [Updated] (DRILL-7103) BSON Recored reader: wrong timestamp values

2019-03-18 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7103: --- Labels: ready-to-commit (was: ) > BSON Recored reader: wrong timestamp values >

[jira] [Updated] (DRILL-7111) Table function fails to query directories

2019-03-18 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7111: --- Labels: ready-to-commit (was: ) > Table function fails to query directories > --

[jira] [Created] (DRILL-7116) Adapt statistics to use Drill Metastore API

2019-03-19 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7116: -- Summary: Adapt statistics to use Drill Metastore API Key: DRILL-7116 URL: https://issues.apache.org/jira/browse/DRILL-7116 Project: Apache Drill

[jira] [Updated] (DRILL-7124) Fix logger for ShowFilesHandler

2019-03-20 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7124: --- Labels: ready-to-commit (was: ) > Fix logger for ShowFilesHandler >

[jira] [Updated] (DRILL-7118) Filter not getting pushed down on MapR-DB tables.

2019-03-22 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7118: --- Labels: ready-to-commit (was: ) > Filter not getting pushed down on MapR-DB tables.

[jira] [Updated] (DRILL-7079) Drill can't query views from the S3 storage when plain authentication is enabled

2019-03-22 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7079: --- Labels: ready-to-commit (was: ) > Drill can't query views from the S3 storage when p

[jira] [Commented] (DRILL-7132) Metadata cache does not have correct min/max values for varchar and interval data types

2019-03-22 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799339#comment-16799339 ] Volodymyr Vysotskyi commented on DRILL-7132: [~rhou], parquet metadata cache

[jira] [Commented] (DRILL-7132) Metadata cache does not have correct min/max values for varchar and interval data types

2019-03-22 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799349#comment-16799349 ] Volodymyr Vysotskyi commented on DRILL-7132: These values may be decoded usin

[jira] [Commented] (DRILL-7132) Metadata cache does not have correct min/max values for varchar and interval data types

2019-03-22 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799365#comment-16799365 ] Volodymyr Vysotskyi commented on DRILL-7132: Here is a discussion from the PR

[jira] [Updated] (DRILL-6989) Upgrade to SqlLine 1.7.0

2019-03-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-6989: --- Labels: doc-impacting ready-to-commit (was: doc-impacting) > Upgrade to SqlLine 1.7.

[jira] [Updated] (DRILL-7138) Implement command to describe schema for table

2019-03-29 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7138: --- Labels: doc-impacting ready-to-commit (was: doc-impacting) > Implement command to de

[jira] [Updated] (DRILL-7142) Add space after > in SqlLine prompt

2019-03-29 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7142: --- Labels: ready-to-commit (was: ) > Add space after > in SqlLine prompt >

[jira] [Comment Edited] (DRILL-7077) Add Function to Facilitate Time Series Analysis

2019-03-31 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806450#comment-16806450 ] Volodymyr Vysotskyi edited comment on DRILL-7077 at 4/1/19 6:39 AM: ---

[jira] [Updated] (DRILL-7140) RM: Drillbits fail with "No enum constant org.apache.drill.exec.resourcemgr.config.selectionpolicy.QueueSelectionPolicy.SelectionPolicy.bestfit"

2019-04-01 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7140: --- Labels: ready-to-commit (was: ) > RM: Drillbits fail with "No enum constant > org.a

[jira] [Commented] (DRILL-7076) NPE is logged when querying postgres tables

2019-04-01 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806867#comment-16806867 ] Volodymyr Vysotskyi commented on DRILL-7076: [~gparai], to reproduce this iss

[jira] [Commented] (DRILL-7076) NPE is logged when querying postgres tables

2019-04-01 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806882#comment-16806882 ] Volodymyr Vysotskyi commented on DRILL-7076: [~gparai], this issue is also re

[jira] [Commented] (DRILL-7072) Query with semi join fails for JDBC storage plugin

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16807500#comment-16807500 ] Volodymyr Vysotskyi commented on DRILL-7072: No, it doesn't. > Query with se

[jira] [Created] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7150: -- Summary: Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST Key: DRILL-7150 URL: https://issues.apache.org/jira/browse/DRILL-7150

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Description: Steps to reproduce: 0. Set PST timezone and date {{date +%Y%m%d -s "2019

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Description: Steps to reproduce: 0. Set PST timezone and date {{date +%Y%m%d -s "2019

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Reviewer: Aman Sinha > Fix timezone conversion for timestamp from maprdb after the tr

[jira] [Assigned] (DRILL-4211) Column aliases not pushed down to JDBC stores in some cases when Drill expects aliased columns to be returned.

2019-04-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi reassigned DRILL-4211: -- Assignee: Volodymyr Vysotskyi (was: Timothy Farkas) > Column aliases not push

[jira] [Updated] (DRILL-7153) Drill Fails to Build using JDK 1.8.0_65

2019-04-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7153: --- Labels: ready-to-commit (was: ) > Drill Fails to Build using JDK 1.8.0_65 >

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Labels: ready-to-commit (was: ) > Fix timezone conversion for timestamp from maprdb

[jira] [Updated] (DRILL-7048) Implement JDBC Statement.setMaxRows() with System Option

2019-04-04 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7048: --- Labels: doc-impacting ready-to-commit (was: doc-impacting) > Implement JDBC Statemen

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Description: Steps to reproduce: 0. Set PST timezone and date {{date +%Y%m%d -s "2019

[jira] [Updated] (DRILL-7150) Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST

2019-04-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7150: --- Description: Steps to reproduce: 0. Set PST timezone and date {{date +%Y%m%d -s "2019

[jira] [Updated] (DRILL-7064) Leverage the summary's totalRowCount and totalNullCount for COUNT() queries (also prevent eager expansion of files)

2019-04-07 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7064: --- Reviewer: Volodymyr Vysotskyi > Leverage the summary's totalRowCount and totalNullCou

[jira] [Updated] (DRILL-7157) Wrap SchemaParsingException into UserException when creating schema

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7157: --- Labels: ready-to-commit (was: ) > Wrap SchemaParsingException into UserException whe

[jira] [Created] (DRILL-7160) exec.query.max_rows QUERY-level options are shown on Profiles tab

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created DRILL-7160: -- Summary: exec.query.max_rows QUERY-level options are shown on Profiles tab Key: DRILL-7160 URL: https://issues.apache.org/jira/browse/DRILL-7160 Project:

[jira] [Updated] (DRILL-7159) After renaming MAP to STRUCT typeString method still outputs MAP name

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7159: --- Labels: ready-to-commit (was: ) > After renaming MAP to STRUCT typeString method sti

[jira] [Updated] (DRILL-7160) exec.query.max_rows QUERY-level options are shown on Profiles tab

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7160: --- Priority: Blocker (was: Major) > exec.query.max_rows QUERY-level options are shown o

[jira] [Updated] (DRILL-7160) exec.query.max_rows QUERY-level options are shown on Profiles tab

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7160: --- Fix Version/s: (was: 1.17.0) 1.16.0 > exec.query.max_rows QUER

[jira] [Commented] (DRILL-7160) exec.query.max_rows QUERY-level options are shown on Profiles tab

2019-04-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16812815#comment-16812815 ] Volodymyr Vysotskyi commented on DRILL-7160: Marking this as a blocker since

[jira] [Commented] (DRILL-6985) Fix sqlline.bat issues on Windows and add drill-embedded.bat

2019-04-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16813186#comment-16813186 ] Volodymyr Vysotskyi commented on DRILL-6985: Hi [~bbevens], Updated pages lo

[jira] [Resolved] (DRILL-4946) org.objectweb.asm.tree.analysis.AnalyzerException printed to console in embedded mode

2019-04-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-4946. Resolution: Cannot Reproduce Fix Version/s: 1.16.0 Resolving this Jira, sinc

[jira] [Updated] (DRILL-7089) Implement caching of BaseMetadata classes

2019-04-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7089: --- Labels: ready-to-commit (was: ) > Implement caching of BaseMetadata classes > --

[jira] [Updated] (DRILL-7064) Leverage the summary's totalRowCount and totalNullCount for COUNT() queries (also prevent eager expansion of files)

2019-04-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7064: --- Labels: ready-to-commit (was: ) > Leverage the summary's totalRowCount and totalNull

[jira] [Resolved] (DRILL-7116) Adapt statistics to use Drill Metastore API

2019-04-10 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-7116. Resolution: Fixed Fix Version/s: (was: 1.17.0) 1.16.0

[jira] [Updated] (DRILL-7160) exec.query.max_rows QUERY-level options are shown on Profiles tab

2019-04-10 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7160: --- Labels: ready-to-commit (was: ) > exec.query.max_rows QUERY-level options are shown

[jira] [Updated] (DRILL-7063) Create separate summary file for schema, totalRowCount, totalNullCount (includes maintenance)

2019-04-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated DRILL-7063: --- Labels: doc-impacting ready-to-commit (was: ready-to-commit) > Create separate summa

[jira] [Commented] (DRILL-7063) Create separate summary file for schema, totalRowCount, totalNullCount (includes maintenance)

2019-04-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16815210#comment-16815210 ] Volodymyr Vysotskyi commented on DRILL-7063: [~vdonapati], could you please a

[jira] [Commented] (DRILL-7063) Create separate summary file for schema, totalRowCount, totalNullCount (includes maintenance)

2019-04-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816551#comment-16816551 ] Volodymyr Vysotskyi commented on DRILL-7063: Great, thanks [~amansinha100] an

[jira] [Resolved] (DRILL-7059) Operator profile does not show JDBC metrics

2019-04-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-7059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved DRILL-7059. Resolution: Duplicate Fix Version/s: 1.14.0 It was fixed in DRILL-6455. > O

<    1   2   3   4   5   6   7   >