[jira] [Created] (HIVE-11460) CTAS : Allows user to create table without explicit column names which fails stats creation on new table

2015-08-04 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-11460: -- Summary: CTAS : Allows user to create table without explicit column names which fails stats creation on new table Key: HIVE-11460 URL: https://issues.apache.org/jira/browse

[jira] [Created] (HIVE-11341) Avoid resizing of ASTNode tree

2015-07-22 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-11341: -- Summary: Avoid resizing of ASTNode tree Key: HIVE-11341 URL: https://issues.apache.org/jira/browse/HIVE-11341 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-11330) Add early termination for recursion in StatsRulesProcFactory$FilterStatsRule.evaluateExpression

2015-07-21 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-11330: -- Summary: Add early termination for recursion in StatsRulesProcFactory$FilterStatsRule.evaluateExpression Key: HIVE-11330 URL: https://issues.apache.org/jira/browse/HIVE-11330

[jira] [Created] (HIVE-11299) Hive query planning allocating lots of memory and hitting OOMs

2015-07-17 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-11299: -- Summary: Hive query planning allocating lots of memory and hitting OOMs Key: HIVE-11299 URL: https://issues.apache.org/jira/browse/HIVE-11299 Project: Hive

Re: Review Request 36335: Reset the fields in class JoinStatsRule in StatsRulesProcFactory

2015-07-08 Thread Mostafa Mokhtar
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/36335/#review91057 --- Ship it! Ship It! - Mostafa Mokhtar On July 8, 2015, 11:37 p.m

Re: Review Request 35868: HIVE-11107

2015-06-30 Thread Mostafa Mokhtar
tps://reviews.apache.org/r/35868/#comment142858> Also I recommend adding one more variation targeting partitioned tables for store_*, catalog_* and web_*. - Mostafa Mokhtar On June 25, 2015, 11:27 a.m., Hari Sankar Sivarama Subramaniyan

Re: Review Request 35868: HIVE-11107

2015-06-30 Thread Mostafa Mokhtar
tps://reviews.apache.org/r/35868/#comment142857> Add "Analyze table [TABLE_NAME] compute statistics for columns;" And consider using tez not MR. Also enable hive.stats.fetch.column.stats. - Mostafa Mokhtar On June 25, 2015, 11:27 a.m., Hari Sankar Sivarama Su

Re: Review Request 34586: HIVE-10704

2015-06-11 Thread Mostafa Mokhtar
if (tableSize <= 0) { fallbackToEqualProportions = true; break; } - Mostafa Mokhtar On May 27, 2015, 6:33 a.m., Mostafa Mokhtar wrote: > > --- > This is an automatically generated e-mail. To reply, visit: &g

Re: Review Request 34586: HIVE-10704

2015-05-26 Thread Mostafa Mokhtar
/diff/ Testing --- Thanks, Mostafa Mokhtar

Re: Review Request 34586: HIVE-10704

2015-05-26 Thread Mostafa Mokhtar
://reviews.apache.org/r/34586/diff/ Testing --- Thanks, Mostafa Mokhtar

Re: Review Request 34586: HIVE-10704

2015-05-26 Thread Mostafa Mokhtar
://reviews.apache.org/r/34586/diff/ Testing --- File Attachments (updated) HIVE-10704.3.patch https://reviews.apache.org/media/uploaded/files/2015/05/27/4a999c9c-1c3f-44dd-a321-a4157a067300__HIVE-10704.3.patch Thanks, Mostafa Mokhtar

Review Request 34586: HIVE-10704

2015-05-21 Thread Mostafa Mokhtar
/ Testing --- Thanks, Mostafa Mokhtar

[jira] [Created] (HIVE-10793) Hybrid Hybrid Grace Hash Join : Don't allocate all hash table memory upfront

2015-05-21 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10793: -- Summary: Hybrid Hybrid Grace Hash Join : Don't allocate all hash table memory upfront Key: HIVE-10793 URL: https://issues.apache.org/jira/browse/HIVE-

[jira] [Created] (HIVE-10609) Vectorization : Q64 fails with ClassCastException

2015-05-04 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10609: -- Summary: Vectorization : Q64 fails with ClassCastException Key: HIVE-10609 URL: https://issues.apache.org/jira/browse/HIVE-10609 Project: Hive Issue

[jira] [Created] (HIVE-10557) CBO : Support reference to alias in queries

2015-04-30 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10557: -- Summary: CBO : Support reference to alias in queries Key: HIVE-10557 URL: https://issues.apache.org/jira/browse/HIVE-10557 Project: Hive Issue Type

[jira] [Created] (HIVE-10537) ConvertJoinMapJoin should take into account JOINNOCONDITIONALTASKTHRESHOLD when packing tables in a Vertex

2015-04-29 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10537: -- Summary: ConvertJoinMapJoin should take into account JOINNOCONDITIONALTASKTHRESHOLD when packing tables in a Vertex Key: HIVE-10537 URL: https://issues.apache.org/jira/browse

[jira] [Created] (HIVE-10484) Vectorization : Big Table Retained Mapping duplicate column

2015-04-24 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10484: -- Summary: Vectorization : Big Table Retained Mapping duplicate column Key: HIVE-10484 URL: https://issues.apache.org/jira/browse/HIVE-10484 Project: Hive

[jira] [Created] (HIVE-10446) Hybrid Hybrid Grace Hash Join : java.lang.IllegalArgumentException in Kryo while spilling big table

2015-04-22 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10446: -- Summary: Hybrid Hybrid Grace Hash Join : java.lang.IllegalArgumentException in Kryo while spilling big table Key: HIVE-10446 URL: https://issues.apache.org/jira/browse/HIVE

Re: Review Request 33367: Aggregate stats cache for RDBMS based metastore codepath

2015-04-22 Thread Mostafa Mokhtar
eaned in how long. Also print number of nodes before/after - Mostafa Mokhtar On April 20, 2015, 6:44 p.m., Vaibhav Gumashta wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://re

Re: Review Request 33367: Aggregate stats cache for RDBMS based metastore codepath

2015-04-21 Thread Mostafa Mokhtar
<https://reviews.apache.org/r/33367/#comment131382> There already is a BloomFilter implementaion in org.apache.hadoop.hive.ql.io.filters. Can this be used instead of the new one? - Mostafa Mokhtar On April 20, 2015, 6:44 p.m., Vaibhav Gumashta

[jira] [Created] (HIVE-10412) CBO : Calculate join selectivity when computing HiveJoin cost

2015-04-20 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10412: -- Summary: CBO : Calculate join selectivity when computing HiveJoin cost Key: HIVE-10412 URL: https://issues.apache.org/jira/browse/HIVE-10412 Project: Hive

[jira] [Created] (HIVE-10369) CBO: Don't use HiveDefaultCostModel when With Tez and hive.cbo.costmodel.extended enabled

2015-04-16 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10369: -- Summary: CBO: Don't use HiveDefaultCostModel when With Tez and hive.cbo.costmodel.extended enabled Key: HIVE-10369 URL: https://issues.apache.org/jira/browse/HIVE-

[jira] [Created] (HIVE-10350) CBO: With hive.cbo.costmodel.extended enabled IO cost is negative

2015-04-15 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10350: -- Summary: CBO: With hive.cbo.costmodel.extended enabled IO cost is negative Key: HIVE-10350 URL: https://issues.apache.org/jira/browse/HIVE-10350 Project: Hive

[jira] [Created] (HIVE-10337) CBO (Calcite Return Path): java.lang.IndexOutOfBoundsException for query with rank() over(partition ...)

2015-04-14 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10337: -- Summary: CBO (Calcite Return Path): java.lang.IndexOutOfBoundsException for query with rank() over(partition ...) Key: HIVE-10337 URL: https://issues.apache.org/jira/browse

[jira] [Created] (HIVE-10331) ORC : Is null SARG filters out all row groups written in old ORC format

2015-04-14 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10331: -- Summary: ORC : Is null SARG filters out all row groups written in old ORC format Key: HIVE-10331 URL: https://issues.apache.org/jira/browse/HIVE-10331 Project

[jira] [Created] (HIVE-10244) Vectorization : TPC-DS Q80 fails with java.lang.ClassCastException when hive.vectorized.execution.reduce.enabled is enabled

2015-04-07 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10244: -- Summary: Vectorization : TPC-DS Q80 fails with java.lang.ClassCastException when hive.vectorized.execution.reduce.enabled is enabled Key: HIVE-10244 URL: https

[jira] [Created] (HIVE-10194) CBO (Calcite Return Path): Q94 generates cross product

2015-04-02 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10194: -- Summary: CBO (Calcite Return Path): Q94 generates cross product Key: HIVE-10194 URL: https://issues.apache.org/jira/browse/HIVE-10194 Project: Hive

[jira] [Created] (HIVE-10193) CBO (Calcite Return Path): Q94 generates cross product

2015-04-02 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10193: -- Summary: CBO (Calcite Return Path): Q94 generates cross product Key: HIVE-10193 URL: https://issues.apache.org/jira/browse/HIVE-10193 Project: Hive

[jira] [Created] (HIVE-10153) CBO (Calcite Return Path): TPC-DS Q15 in-efficient join order

2015-03-30 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10153: -- Summary: CBO (Calcite Return Path): TPC-DS Q15 in-efficient join order Key: HIVE-10153 URL: https://issues.apache.org/jira/browse/HIVE-10153 Project: Hive

[jira] [Created] (HIVE-10123) Hybrid grace Hash join : Use estimate key count from stats to initialize BytesBytesMultiHashMap

2015-03-27 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10123: -- Summary: Hybrid grace Hash join : Use estimate key count from stats to initialize BytesBytesMultiHashMap Key: HIVE-10123 URL: https://issues.apache.org/jira/browse/HIVE-10123

[jira] [Created] (HIVE-10118) CBO :

2015-03-27 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10118: -- Summary: CBO : Key: HIVE-10118 URL: https://issues.apache.org/jira/browse/HIVE-10118 Project: Hive Issue Type: Sub-task Reporter: Mostafa

[jira] [Created] (HIVE-10107) Union All : Vertex missing stats resulting in OOM and in-efficient plans

2015-03-26 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10107: -- Summary: Union All : Vertex missing stats resulting in OOM and in-efficient plans Key: HIVE-10107 URL: https://issues.apache.org/jira/browse/HIVE-10107 Project

[jira] [Created] (HIVE-10106) Regression : Dynamic partition pruning not working after HIVE-9976

2015-03-26 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-10106: -- Summary: Regression : Dynamic partition pruning not working after HIVE-9976 Key: HIVE-10106 URL: https://issues.apache.org/jira/browse/HIVE-10106 Project: Hive

Re: ORC separate project

2015-03-20 Thread Mostafa Mokhtar
Hi Owen, Please add me as well. Thanks Mostafa On 3/19/15, 3:21 PM, "Xuefu Zhang" wrote: >Hi Owen, > >I'd like to get involved. > >Thanks, >Xuefu > >On Thu, Mar 19, 2015 at 2:44 PM, Owen O'Malley wrote: > >> All, >>Over the last year, there has been a fair number of projects that >>want >

Re: Review Request 32178: HIVE-9997 minor tweaks for bytes mapjoin hash table

2015-03-17 Thread Mostafa Mokhtar
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32178/#review76868 --- Ship it! Ship It! - Mostafa Mokhtar On March 17, 2015, 10:41

[jira] [Commented] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326844#comment-14326844 ] Mostafa Mokhtar commented on HIVE-9647: --- Awesome :) I am happy we can fix

[jira] [Created] (HIVE-9714) Physical optimizer : Under estimation for left join outer condition

2015-02-17 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9714: - Summary: Physical optimizer : Under estimation for left join outer condition Key: HIVE-9714 URL: https://issues.apache.org/jira/browse/HIVE-9714 Project: Hive

[jira] [Updated] (HIVE-9713) CBO : inefficient join order created for left join outer condition

2015-02-17 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9713: -- Description: For the query below which is a subset of TPC-DS Query 80, CBO joins catalog_sales

[jira] [Created] (HIVE-9713) CBO : inefficient join order created for left join outer condition

2015-02-17 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9713: - Summary: CBO : inefficient join order created for left join outer condition Key: HIVE-9713 URL: https://issues.apache.org/jira/browse/HIVE-9713 Project: Hive

[jira] [Updated] (HIVE-9712) Hive : Row count and data size are set to LONG.MAX when source table has 0 rows

2015-02-17 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9712: -- Summary: Hive : Row count and data size are set to LONG.MAX when source table has 0 rows (was

[jira] [Created] (HIVE-9712) Hive : Row count and data size are set to LONG.MAX when filter is applied on an estimate of 0

2015-02-17 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9712: - Summary: Hive : Row count and data size are set to LONG.MAX when filter is applied on an estimate of 0 Key: HIVE-9712 URL: https://issues.apache.org/jira/browse/HIVE-9712

[jira] [Created] (HIVE-9695) Redundant filter operator in reducer Vertex when CBO is disabled

2015-02-15 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9695: - Summary: Redundant filter operator in reducer Vertex when CBO is disabled Key: HIVE-9695 URL: https://issues.apache.org/jira/browse/HIVE-9695 Project: Hive

[jira] [Commented] (HIVE-9495) Map Side aggregation affecting map performance

2015-02-12 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14319633#comment-14319633 ] Mostafa Mokhtar commented on HIVE-9495: --- [~navis] I believe this is why

[jira] [Updated] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9647: -- Summary: Discrepancy in cardinality estimates between partitioned and un-partitioned tables

[jira] [Updated] (HIVE-9647) Discrepancy in CBO between partitioned and un-partitioned tables

2015-02-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9647: -- Description: High-level summary HiveRelMdSelectivity.computeInnerJoinSelectivity relies on per

[jira] [Updated] (HIVE-9647) Discrepancy in CBO between partitioned and un-partitioned tables

2015-02-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9647: -- Description: High-level summary HiveRelMdSelectivity.computeInnerJoinSelectivity relies on per

[jira] [Updated] (HIVE-9647) Discrepancy in CBO between partitioned and un-partitioned tables

2015-02-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9647: -- Description: High-level summary HiveRelMdSelectivity.computeInnerJoinSelectivity relies on per

[jira] [Created] (HIVE-9647) Discrepancy in CBO between partitioned and un-partitioned tables

2015-02-10 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9647: - Summary: Discrepancy in CBO between partitioned and un-partitioned tables Key: HIVE-9647 URL: https://issues.apache.org/jira/browse/HIVE-9647 Project: Hive

[jira] [Created] (HIVE-9623) NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema

2015-02-09 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9623: - Summary: NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema Key: HIVE-9623 URL: https://issues.apache.org

[jira] [Created] (HIVE-9624) NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema

2015-02-09 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9624: - Summary: NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema Key: HIVE-9624 URL: https://issues.apache.org

[jira] [Updated] (HIVE-9604) CBO : Presence of hybrid join condition sets of join order optimizations

2015-02-06 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9604: -- Component/s: CBO Affects Version/s: 0.14.0 > CBO : Presence of hybrid join condit

[jira] [Created] (HIVE-9604) CBO : Presence of hybrid join condition sets of join order optimizations

2015-02-06 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9604: - Summary: CBO : Presence of hybrid join condition sets of join order optimizations Key: HIVE-9604 URL: https://issues.apache.org/jira/browse/HIVE-9604 Project: Hive

[jira] [Created] (HIVE-9602) Hive on Tez : Launch an application master only when needed

2015-02-06 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9602: - Summary: Hive on Tez : Launch an application master only when needed Key: HIVE-9602 URL: https://issues.apache.org/jira/browse/HIVE-9602 Project: Hive

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-01-15 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9392: -- Summary: JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column

[jira] [Created] (HIVE-9392) Hive : JoinStatsRule overwrites the column statistics in HashMap because column names have duplicate fqColumnName

2015-01-15 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9392: - Summary: Hive : JoinStatsRule overwrites the column statistics in HashMap because column names have duplicate fqColumnName Key: HIVE-9392 URL: https://issues.apache.org/jira

[jira] [Updated] (HIVE-9368) Physical optimizer : Join order in Explain is different from join order provided by Calcite

2015-01-13 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9368: -- Attachment: explain_fetch_column_stats_on.txt explain_fetch_column_stats_off.txt

[jira] [Created] (HIVE-9368) Physical optimizer : Join order in Explain is different from join order provided by Calcite

2015-01-13 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9368: - Summary: Physical optimizer : Join order in Explain is different from join order provided by Calcite Key: HIVE-9368 URL: https://issues.apache.org/jira/browse/HIVE-9368

[jira] [Updated] (HIVE-9277) Hybrid Hybrid Grace Hash Join

2015-01-07 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-9277: -- Assignee: (was: Mostafa Mokhtar) > Hybrid Hybrid Grace Hash J

[jira] [Assigned] (HIVE-9277) Hybrid Hybrid Grace Hash Join

2015-01-07 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar reassigned HIVE-9277: - Assignee: Mostafa Mokhtar > Hybrid Hybrid Grace Hash J

[jira] [Created] (HIVE-9069) Simplify filter predicates for CBO

2014-12-10 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9069: - Summary: Simplify filter predicates for CBO Key: HIVE-9069 URL: https://issues.apache.org/jira/browse/HIVE-9069 Project: Hive Issue Type: Bug

[jira] [Assigned] (HIVE-7913) Simplify filter predicates for CBO

2014-12-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar reassigned HIVE-7913: - Assignee: Mostafa Mokhtar (was: Laljo John Pullokkaran) > Simplify filter predicates

[jira] [Commented] (HIVE-7913) Simplify filter predicates for CBO

2014-12-10 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14241866#comment-14241866 ] Mostafa Mokhtar commented on HIVE-7913: --- [~jpullokkaran] Looks like this is stil

[jira] [Created] (HIVE-9068) Hive : With CBO disabled Vectorization in Map join disabled causing 100% increase in elapsed time and CPU (possibly due to redundant filter operator)

2014-12-10 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-9068: - Summary: Hive : With CBO disabled Vectorization in Map join disabled causing 100% increase in elapsed time and CPU (possibly due to redundant filter operator) Key: HIVE-9068

[jira] [Commented] (HIVE-8805) CBO skipped due to SemanticException: Line 0:-1 Both left and right aliases encountered in JOIN 'avg_cs_ext_discount_amt'

2014-11-11 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14207466#comment-14207466 ] Mostafa Mokhtar commented on HIVE-8805: --- Ran TPC-DS 30TB and all good. &

[jira] [Commented] (HIVE-8805) CBO skipped due to SemanticException: Line 0:-1 Both left and right aliases encountered in JOIN 'avg_cs_ext_discount_amt'

2014-11-11 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14206201#comment-14206201 ] Mostafa Mokhtar commented on HIVE-8805: --- [~jpullokkaran] [~hagleitn] Validatio

[jira] [Created] (HIVE-8805) CBO skipped due to SemanticException: Line 0:-1 Both left and right aliases encountered in JOIN 'avg_cs_ext_discount_amt'

2014-11-10 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8805: - Summary: CBO skipped due to SemanticException: Line 0:-1 Both left and right aliases encountered in JOIN 'avg_cs_ext_discount_amt' Key: HIVE-8805 URL: https://issues.

[jira] [Created] (HIVE-8769) Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected)

2014-11-06 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8769: - Summary: Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) Key: HIVE-8769 URL: https://issues.apache.org/jira

[jira] [Created] (HIVE-8767) CBO : Join on inequality results in in-correct join order

2014-11-06 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8767: - Summary: CBO : Join on inequality results in in-correct join order Key: HIVE-8767 URL: https://issues.apache.org/jira/browse/HIVE-8767 Project: Hive Issue

[jira] [Created] (HIVE-8765) TPC-DS Q21 : Incorrect join order makes query run slower (Not scaling selectivity by NDV)

2014-11-06 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8765: - Summary: TPC-DS Q21 : Incorrect join order makes query run slower (Not scaling selectivity by NDV) Key: HIVE-8765 URL: https://issues.apache.org/jira/browse/HIVE-8765

[jira] [Commented] (HIVE-8556) introduce overflow control and sanity check to BytesBytesMapJoin

2014-11-06 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14201002#comment-14201002 ] Mostafa Mokhtar commented on HIVE-8556: --- Looks good to me [~prasan

[jira] [Created] (HIVE-8752) Disjunction cardinality estimation has selectivity of 1

2014-11-05 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8752: - Summary: Disjunction cardinality estimation has selectivity of 1 Key: HIVE-8752 URL: https://issues.apache.org/jira/browse/HIVE-8752 Project: Hive Issue

[jira] [Updated] (HIVE-8747) Estimate number of rows for table with 0 rows overflows resulting in an in-efficient plan

2014-11-05 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8747: -- Description: ship_mode table has 0 rows. Query {code} select count(*) from

[jira] [Created] (HIVE-8747) Estimate number of rows for table with 0 rows overflows resulting in an in-efficient plan

2014-11-05 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8747: - Summary: Estimate number of rows for table with 0 rows overflows resulting in an in-efficient plan Key: HIVE-8747 URL: https://issues.apache.org/jira/browse/HIVE-8747

[jira] [Updated] (HIVE-8731) TPC-DS Q49 : Semantic analyzer order by is not honored when used after union all

2014-11-04 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8731: -- Summary: TPC-DS Q49 : Semantic analyzer order by is not honored when used after union all (was

[jira] [Updated] (HIVE-8731) TPC-DS Q49 : Semantic analyzer order by is not honored when used after union all

2014-11-04 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8731: -- Assignee: Gunther Hagleitner (was: Matt McCline) > TPC-DS Q49 : Semantic analyzer order by

[jira] [Created] (HIVE-8731) TPC-DS Q49 : More rows are returned than the limit set in the query

2014-11-04 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8731: - Summary: TPC-DS Q49 : More rows are returned than the limit set in the query Key: HIVE-8731 URL: https://issues.apache.org/jira/browse/HIVE-8731 Project: Hive

[jira] [Updated] (HIVE-8727) Dag summary has incorrect row counts and duration per vertex

2014-11-04 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8727: -- Attachment: HIVE-8727.1.patch > Dag summary has incorrect row counts and duration per ver

[jira] [Created] (HIVE-8727) Dag summary has incorrect row counts and duration per vertex

2014-11-04 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8727: - Summary: Dag summary has incorrect row counts and duration per vertex Key: HIVE-8727 URL: https://issues.apache.org/jira/browse/HIVE-8727 Project: Hive

[jira] [Commented] (HIVE-8526) Hive : CBO incorrect join order in TPC-DS Q45 as self join selectivity has incorrect CE

2014-10-31 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14192259#comment-14192259 ] Mostafa Mokhtar commented on HIVE-8526: --- [~rhbutani] [~hagleitn] [~jpullokk

[jira] [Updated] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-31 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8671: -- Attachment: HIVE-8671.2.patch [~sershe] > Overflow in estimate row count and data size w

[jira] [Commented] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-31 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14191964#comment-14191964 ] Mostafa Mokhtar commented on HIVE-8671: --- [~sershe] Patch attached handles

[jira] [Updated] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-31 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8671: -- Attachment: HIVE-8671.1.patch > Overflow in estimate row count and data size with fetch col

[jira] [Commented] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-30 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14191285#comment-14191285 ] Mostafa Mokhtar commented on HIVE-8671: --- For the code below the query had

[jira] [Commented] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-30 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14191274#comment-14191274 ] Mostafa Mokhtar commented on HIVE-8671: --- This is where the bug is : Since we hi

[jira] [Created] (HIVE-8677) TPC-DS Q51 : fails with "init not supported" exception in GenericUDAFStreamingEvaluator.init

2014-10-30 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8677: - Summary: TPC-DS Q51 : fails with "init not supported" exception in GenericUDAFStreamingEvaluator.init Key: HIVE-8677 URL: https://issues.apache.org/jira/browse

[jira] [Updated] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-30 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8671: -- Description: Overflow in row counts and data size for several TPC-DS queries. Interestingly the

[jira] [Created] (HIVE-8671) Overflow in estimate row count and data size with fetch column stats

2014-10-30 Thread Mostafa Mokhtar (JIRA)
Mostafa Mokhtar created HIVE-8671: - Summary: Overflow in estimate row count and data size with fetch column stats Key: HIVE-8671 URL: https://issues.apache.org/jira/browse/HIVE-8671 Project: Hive

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-29 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: (was: HIVE-8495.5.patch) > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-29 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.5.patch > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-29 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.5.patch [~prasanth_j] > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-29 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.4.patch > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: (was: HIVE-8495.3.patch) > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.3.patch > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.3.patch > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.2.patch > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: (was: HIVE-8495.2.patch) > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-28 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.2.patch > Add progress bar for Hive on Tez quer

[jira] [Commented] (HIVE-8526) Hive : CBO incorrect join order in TPC-DS Q45 as self join selectivity has incorrect CE

2014-10-27 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14186374#comment-14186374 ] Mostafa Mokhtar commented on HIVE-8526: --- [~rhbutani] Using the patch the wrong

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-25 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: (was: HIVE-8495.2.patch) > Add progress bar for Hive on Tez quer

[jira] [Updated] (HIVE-8495) Add progress bar for Hive on Tez queries

2014-10-25 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mostafa Mokhtar updated HIVE-8495: -- Attachment: HIVE-8495.2.patch > Add progress bar for Hive on Tez quer

  1   2   3   4   >