[jira] [Commented] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15532050#comment-15532050 ] Chetna Chaudhari commented on HIVE-11812: - [~jdere]: I am running test in India Time Zone. Yes the

[jira] [Commented] (HIVE-14772) NPE when MSCK REPAIR

[ https://issues.apache.org/jira/browse/HIVE-14772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529759#comment-15529759 ] Chetna Chaudhari commented on HIVE-14772: - Verified the issue, issue occurs on release-2.1.0

[jira] [Comment Edited] (HIVE-14385) Show create table does not display comments

[ https://issues.apache.org/jira/browse/HIVE-14385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529638#comment-15529638 ] Chetna Chaudhari edited comment on HIVE-14385 at 9/28/16 1:41 PM: --

[jira] [Commented] (HIVE-14385) Show create table does not display comments

[ https://issues.apache.org/jira/browse/HIVE-14385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529638#comment-15529638 ] Chetna Chaudhari commented on HIVE-14385: - Verified the issue, issue occurs only if we use show

[jira] [Commented] (HIVE-14653) week value is different between weekofyear(date) and date_format(date, "ww")

[ https://issues.apache.org/jira/browse/HIVE-14653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529282#comment-15529282 ] Chetna Chaudhari commented on HIVE-14653: - [~shawzhou]: Please provide more information like

[jira] [Assigned] (HIVE-14657) datediff function produce different results with timestamp and string combination

[ https://issues.apache.org/jira/browse/HIVE-14657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-14657: --- Assignee: Chetna Chaudhari > datediff function produce different results with

[jira] [Commented] (HIVE-11974) Table name created using long name does not display full name in show tables command

[ https://issues.apache.org/jira/browse/HIVE-11974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529130#comment-15529130 ] Chetna Chaudhari commented on HIVE-11974: - [~chetdb]: Can you please provide more info here. By

[jira] [Commented] (HIVE-14657) datediff function produce different results with timestamp and string combination

[ https://issues.apache.org/jira/browse/HIVE-14657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529021#comment-15529021 ] Chetna Chaudhari commented on HIVE-14657: - Issue is resolved with HIVE-11812 patch. Tested and

[jira] [Updated] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11812: Status: Patch Available (was: In Progress) > datediff sometimes returns incorrect results

[jira] [Updated] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11812: Attachment: HIVE-11812.1.patch Please review the patch. > datediff sometimes returns

[jira] [Commented] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15528773#comment-15528773 ] Chetna Chaudhari commented on HIVE-11812: - Debugged this issue, issue exists because of

[jira] [Commented] (HIVE-11270) Tez gives different responses when run on Physical tables and logical views

[ https://issues.apache.org/jira/browse/HIVE-11270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327560#comment-15327560 ] Chetna Chaudhari commented on HIVE-11270: - @kannanpoem1984: This used to happen intermittently on

[jira] [Commented] (HIVE-13967) CREATE table fails when 'values' column name is found on the table spec.

[ https://issues.apache.org/jira/browse/HIVE-13967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15320190#comment-15320190 ] Chetna Chaudhari commented on HIVE-13967: - It is expected behavior, *values* is a reserved

[jira] [Commented] (HIVE-12592) Expose connection pool tuning props in TxnHandler

[ https://issues.apache.org/jira/browse/HIVE-12592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15140559#comment-15140559 ] Chetna Chaudhari commented on HIVE-12592: - [~ekoifman]: The BoneCPConfig() constructor loads the

[jira] [Commented] (HIVE-12592) Expose connection pool tuning props in TxnHandler

[ https://issues.apache.org/jira/browse/HIVE-12592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15136645#comment-15136645 ] Chetna Chaudhari commented on HIVE-12592: - [~ekoifman]: Any progress on this? If not, I would like

[jira] [Commented] (HIVE-12322) Remove hive.jar.path config

[ https://issues.apache.org/jira/browse/HIVE-12322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14995636#comment-14995636 ] Chetna Chaudhari commented on HIVE-12322: - The failures are due to {{assertEquals(true, false)}}

[jira] [Updated] (HIVE-12325) Turn hive.map.groupby.sorted on by default

[ https://issues.apache.org/jira/browse/HIVE-12325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-12325: Attachment: HIVE-12325.1.patch Have removed {{hive.map.groupby.sorted.testmode}} and

[jira] [Assigned] (HIVE-12325) Turn hive.map.groupby.sorted on by default

[ https://issues.apache.org/jira/browse/HIVE-12325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-12325: --- Assignee: Chetna Chaudhari > Turn hive.map.groupby.sorted on by default >

[jira] [Assigned] (HIVE-12322) Remove hive.jar.path config

[ https://issues.apache.org/jira/browse/HIVE-12322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-12322: --- Assignee: Chetna Chaudhari > Remove hive.jar.path config >

[jira] [Updated] (HIVE-12322) Remove hive.jar.path config

[ https://issues.apache.org/jira/browse/HIVE-12322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-12322: Attachment: HIVE-12322.1.patch I have removed the config and updated patch. [~ashutoshc]

[jira] [Commented] (HIVE-12325) Turn hive.map.groupby.sorted on by default

[ https://issues.apache.org/jira/browse/HIVE-12325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14991072#comment-14991072 ] Chetna Chaudhari commented on HIVE-12325: - I think along with this we should turn on

[jira] [Commented] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985298#comment-14985298 ] Chetna Chaudhari commented on HIVE-11812: - Seems I don't have permissions to edit my own comments.

[jira] [Commented] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14985125#comment-14985125 ] Chetna Chaudhari commented on HIVE-11812: - I am able to reproduce the issue with given steps. More

[jira] [Assigned] (HIVE-11812) datediff sometimes returns incorrect results when called with dates

[ https://issues.apache.org/jira/browse/HIVE-11812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-11812: --- Assignee: Chetna Chaudhari > datediff sometimes returns incorrect results when

[jira] [Updated] (HIVE-11582) Remove conf variable hive.mapred.supports.subdirectories

[ https://issues.apache.org/jira/browse/HIVE-11582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11582: Attachment: HIVE-11582.3.patch > Remove conf variable hive.mapred.supports.subdirectories >

[jira] [Updated] (HIVE-11582) Remove conf variable hive.mapred.supports.subdirectories

[ https://issues.apache.org/jira/browse/HIVE-11582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11582: Attachment: HIVE-11582.1.patch Removed conf variable. [~ashutoshc] Please review. > Remove

[jira] [Assigned] (HIVE-11582) Remove conf variable hive.mapred.supports.subdirectories

[ https://issues.apache.org/jira/browse/HIVE-11582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-11582: --- Assignee: Chetna Chaudhari > Remove conf variable

[jira] [Updated] (HIVE-11582) Remove conf variable hive.mapred.supports.subdirectories

[ https://issues.apache.org/jira/browse/HIVE-11582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11582: Attachment: HIVE-11582.2.patch [~ashutoshc] Thanks for the review. I have worked on

[jira] [Commented] (HIVE-11961) Create table displays Result inappropriately in beeline.

[ https://issues.apache.org/jira/browse/HIVE-11961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14972465#comment-14972465 ] Chetna Chaudhari commented on HIVE-11961: - [~chetdb] it shows 'No rows affected (0.62 seconds)'. I

[jira] [Commented] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14963337#comment-14963337 ] Chetna Chaudhari commented on HIVE-11735: - [~ashutoshc]: Changes in column aliases and RR are

[jira] [Commented] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14961904#comment-14961904 ] Chetna Chaudhari commented on HIVE-11735: - [~ashutoshc]: This issue will occur in all queries

[jira] [Commented] (HIVE-12165) wrong result when hive.optimize.sampling.orderby=true with some aggregate functions

[ https://issues.apache.org/jira/browse/HIVE-12165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14960158#comment-14960158 ] Chetna Chaudhari commented on HIVE-12165: - [~ErwanMAS]: +1 I am able to reproduce this issue. A

[jira] [Commented] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14906596#comment-14906596 ] Chetna Chaudhari commented on HIVE-11735: - [~xuefuz] I tested it on master branch, but we use

[jira] [Updated] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11735: Affects Version/s: 0.14.0 1.0.0 1.1.1

[jira] [Commented] (HIVE-11864) If the specific location does not exist while creating table, tip information is ambiguous.

[ https://issues.apache.org/jira/browse/HIVE-11864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14802838#comment-14802838 ] Chetna Chaudhari commented on HIVE-11864: - [~Hison Huang] : Unable to reproduce this. If user has

[jira] [Commented] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14732343#comment-14732343 ] Chetna Chaudhari commented on HIVE-11735: - Issue is occurring while generating OPTree . Causes:

[jira] [Assigned] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari reassigned HIVE-11735: --- Assignee: Chetna Chaudhari > Different results when multiple if() functions are used

[jira] [Updated] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11735: Attachment: HIVE-11735.patch Attaching patch for the suggested approach. Please review it.

[jira] [Updated] (HIVE-11735) Different results when multiple if() functions are used

[ https://issues.apache.org/jira/browse/HIVE-11735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chetna Chaudhari updated HIVE-11735: Description: Hive if() udf is returns different results when string equality is used as