[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-11-14 Thread Prasanth Jayachandran (JIRA)

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

Prasanth Jayachandran updated HIVE-15069:
-
   Resolution: Fixed
Fix Version/s: 2.2.0
   Status: Resolved  (was: Patch Available)

Patch committed to master. Thanks for the patch [~rajesh.balamohan]!

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Fix For: 2.2.0
>
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch, 
> HIVE-15069.3.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-27 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Attachment: HIVE-15069.3.patch

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch, 
> HIVE-15069.3.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-27 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Status: Patch Available  (was: Open)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch, 
> HIVE-15069.3.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-27 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Status: Open  (was: Patch Available)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Status: Patch Available  (was: Open)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Attachment: HIVE-15069.2.patch

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Attachment: (was: HIVE-15069.2.patch)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Attachment: HIVE-15069.2.patch

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch, HIVE-15069.2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Status: Open  (was: Patch Available)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Attachment: HIVE-15069.1.patch

With patch, compilation time comes down to "2.62" seconds vs 4-5 seconds 
earlier (1 node LLAP in my environment).  Also tried with Q-55 in single node 
LLAP. Without patch, it took ~1.3-1.5 seconds for query compilation. With the 
patch it takes 0.80 seconds.

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Status: Patch Available  (was: Open)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
> Attachments: HIVE-15069.1.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (HIVE-15069) Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query compilation

2016-10-26 Thread Rajesh Balamohan (JIRA)

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

Rajesh Balamohan updated HIVE-15069:

Priority: Minor  (was: Major)

> Optimize MetaStoreDirectSql:: aggrColStatsForPartitions during query 
> compilation
> 
>
> Key: HIVE-15069
> URL: https://issues.apache.org/jira/browse/HIVE-15069
> Project: Hive
>  Issue Type: Improvement
>  Components: Metastore
>Reporter: Rajesh Balamohan
>Assignee: Rajesh Balamohan
>Priority: Minor
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)