[jira] [Comment Edited] (DRILL-4707) Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result

2016-06-08 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15321712#comment-15321712 ] Robert Hou edited comment on DRILL-4707 at 6/9/16 12:37 AM: Here is another

[jira] [Commented] (DRILL-4707) Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result

2016-06-08 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15321712#comment-15321712 ] Robert Hou commented on DRILL-4707: --- Here is another query: SELECT s.student_id as student, s.name as

[jira] [Updated] (DRILL-4707) Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result

2016-07-13 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4707: -- Reviewer: Robert Hou (was: Chun Chang) > Conflicting columns names under case-insensitive policy lead

[jira] [Closed] (DRILL-4514) Add describe schema command

2016-07-25 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-4514. - Tests pass. > Add describe schema command > - > >

[jira] [Commented] (DRILL-4514) Add describe schema command

2016-07-25 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15392490#comment-15392490 ] Robert Hou commented on DRILL-4514: --- Tests have been added, commit:

[jira] [Closed] (DRILL-4707) Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result

2016-07-27 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-4707. - Tests have passed. > Conflicting columns names under case-insensitive policy lead to either memory > leak

[jira] [Commented] (DRILL-4147) Union All operator runs in a single fragment

2016-08-06 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15410511#comment-15410511 ] Robert Hou commented on DRILL-4147: --- Here is a simple test case using lineitem. Lineitem can be small,

[jira] [Updated] (DRILL-4833) Union-All with a small cardinality input on one side does not get parallelized

2016-08-17 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4833: -- Reviewer: Robert Hou > Union-All with a small cardinality input on one side does not get parallelized >

[jira] [Created] (DRILL-4883) Drill Explorer returns "SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference ; a field reference identifier must not have the form of a qualified name (

2016-09-07 Thread Robert Hou (JIRA)
Robert Hou created DRILL-4883: - Summary: Drill Explorer returns "SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference ; a field reference identifier must not have the form of a qualified name (i.e., with "."). Key:

[jira] [Commented] (DRILL-3944) Drill MAXDIR Unknown variable or type "FILE_SEPARATOR"

2016-09-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15504960#comment-15504960 ] Robert Hou commented on DRILL-3944: --- This fix has been verified. > Drill MAXDIR Unknown variable or

[jira] [Reopened] (DRILL-3944) Drill MAXDIR Unknown variable or type "FILE_SEPARATOR"

2016-09-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reopened DRILL-3944: --- > Drill MAXDIR Unknown variable or type "FILE_SEPARATOR" >

[jira] [Closed] (DRILL-3944) Drill MAXDIR Unknown variable or type "FILE_SEPARATOR"

2016-09-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-3944. - Resolution: Fixed > Drill MAXDIR Unknown variable or type "FILE_SEPARATOR" >

[jira] [Updated] (DRILL-3944) Drill MAXDIR Unknown variable or type "FILE_SEPARATOR"

2016-09-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-3944: -- Reviewer: Robert Hou > Drill MAXDIR Unknown variable or type "FILE_SEPARATOR" >

[jira] [Closed] (DRILL-4147) Union All operator runs in a single fragment

2016-08-29 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-4147. - This fix has been verified. > Union All operator runs in a single fragment >

[jira] [Closed] (DRILL-4743) HashJoin's not fully parallelized in query plan

2016-08-29 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-4743. - Assignee: Robert Hou (was: Gautam Kumar Parai) This fix has been verified. > HashJoin's not fully

[jira] [Closed] (DRILL-4833) Union-All with a small cardinality input on one side does not get parallelized

2016-08-29 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-4833. - This fix has been verified. > Union-All with a small cardinality input on one side does not get parallelized

[jira] [Updated] (DRILL-4970) Wrong results when casting double to bigint or int

2016-10-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4970: -- Description: This query returns the wrong result 0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select

[jira] [Updated] (DRILL-4970) Wrong results when casting double to bigint or int

2016-10-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4970: -- Attachment: test_table > Wrong results when casting double to bigint or int >

[jira] [Commented] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2016-10-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15610345#comment-15610345 ] Robert Hou commented on DRILL-4971: --- Put the two files into a directory called "test". > query

[jira] [Updated] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2016-10-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4971: -- Attachment: low_table medium_table > query encounters system error: Statement "break

[jira] [Created] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2016-10-26 Thread Robert Hou (JIRA)
Robert Hou created DRILL-4971: - Summary: query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3" Key: DRILL-4971 URL:

[jira] [Updated] (DRILL-4970) Wrong results when casting double to bigint or int

2016-10-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4970: -- Description: This query returns the wrong result 0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select

[jira] [Created] (DRILL-4970) Wrong results when casting double to bigint or int

2016-10-26 Thread Robert Hou (JIRA)
Robert Hou created DRILL-4970: - Summary: Wrong results when casting double to bigint or int Key: DRILL-4970 URL: https://issues.apache.org/jira/browse/DRILL-4970 Project: Apache Drill Issue

[jira] [Commented] (DRILL-5018) Metadata cache has duplicate columnTypeInfo values

2016-11-08 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649289#comment-15649289 ] Robert Hou commented on DRILL-5018: --- For the second lineitem table, use CTAS with the first lineitem

[jira] [Commented] (DRILL-5018) Metadata cache has duplicate columnTypeInfo values

2016-11-08 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15649293#comment-15649293 ] Robert Hou commented on DRILL-5018: --- The metadata_caching/generated_caches/validate_cache3.q.fail test

[jira] [Comment Edited] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655397#comment-15655397 ] Robert Hou edited comment on DRILL-5035 at 11/10/16 10:36 PM: -- The partition

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655464#comment-15655464 ] Robert Hou commented on DRILL-5035: --- I set the new option to false and I do not see a problem. I will

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655306#comment-15655306 ] Robert Hou commented on DRILL-5035: --- I am using RC1. 0: jdbc:drill:zk=10.10.100.186:5181> select * from

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655378#comment-15655378 ] Robert Hou commented on DRILL-5035: --- The Hive table is partitioned on o_orderpriority, which is a

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655397#comment-15655397 ] Robert Hou commented on DRILL-5035: --- The partition only has null values. > Selecting timestamp value

[jira] [Created] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
Robert Hou created DRILL-5035: - Summary: Selecting timestamp value from Hive table causes IndexOutOfBoundsException Key: DRILL-5035 URL: https://issues.apache.org/jira/browse/DRILL-5035 Project: Apache

[jira] [Comment Edited] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655374#comment-15655374 ] Robert Hou edited comment on DRILL-5035 at 11/10/16 10:39 PM: -- This table is

[jira] [Comment Edited] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655397#comment-15655397 ] Robert Hou edited comment on DRILL-5035 at 11/10/16 10:39 PM: -- The partition

[jira] [Comment Edited] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655374#comment-15655374 ] Robert Hou edited comment on DRILL-5035 at 11/10/16 10:39 PM: -- This table is

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655479#comment-15655479 ] Robert Hou commented on DRILL-5035: --- I'm trying to figure out how to do that. Because it is a Hive

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655374#comment-15655374 ] Robert Hou commented on DRILL-5035: --- This table is partitioned on a varchar. The problem occurs with a

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655896#comment-15655896 ] Robert Hou commented on DRILL-5035: --- I am not able to use timestamp_impala yet. But I tried the

[jira] [Comment Edited] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655464#comment-15655464 ] Robert Hou edited comment on DRILL-5035 at 11/11/16 2:29 AM: - I set the new

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655476#comment-15655476 ] Robert Hou commented on DRILL-5035: --- Yes, I created it. It is a Hive table partitioned on a string. I

[jira] [Updated] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5035: -- Attachment: orders_parts_hive.tar This is a Hive partitioned table. It is partitioned on

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655504#comment-15655504 ] Robert Hou commented on DRILL-5035: --- Interesting. I exported Drill data to a tbl file. I edited the

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655535#comment-15655535 ] Robert Hou commented on DRILL-5035: --- ~/bin/parquet-meta 00_0 file:

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655566#comment-15655566 ] Robert Hou commented on DRILL-5035: --- I tried with Hive. It succeeds. > Selecting timestamp value from

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655518#comment-15655518 ] Robert Hou commented on DRILL-5035: --- I am not sure this is a release stopper. It may be due to the fact

[jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException

2016-11-10 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15655507#comment-15655507 ] Robert Hou commented on DRILL-5035: --- The DDL for the partitioned Hive table: create table

[jira] [Commented] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2016-11-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15658487#comment-15658487 ] Robert Hou commented on DRILL-4971: --- The same problem occurs on 1.8.0. > query encounters system error:

[jira] [Updated] (DRILL-4971) query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"

2016-11-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-4971: -- Description: This query returns an error. The stack trace suggests it might be a schema change issue,

[jira] [Updated] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column.

2016-11-30 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5086: -- Attachment: 0_0_5.parquet 0_0_4.parquet 0_0_3.parquet

[jira] [Updated] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column.

2016-11-30 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5086: -- Description: This query results in a ClassCastException when filter pushdown is used. The bigint

[jira] [Updated] (DRILL-5093) Explain plan shows all partitions when query scans all partitions, and filter pushdown is used with metadata caching.

2016-12-01 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5093: -- Attachment: drill.parquet_metadata > Explain plan shows all partitions when query scans all partitions,

[jira] [Updated] (DRILL-5093) Explain plan shows all partitions when query scans all partitions, and filter pushdown is used with metadata caching.

2016-12-01 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5093: -- Attachment: 0_0_5.parquet 0_0_4.parquet 0_0_3.parquet

[jira] [Created] (DRILL-5093) Explain plan shows all partitions when query scans all partitions, and filter pushdown is used with metadata caching.

2016-12-01 Thread Robert Hou (JIRA)
Robert Hou created DRILL-5093: - Summary: Explain plan shows all partitions when query scans all partitions, and filter pushdown is used with metadata caching. Key: DRILL-5093 URL:

[jira] [Updated] (DRILL-5093) Explain plan shows all partitions when query scans all partitions, and filter pushdown is used with metadata caching.

2016-12-01 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5093: -- Description: This query scans all the partitions because the partitions cannot be pruned. When

[jira] [Updated] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column and metadata caching.

2016-11-30 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5086: -- Description: This query results in a ClassCastException when filter pushdown is used with metadata

[jira] [Updated] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column and metadata caching.

2016-11-30 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5086: -- Summary: ClassCastException when filter pushdown is used with a bigint or float column and metadata

[jira] [Commented] (DRILL-5136) Some SQL statements fail when using Simba ODBC driver 1.3

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15762542#comment-15762542 ] Robert Hou commented on DRILL-5136: --- Comments from Robert Wu (Simba): This issue is likely caused by

[jira] [Updated] (DRILL-5136) Some SQL statements fail due to PreparedStatement

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5136: -- Summary: Some SQL statements fail due to PreparedStatement (was: Some SQL statements fail due to

[jira] [Updated] (DRILL-5136) Some SQL statements fail when using Simba ODBC driver 1.3

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5136: -- Assignee: Laurent Goujon > Some SQL statements fail when using Simba ODBC driver 1.3 >

[jira] [Updated] (DRILL-5136) Some SQL statements fail due to Prepared Statement API

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5136: -- Description: "show schemas" does not work. SQL>show schemas 1: SQLPrepare = [MapR][Drill] (1040) Drill

[jira] [Updated] (DRILL-5136) Some SQL statements fail due to Prepared Statement API

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5136: -- Summary: Some SQL statements fail due to Prepared Statement API (was: Some SQL statements fail when

[jira] [Comment Edited] (DRILL-5136) Some SQL statements fail due to Prepared Statement API

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15762542#comment-15762542 ] Robert Hou edited comment on DRILL-5136 at 12/19/16 11:10 PM: -- Comments from

[jira] [Created] (DRILL-5136) Some SQL statements fail when using Simba ODBC driver 1.3

2016-12-19 Thread Robert Hou (JIRA)
Robert Hou created DRILL-5136: - Summary: Some SQL statements fail when using Simba ODBC driver 1.3 Key: DRILL-5136 URL: https://issues.apache.org/jira/browse/DRILL-5136 Project: Apache Drill

[jira] [Updated] (DRILL-5136) Some SQL statements fail due to PreparedStatement

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5136: -- Description: "show schemas" does not work. SQL>show schemas 1: SQLPrepare = [MapR][Drill] (1040) Drill

[jira] [Commented] (DRILL-5136) Some SQL statements fail due to PreparedStatement

2016-12-19 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15762639#comment-15762639 ] Robert Hou commented on DRILL-5136: --- With this patch, the CTAS statement still does not work:

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

2017-03-21 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15934953#comment-15934953 ] Robert Hou commented on DRILL-5311: --- The framework will be updated to support ODBC. We plan to use a

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

2017-03-28 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15945783#comment-15945783 ] Robert Hou commented on DRILL-5316: --- I tried a couple of cluster IDs. I used random characters and

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

2017-03-28 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15945780#comment-15945780 ] Robert Hou commented on DRILL-5316: --- I asked Rob for some ideas on how to reproduce this problem. He

[jira] [Updated] (DRILL-5374) Parquet filter pushdown does not prune partition with nulls when predicate uses float column

2017-03-21 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5374: -- Attachment: drill.parquet_metadata 0_0_5.parquet 0_0_4.parquet

[jira] [Closed] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column and metadata caching.

2017-03-21 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5086. - > ClassCastException when filter pushdown is used with a bigint or float column > and metadata caching. >

[jira] [Created] (DRILL-5374) Parquet filter pushdown does not prune partition with nulls when predicate uses float column

2017-03-21 Thread Robert Hou (JIRA)
Robert Hou created DRILL-5374: - Summary: Parquet filter pushdown does not prune partition with nulls when predicate uses float column Key: DRILL-5374 URL: https://issues.apache.org/jira/browse/DRILL-5374

[jira] [Commented] (DRILL-5374) Parquet filter pushdown does not prune partition with nulls when predicate uses float column

2017-03-21 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15935591#comment-15935591 ] Robert Hou commented on DRILL-5374: --- This is the Scan step from the explain plan: {code} 00-06

[jira] [Commented] (DRILL-5086) ClassCastException when filter pushdown is used with a bigint or float column and metadata caching.

2017-03-21 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15935592#comment-15935592 ] Robert Hou commented on DRILL-5086: --- I have verified that the three SQL statements execute without

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

2017-04-02 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15952903#comment-15952903 ] Robert Hou commented on DRILL-5316: --- I repeated the steps above, with v1.3.6 on Windows. This time,

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

2017-04-02 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15952901#comment-15952901 ] Robert Hou commented on DRILL-5316: --- I tried to enable logging, but it did not seem to work. I set

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

2017-04-02 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15952900#comment-15952900 ] Robert Hou edited comment on DRILL-5316 at 4/3/17 12:32 AM: How can I verify

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

2017-04-02 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15952900#comment-15952900 ] Robert Hou commented on DRILL-5316: --- How can I verify that the C++ Client crashed? This is what I have

[jira] [Commented] (DRILL-5659) C++ Client (master) behavior is unstable resulting incorrect result or exception in API calls

2017-07-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082688#comment-16082688 ] Robert Hou commented on DRILL-5659: --- Hi Rob, Is this a blocking issue for you? How likely is it that a

[jira] [Commented] (DRILL-4281) Drill should support inbound impersonation

2017-07-25 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16100468#comment-16100468 ] Robert Hou commented on DRILL-4281: --- ODBC is verified. There is a new configuration parameter,

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

2017-07-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16102504#comment-16102504 ] Robert Hou commented on DRILL-5316: --- I tried to reproduce and verify this problem, with help from

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

2017-07-26 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16102504#comment-16102504 ] Robert Hou edited comment on DRILL-5316 at 7/27/17 12:14 AM: - I tried to

[jira] [Updated] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

2017-08-18 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5732: -- Attachment: drillbit.log > Unable to allocate sv2 for 9039 records, and not enough batchGroups to

[jira] [Created] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

2017-08-18 Thread Robert Hou (JIRA)
Robert Hou created DRILL-5732: - Summary: Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill. Key: DRILL-5732 URL: https://issues.apache.org/jira/browse/DRILL-5732 Project:

[jira] [Updated] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

2017-08-18 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5732: -- Attachment: 2668b522-5833-8fd2-0b6d-e685197f0ae3.sys.drill > Unable to allocate sv2 for 9039 records,

[jira] [Closed] (DRILL-5522) OOM during the merge and spill process of the managed external sort

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5522. - This has been verified. > OOM during the merge and spill process of the managed external sort >

[jira] [Resolved] (DRILL-5522) OOM during the merge and spill process of the managed external sort

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5522. --- Resolution: Fixed This has been resolved. > OOM during the merge and spill process of the managed

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: drillbit.log.sort > Varchar vector throws an assertion error when allocating a new vector >

[jira] [Closed] (DRILL-5445) Assertion Error in Managed External Sort when dealing with repeated maps

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5445. - This has been verified. > Assertion Error in Managed External Sort when dealing with repeated maps >

[jira] [Closed] (DRILL-5465) Managed external sort results in an OOM

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5465. - This has been verified. > Managed external sort results in an OOM > ---

[jira] [Closed] (DRILL-5253) External sort fails with OOM error (Fails to allocate sv2)

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5253. - This has been verified. > External sort fails with OOM error (Fails to allocate sv2) >

[jira] [Closed] (DRILL-5519) Sort fails to spill and results in an OOM

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5519. - This has been verified. > Sort fails to spill and results in an OOM >

[jira] [Closed] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5447. - This has been verified. > Managed External Sort : Unable to allocate sv2 vector >

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16162289#comment-16162289 ] Robert Hou commented on DRILL-5670: --- I have attached drillbit.log.sort. Can you confirm that sort has

[jira] [Resolved] (DRILL-5443) Managed External Sort fails with OOM while spilling to disk

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5443. --- Resolution: Fixed This has been resolved. > Managed External Sort fails with OOM while spilling to

[jira] [Closed] (DRILL-5442) Managed Sort: IndexOutOfBounds with a join over an inlist

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5442. - I have verified this has been fixed. > Managed Sort: IndexOutOfBounds with a join over an inlist >

[jira] [Closed] (DRILL-5443) Managed External Sort fails with OOM while spilling to disk

2017-09-11 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5443. - This has been verified. > Managed External Sort fails with OOM while spilling to disk >

[jira] [Commented] (DRILL-5478) Spill file size parameter is not honored by the managed external sort

2017-09-15 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16168247#comment-16168247 ] Robert Hou commented on DRILL-5478: --- We should still test it on behalf of Support. We don't have to

[jira] [Closed] (DRILL-5153) RESOURCE ERROR: Waited for 15000ms, but tasks for 'Get block maps' are not complete

2017-09-15 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5153. - Resolution: Cannot Reproduce > RESOURCE ERROR: Waited for 15000ms, but tasks for 'Get block maps' are

[jira] [Closed] (DRILL-5146) Unnecessary spilling to disk by sort when we only have 5000 rows with one column

2017-09-15 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5146. - I have verified this is fixed. > Unnecessary spilling to disk by sort when we only have 5000 rows with one

[jira] [Closed] (DRILL-5154) OOM error in external sort on top of 400GB data set generated using terasort benchamark

2017-09-15 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5154. - Resolution: Cannot Reproduce > OOM error in external sort on top of 400GB data set generated using

[jira] [Commented] (DRILL-5154) OOM error in external sort on top of 400GB data set generated using terasort benchamark

2017-09-15 Thread Robert Hou (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16167417#comment-16167417 ] Robert Hou commented on DRILL-5154: --- We do not have this table any more, so we cannot reproduce the

  1   2   3   4   5   >