[jira] [Updated] (HIVE-21074) Hive bucketed table query pruning does not work for IS NOT NULL condition

2018-12-28 Thread Thai Bui (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thai Bui updated HIVE-21074: Attachment: HIVE-21074.patch > Hive bucketed table query pruning does not work for IS NOT NULL condition >

[jira] [Commented] (HIVE-21074) Hive bucketed table query pruning does not work for IS NOT NULL condition

2018-12-28 Thread Thai Bui (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16730573#comment-16730573 ] Thai Bui commented on HIVE-21074: - I'm attaching the patch for this work anyway in case anyone want to

[jira] [Commented] (HIVE-20977) Lazy evaluate the table object in PreReadTableEvent to improve get_partition performance

2018-12-28 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16730530#comment-16730530 ] Hive QA commented on HIVE-20977: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-20977) Lazy evaluate the table object in PreReadTableEvent to improve get_partition performance

2018-12-28 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16730523#comment-16730523 ] Hive QA commented on HIVE-20977: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem ||

[jira] [Updated] (HIVE-20977) Lazy evaluate the table object in PreReadTableEvent to improve get_partition performance

2018-12-28 Thread Karthik Manamcheri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Karthik Manamcheri updated HIVE-20977: -- Status: Patch Available (was: In Progress) > Lazy evaluate the table object in

[jira] [Updated] (HIVE-20977) Lazy evaluate the table object in PreReadTableEvent to improve get_partition performance

2018-12-28 Thread Karthik Manamcheri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Karthik Manamcheri updated HIVE-20977: -- Attachment: HIVE-20977.1.patch > Lazy evaluate the table object in PreReadTableEvent

[jira] [Updated] (HIVE-21077) Database should have creation time

2018-12-28 Thread Vihang Karajgaonkar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar updated HIVE-21077: --- Description: Currently, database do not have creation time like we have for tables

[jira] [Assigned] (HIVE-21077) Database should have creation time

2018-12-28 Thread Vihang Karajgaonkar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vihang Karajgaonkar reassigned HIVE-21077: -- > Database should have creation time > -- > >

[jira] [Resolved] (HIVE-21074) Hive bucketed table query pruning does not work for IS NOT NULL condition

2018-12-28 Thread Thai Bui (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thai Bui resolved HIVE-21074. - Resolution: Duplicate Fix Version/s: 4.0.0 This is fixed in 

[jira] [Work stopped] (HIVE-21045) Add connection pool info and rolling performance info to the metrics system

2018-12-28 Thread Karthik Manamcheri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-21045 stopped by Karthik Manamcheri. - > Add connection pool info and rolling performance info to the

[jira] [Work started] (HIVE-20977) Lazy evaluate the table object in PreReadTableEvent to improve get_partition performance

2018-12-28 Thread Karthik Manamcheri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-20977 started by Karthik Manamcheri. - > Lazy evaluate the table object in PreReadTableEvent to improve

[jira] [Commented] (HIVE-21075) Metastore: Drop partition performance downgrade with Postgres DB

2018-12-28 Thread Karthik Manamcheri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16730383#comment-16730383 ] Karthik Manamcheri commented on HIVE-21075: --- Could we add the index on CD_ID column? Any reason

[jira] [Commented] (HIVE-21067) TO_UNIX_TIMESTAMP (or UNIX_TIMESTAMP) treats argument timestamp as UTC

2018-12-28 Thread Andrey Zinovyev (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16730234#comment-16730234 ] Andrey Zinovyev commented on HIVE-21067: Well it is not that easy to read sql standard apparently

[jira] [Updated] (HIVE-21074) Hive bucketed table query pruning does not work for IS NOT NULL condition

2018-12-28 Thread Thai Bui (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thai Bui updated HIVE-21074: Component/s: (was: Query Planning) Logical Optimizer > Hive bucketed table query

[jira] [Assigned] (HIVE-21074) Hive bucketed table query pruning does not work for IS NOT NULL condition

2018-12-28 Thread Thai Bui (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-21074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thai Bui reassigned HIVE-21074: --- > Hive bucketed table query pruning does not work for IS NOT NULL condition >