[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947760#comment-14947760
]
Chaoyu Tang commented on HIVE-11786:
Thanks [~sseth]. Maybe there are a large number of rows in
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947807#comment-14947807
]
Siddharth Seth commented on HIVE-11786:
---
Yes. There's a large number of entries - 2million+ in
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947594#comment-14947594
]
Chaoyu Tang commented on HIVE-11786:
Thank [~sseth] very much for the help. yes, the remaining two
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947562#comment-14947562
]
Siddharth Seth commented on HIVE-11786:
---
Quick note.
I created the following indexes.
{code}
CREATE
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947732#comment-14947732
]
Siddharth Seth commented on HIVE-11786:
---
No difference with the remaining indexes.
(The index
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14947848#comment-14947848
]
Chaoyu Tang commented on HIVE-11786:
If the query is rewritten to get PART_ID first and then use
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14946194#comment-14946194
]
Chaoyu Tang commented on HIVE-11786:
[~szehon] Yes, all joins occur on primary keys and indexed
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945923#comment-14945923
]
Szehon Ho commented on HIVE-11786:
--
[~ctang.ma] can you take a look at those queries and see if there are
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945892#comment-14945892
]
Siddharth Seth commented on HIVE-11786:
---
This patch seems to have caused a pretty big performance
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945895#comment-14945895
]
Siddharth Seth commented on HIVE-11786:
---
cc [~sershe], and thanks for pointing me to this jira for
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945908#comment-14945908
]
Siddharth Seth commented on HIVE-11786:
---
The expensive queries.
{code}
2015-10-06T17:25:20,120 DEBUG
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14945935#comment-14945935
]
Sergey Shelukhin commented on HIVE-11786:
-
See partition getting and how its separated into two
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14941867#comment-14941867
]
Szehon Ho commented on HIVE-11786:
--
Chatted with Chaoyu offline, this change actually looks good to me,
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14940534#comment-14940534
]
Szehon Ho commented on HIVE-11786:
--
Posting on behalf of HiveQA which was locked out:
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14940698#comment-14940698
]
Chaoyu Tang commented on HIVE-11786:
The test failure is not related to the patch.
> Deprecate the
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14902901#comment-14902901
]
Chaoyu Tang commented on HIVE-11786:
[~sershe] [~xuefuz] and [~ashutoshc] Could you review the patch
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14899923#comment-14899923
]
Chaoyu Tang commented on HIVE-11786:
The three failed tests seem not related to this patch.
>
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14877373#comment-14877373
]
Hive QA commented on HIVE-11786:
{color:red}Overall{color}: -1 at least one tests failed
Here are the
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14876615#comment-14876615
]
Hive QA commented on HIVE-11786:
{color:red}Overall{color}: -1 at least one tests failed
Here are the
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14803282#comment-14803282
]
Chaoyu Tang commented on HIVE-11786:
[~sershe] I uploaded a new patch to RB for review. Thanks
>
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14768865#comment-14768865
]
Chaoyu Tang commented on HIVE-11786:
Patch has been uploaded to https://reviews.apache.org/r/38429/.
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14791032#comment-14791032
]
Hive QA commented on HIVE-11786:
{color:red}Overall{color}: -1 at least one tests failed
Here are the
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14741531#comment-14741531
]
Sergey Shelukhin commented on HIVE-11786:
-
Makes sense
> Deprecate the use of redundant column in
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739130#comment-14739130
]
Pengcheng Xiong commented on HIVE-11786:
I totally agree that these redundant columns violate
[
https://issues.apache.org/jira/browse/HIVE-11786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739276#comment-14739276
]
Sergey Shelukhin commented on HIVE-11786:
-
Have you considered the perf impact on fetching column
25 matches
Mail list logo