[jira] [Commented] (DRILL-6385) Support JPPD (Join Predicate Push Down)

2018-07-05 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16534163#comment-16534163 ] Aman Sinha commented on DRILL-6385: --- Couple of design items to discuss, hence I am addi

[jira] [Created] (DRILL-6588) System table columns incorrectly marked as non-nullable

2018-07-09 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-6588: - Summary: System table columns incorrectly marked as non-nullable Key: DRILL-6588 URL: https://issues.apache.org/jira/browse/DRILL-6588 Project: Apache Drill Issue

[jira] [Commented] (DRILL-6453) TPC-DS query 72 has regressed

2018-07-12 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16542476#comment-16542476 ] Aman Sinha commented on DRILL-6453: --- [~ben-zvi], [~dgu-atmapr]  looking at the query pr

[jira] [Commented] (DRILL-6606) Hash Join returns incorrect data types when joining subqueries with limit 0

2018-07-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16543323#comment-16543323 ] Aman Sinha commented on DRILL-6606: --- I don't think LIMIT 0 in the subqueries  or Views

[jira] [Commented] (DRILL-6453) TPC-DS query 72 has regressed

2018-07-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16543351#comment-16543351 ] Aman Sinha commented on DRILL-6453: --- [~khfaraaz]  can you also try running a simplified

[jira] [Commented] (DRILL-6606) Hash Join returns incorrect data types when joining subqueries with limit 0

2018-07-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16543541#comment-16543541 ] Aman Sinha commented on DRILL-6606: --- Agree that subquery with filter producing 0 rows i

[jira] [Commented] (DRILL-6385) Support JPPD (Join Predicate Push Down)

2018-07-18 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547976#comment-16547976 ] Aman Sinha commented on DRILL-6385: --- The design discussions are getting lost in among a

[jira] [Created] (DRILL-6651) Compilation error in Eclipse IDE due to missing package name

2018-07-31 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-6651: - Summary: Compilation error in Eclipse IDE due to missing package name Key: DRILL-6651 URL: https://issues.apache.org/jira/browse/DRILL-6651 Project: Apache Drill

[jira] [Updated] (DRILL-6650) Remove Stray Semicolon in Printing Results Listener

2018-07-31 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-6650: -- Labels: ready-to-commit (was: ) > Remove Stray Semicolon in Printing Results Listener > --

[jira] [Updated] (DRILL-6651) Compilation error in IDE due to missing package name

2018-07-31 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-6651: -- Labels: ready-to-commit (was: ) > Compilation error in IDE due to missing package name > -

[jira] [Commented] (DRILL-6381) Add capability to do index based planning and execution

2018-09-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16613710#comment-16613710 ] Aman Sinha commented on DRILL-6381: --- The index planning and execution feature has been

[jira] [Comment Edited] (DRILL-6381) Add capability to do index based planning and execution

2018-09-21 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16613710#comment-16613710 ] Aman Sinha edited comment on DRILL-6381 at 9/21/18 3:28 PM: T

[jira] [Updated] (DRILL-5547) Drill config options and session options do not work as intended

2017-09-03 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5547: -- Fix Version/s: (was: Future) 1.12.0 > Drill config options and session options do

[jira] [Commented] (DRILL-5766) Stored XSS in APACHE DRILL

2017-09-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16152793#comment-16152793 ] Aman Sinha commented on DRILL-5766: --- Thanks [~sanjogpanda] for reporting the issue. I a

[jira] [Updated] (DRILL-5758) Rollup of external sort fixes to issues found by QA

2017-09-26 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5758: -- Labels: ready-to-commit (was: ) > Rollup of external sort fixes to issues found by QA > ---

[jira] [Updated] (DRILL-5816) Hash function produces skewed results on String values with same leading prefix

2017-09-26 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5816: -- Labels: ready-to-commit (was: ) > Hash function produces skewed results on String values with same lead

[jira] [Commented] (DRILL-5828) RecordBatchLoader permutes column order

2017-09-29 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16186815#comment-16186815 ] Aman Sinha commented on DRILL-5828: --- The second case with different order of the columns

[jira] [Updated] (DRILL-5864) Selecting a non-existing field from a MapR-DB JSON table fails with NPE

2017-11-05 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5864: -- Fix Version/s: 1.12.0 > Selecting a non-existing field from a MapR-DB JSON table fails with NPE > --

[jira] [Commented] (DRILL-5936) Refactor MergingRecordBatch based on code review

2017-11-09 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16246872#comment-16246872 ] Aman Sinha commented on DRILL-5936: --- [~vrozov] the title says 'based on code review'..wh

[jira] [Updated] (DRILL-4831) Running refresh table metadata concurrently randomly fails with JsonParseException

2016-11-18 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4831: -- Assignee: Padma Penumarthy (was: Aman Sinha) > Running refresh table metadata concurrently randomly fai

[jira] [Commented] (DRILL-4455) Depend on Apache Arrow for Vector and Memory

2016-11-21 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685384#comment-15685384 ] Aman Sinha commented on DRILL-4455: --- Moving the memory format out of Drill to a more spe

[jira] [Assigned] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2016-11-28 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4347: - Assignee: Aman Sinha (was: Jinfeng Ni) > Planning time for query64 from TPCDS test suite has inc

[jira] [Updated] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2016-11-28 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4347: -- Attachment: drill4347_jstack.txt > Planning time for query64 from TPCDS test suite has increased 10 time

[jira] [Commented] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2016-11-28 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15703505#comment-15703505 ] Aman Sinha commented on DRILL-4347: --- Attached the full jstack output for this issue base

[jira] [Commented] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2016-11-29 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15705810#comment-15705810 ] Aman Sinha commented on DRILL-4347: --- The jstack is long because of the complex query. I

[jira] [Comment Edited] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2016-11-29 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15705810#comment-15705810 ] Aman Sinha edited comment on DRILL-4347 at 11/29/16 4:48 PM: -

[jira] [Commented] (DRILL-5052) Option to debug generated Java code using an IDE

2016-12-02 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15716707#comment-15716707 ] Aman Sinha commented on DRILL-5052: --- There's no pull request associated with this JIRA ?

[jira] [Updated] (DRILL-5159) ProjectMergeRule in Drill should operate on RelNodes with same convention trait.

2017-01-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5159: -- Assignee: Jinfeng Ni (was: Aman Sinha) > ProjectMergeRule in Drill should operate on RelNodes with same

[jira] [Updated] (DRILL-5127) Revert the fix for DRILL-4831

2017-01-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5127: -- Labels: ready-to-commit (was: ) > Revert the fix for DRILL-4831 > - > >

[jira] [Commented] (DRILL-5252) A condition returns always true

2017-02-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15861917#comment-15861917 ] Aman Sinha commented on DRILL-5252: --- Yes, that's a bug. Thanks for noticing it. Perhap

[jira] [Commented] (DRILL-5248) You tried to write a VarChar type when you are

2017-02-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15861921#comment-15861921 ] Aman Sinha commented on DRILL-5248: --- Not sure if this will help but can you try the foll

[jira] [Commented] (DRILL-5357) Partition pruning information not available in query plan for COUNT aggregate query

2017-03-15 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15926880#comment-15926880 ] Aman Sinha commented on DRILL-5357: --- This should not be marked 'critical' if the issue i

[jira] [Updated] (DRILL-5226) External Sort encountered an error while spilling to disk

2017-03-20 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5226: -- Fix Version/s: 1.11.0 > External Sort encountered an error while spilling to disk >

[jira] [Updated] (DRILL-5311) C++ connector connect doesn't check handshake result for timeout

2017-03-20 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5311: -- Fix Version/s: 1.11.0 > C++ connector connect doesn't check handshake result for timeout > -

[jira] [Updated] (DRILL-5316) C++ Client Crashes When drillbitsVector.count is 0 after zoo_get_children completed with ZOK

2017-03-20 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5316: -- Fix Version/s: 1.11.0 > C++ Client Crashes When drillbitsVector.count is 0 after zoo_get_children > com

[jira] [Updated] (DRILL-5349) TestParquetWriter unit tests fail with synchronous parquet reader

2017-03-20 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5349: -- Fix Version/s: 1.11.0 > TestParquetWriter unit tests fail with synchronous parquet reader >

[jira] [Commented] (DRILL-5375) Nested loop join: return correct result for left join

2017-03-22 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15936808#comment-15936808 ] Aman Sinha commented on DRILL-5375: --- [~arina] thanks for describing the approach. The o

[jira] [Updated] (DRILL-4335) Apache Drill should support network encryption

2017-05-20 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4335: -- Fix Version/s: 1.11.0 > Apache Drill should support network encryption > ---

[jira] [Commented] (DRILL-5556) Drill allows "SELECT *, *" query

2017-05-29 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16028682#comment-16028682 ] Aman Sinha commented on DRILL-5556: --- I am not sure if it is an invalid SQL. Postgres ce

[jira] [Comment Edited] (DRILL-5457) Support Spill to Disk for the Hash Aggregate Operator

2017-06-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16062059#comment-16062059 ] Aman Sinha edited comment on DRILL-5457 at 6/24/17 4:51 PM: [~

[jira] [Commented] (DRILL-5655) Drill returns a VARCHAR when DATE projected by query sent to SQL Server

2017-07-01 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16071310#comment-16071310 ] Aman Sinha commented on DRILL-5655: --- [~the6campbells] thanks for testing against various

[jira] [Commented] (DRILL-5468) THCH Q18 regressed ~3x due to execution plan changes

2017-07-12 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084496#comment-16084496 ] Aman Sinha commented on DRILL-5468: --- Also, based on my recollection, the HAVING predicat

[jira] [Updated] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

2017-07-12 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-5468: -- Summary: TPCH Q18 regressed ~3x due to execution plan changes (was: THCH Q18 regressed ~3x due to execu

[jira] [Commented] (DRILL-5468) THCH Q18 regressed ~3x due to execution plan changes

2017-07-12 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084488#comment-16084488 ] Aman Sinha commented on DRILL-5468: --- Agree that the new logical plan with the redundant

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

2017-07-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16086552#comment-16086552 ] Aman Sinha commented on DRILL-5468: --- [~jni] Option 1 would be my preference for 1.11 ..

[jira] [Commented] (DRILL-3806) add metadata for untyped null and simple type promotion

2016-03-02 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15176852#comment-15176852 ] Aman Sinha commented on DRILL-3806: --- [~julienledem] or [~jnadeau], for handling the unty

[jira] [Updated] (DRILL-4472) Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal

2016-03-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4472: -- Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) > Pushing Filter past Union All fails: DRILL-3257 regress

[jira] [Commented] (DRILL-4472) Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal

2016-03-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15180097#comment-15180097 ] Aman Sinha commented on DRILL-4472: --- Assigning to [~seanhychu] who wrote the unit test..

[jira] [Updated] (DRILL-4474) Inconsistent behavior while using COUNT in select (Apache drill 1.2.0)

2016-03-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4474: -- Assignee: Jacques Nadeau (was: Aman Sinha) > Inconsistent behavior while using COUNT in select (Apache

[jira] [Created] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-04 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4479: - Summary: JsonReader should pick a less restrictive type when creating the default column Key: DRILL-4479 URL: https://issues.apache.org/jira/browse/DRILL-4479 Project: Apac

[jira] [Updated] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-04 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4479: -- Attachment: mostlynulls.json Test file with first 4096 rows containing c1:null followed by rows containi

[jira] [Commented] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-09 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15188349#comment-15188349 ] Aman Sinha commented on DRILL-4479: --- My patch above will handle the case where we are do

[jira] [Updated] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4479: -- Fix Version/s: 1.7.0 > JsonReader should pick a less restrictive type when creating the default > colum

[jira] [Assigned] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4479: - Assignee: Aman Sinha > JsonReader should pick a less restrictive type when creating the default

[jira] [Commented] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15190386#comment-15190386 ] Aman Sinha commented on DRILL-4479: --- I have updated the PR: https://github.com/apache/d

[jira] [Updated] (DRILL-4479) JsonReader should pick a less restrictive type when creating the default column

2016-03-10 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4479: -- Assignee: Hanifi Gunes (was: Aman Sinha) > JsonReader should pick a less restrictive type when creating

[jira] [Created] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4503: - Summary: Schema change exception even with all_text_mode enabled Key: DRILL-4503 URL: https://issues.apache.org/jira/browse/DRILL-4503 Project: Apache Drill Issue

[jira] [Assigned] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4503: - Assignee: Aman Sinha > Schema change exception even with all_text_mode enabled >

[jira] [Updated] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4503: -- Labels: 1.7.0 (was: ) > Schema change exception even with all_text_mode enabled > -

[jira] [Comment Edited] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192492#comment-15192492 ] Aman Sinha edited comment on DRILL-4503 at 3/13/16 7:29 PM: At

[jira] [Updated] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4503: -- Attachment: mostlynulls_1.json Attached file with 3 columns {a, b, c} where 'a' has non-null values, b a

[jira] [Commented] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192493#comment-15192493 ] Aman Sinha commented on DRILL-4503: --- Note that enabling union_type does not help in this

[jira] [Commented] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192499#comment-15192499 ] Aman Sinha commented on DRILL-4503: --- I am fixing this in the JsonReader by treating null

[jira] [Updated] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4503: -- Fix Version/s: 1.7.0 > Schema change exception even with all_text_mode enabled > ---

[jira] [Updated] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4503: -- Labels: (was: 1.7.0) > Schema change exception even with all_text_mode enabled > -

[jira] [Commented] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192572#comment-15192572 ] Aman Sinha commented on DRILL-4503: --- [~hgunes] could you review the PR (since you are al

[jira] [Updated] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-13 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4503: -- Assignee: Hanifi Gunes (was: Aman Sinha) > Schema change exception even with all_text_mode enabled > --

[jira] [Commented] (DRILL-4376) Wrong results when doing a count(*) on part of directories with metadata cache

2016-03-14 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15193462#comment-15193462 ] Aman Sinha commented on DRILL-4376: --- Already reviewed along with DRILL-4484. > Wrong re

[jira] [Updated] (DRILL-4376) Wrong results when doing a count(*) on part of directories with metadata cache

2016-03-14 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4376: -- Assignee: Deneche A. Hakim (was: Aman Sinha) > Wrong results when doing a count(*) on part of directori

[jira] [Assigned] (DRILL-4503) Schema change exception even with all_text_mode enabled

2016-03-14 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4503: - Assignee: Aman Sinha (was: Hanifi Gunes) > Schema change exception even with all_text_mode enabl

[jira] [Commented] (DRILL-4510) IllegalStateException: Failure while reading vector. Expected vector class of org.apache.drill.exec.vector.NullableIntVector but was holding vector class org.apache.dr

2016-03-14 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15193912#comment-15193912 ] Aman Sinha commented on DRILL-4510: --- This query has a union-all...[~seanhychu] can you t

[jira] [Updated] (DRILL-4510) IllegalStateException: Failure while reading vector. Expected vector class of org.apache.drill.exec.vector.NullableIntVector but was holding vector class org.apache.dril

2016-03-14 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4510: -- Assignee: Sean Hsuan-Yi Chu > IllegalStateException: Failure while reading vector. Expected vector clas

[jira] [Created] (DRILL-4512) Revisit the changes for DRILL-3404 (using SUM0 for window function)

2016-03-15 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4512: - Summary: Revisit the changes for DRILL-3404 (using SUM0 for window function) Key: DRILL-4512 URL: https://issues.apache.org/jira/browse/DRILL-4512 Project: Apache Drill

[jira] [Created] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-03-22 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4530: - Summary: Improve metadata cache performance for queries with single partition Key: DRILL-4530 URL: https://issues.apache.org/jira/browse/DRILL-4530 Project: Apache Drill

[jira] [Commented] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-03-22 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15207648#comment-15207648 ] Aman Sinha commented on DRILL-4530: --- On a closer look, we can optimize this type of quer

[jira] [Updated] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-03-22 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4530: -- Description: Consider two types of queries which are run with Parquet metadata caching: {noformat} quer

[jira] [Updated] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-03-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4530: -- Fix Version/s: 1.7.0 > Improve metadata cache performance for queries with single partition > -

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-03-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15211041#comment-15211041 ] Aman Sinha commented on DRILL-4539: --- Yes, we should do this optimization. We should lev

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-03-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15211045#comment-15211045 ] Aman Sinha commented on DRILL-4539: --- See here for the Drill support: https://github.c

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-03-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15211156#comment-15211156 ] Aman Sinha commented on DRILL-4539: --- The execution side is already available in Drill ..

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-03-25 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15212566#comment-15212566 ] Aman Sinha commented on DRILL-4539: --- That's odd..we should not need to do NestedLoop joi

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-03-25 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15212645#comment-15212645 ] Aman Sinha commented on DRILL-4539: --- Actually, it looks like the 'condition' is TRUE whe

[jira] [Commented] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-03-31 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15220436#comment-15220436 ] Aman Sinha commented on DRILL-4530: --- In order to address this in a reasonably efficient

[jira] [Commented] (DRILL-4539) Add support for Null Equality Joins

2016-04-01 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15222726#comment-15222726 ] Aman Sinha commented on DRILL-4539: --- Interesting that Calcite's default behavior is to d

[jira] [Commented] (DRILL-4530) Improve metadata cache performance for queries with single partition

2016-04-06 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15228674#comment-15228674 ] Aman Sinha commented on DRILL-4530: --- Yes, indeed the storage format of the metadata cach

[jira] [Updated] (DRILL-4590) TPC-H q17 return wrong results when applied to views

2016-04-07 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4590: -- Summary: TPC-H q17 return wrong results when applied to views (was: Queries return wrong results when a

[jira] [Updated] (DRILL-4590) TPC-H q17 returns wrong results when applied to views

2016-04-07 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4590: -- Summary: TPC-H q17 returns wrong results when applied to views (was: TPC-H q17 return wrong results whe

[jira] [Commented] (DRILL-4590) TPC-H q17 returns wrong results when applied to views

2016-04-07 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15230493#comment-15230493 ] Aman Sinha commented on DRILL-4590: --- Based on an initial look, this seems to be an issue

[jira] [Commented] (DRILL-4590) TPC-H q17 returns wrong results when applied to views

2016-04-07 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15230512#comment-15230512 ] Aman Sinha commented on DRILL-4590: --- [~dechanggu] could you pls check if this wrong resu

[jira] [Created] (DRILL-4667) Improve memory footprint of broadcast joins

2016-05-11 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4667: - Summary: Improve memory footprint of broadcast joins Key: DRILL-4667 URL: https://issues.apache.org/jira/browse/DRILL-4667 Project: Apache Drill Issue Type: Improv

[jira] [Created] (DRILL-4679) CONVERT_FROM() json format fails if 0 rows are received from upstream operator

2016-05-16 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4679: - Summary: CONVERT_FROM() json format fails if 0 rows are received from upstream operator Key: DRILL-4679 URL: https://issues.apache.org/jira/browse/DRILL-4679 Project: Apac

[jira] [Assigned] (DRILL-4679) CONVERT_FROM() json format fails if 0 rows are received from upstream operator

2016-05-18 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4679: - Assignee: Aman Sinha > CONVERT_FROM() json format fails if 0 rows are received from upstream >

[jira] [Commented] (DRILL-4679) CONVERT_FROM() json format fails if 0 rows are received from upstream operator

2016-05-18 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15289167#comment-15289167 ] Aman Sinha commented on DRILL-4679: --- With my proposed fix of generating an empty MapVect

[jira] [Updated] (DRILL-4679) CONVERT_FROM() json format fails if 0 rows are received from upstream operator

2016-05-19 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4679: -- Assignee: Jinfeng Ni (was: Aman Sinha) > CONVERT_FROM() json format fails if 0 rows are received from

[jira] [Created] (DRILL-4693) Incorrect column ordering when CONVERT_FROM() json is used

2016-05-25 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4693: - Summary: Incorrect column ordering when CONVERT_FROM() json is used Key: DRILL-4693 URL: https://issues.apache.org/jira/browse/DRILL-4693 Project: Apache Drill I

[jira] [Commented] (DRILL-4693) Incorrect column ordering when CONVERT_FROM() json is used

2016-05-25 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15300247#comment-15300247 ] Aman Sinha commented on DRILL-4693: --- Based on an initial investigation the behavior can

[jira] [Assigned] (DRILL-4693) Incorrect column ordering when CONVERT_FROM() json is used

2016-05-25 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-4693: - Assignee: Aman Sinha > Incorrect column ordering when CONVERT_FROM() json is used >

[jira] [Updated] (DRILL-4694) CTAS in JSON format produces extraneous NULL fields

2016-05-25 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-4694: -- Description: Consider the following JSON file: {noformat} // file t2.json { "X" : { "key1" : "value1"

[jira] [Created] (DRILL-4694) CTAS in JSON format produces extraneous NULL fields

2016-05-25 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4694: - Summary: CTAS in JSON format produces extraneous NULL fields Key: DRILL-4694 URL: https://issues.apache.org/jira/browse/DRILL-4694 Project: Apache Drill Issue Type

[jira] [Commented] (DRILL-4705) Simple TSV file with quotes causes read error

2016-06-03 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15314278#comment-15314278 ] Aman Sinha commented on DRILL-4705: --- Can you try the method suggested in 'use quotation

  1   2   3   4   5   6   7   8   9   10   >