[jira] [Commented] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01

[ https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17403489#comment-17403489 ] Anurag Shekhar commented on HIVE-25451: --- As per timezone data from IANA this is correct conversion.

[jira] [Resolved] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01

[ https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar resolved HIVE-25451. --- Resolution: Invalid > from_utc_timestamp uses wrong timezone offset for dates prior to

[jira] [Updated] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01

[ https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-25451: -- Description: from beeline select from_utc_timestamp('1895-12-01', 'Australia/Perth');

[jira] [Updated] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01

[ https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-25451: -- Environment: (was: from beeline select from_utc_timestamp('1895-12-01',

[jira] [Resolved] (HIVE-25470) Hive returns wrong value for select query involving time conversion

[ https://issues.apache.org/jira/browse/HIVE-25470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar resolved HIVE-25470. --- Resolution: Duplicate > Hive returns wrong value for select query involving time conversion

[jira] [Assigned] (HIVE-25470) Hive returns wrong value for select query involving time conversion

[ https://issues.apache.org/jira/browse/HIVE-25470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-25470: - > Hive returns wrong value for select query involving time conversion >

[jira] [Assigned] (HIVE-25056) cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion

[ https://issues.apache.org/jira/browse/HIVE-25056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-25056: - > cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion >

[jira] [Updated] (HIVE-24891) Tablestamp field returns a value different from what was inserted using PreparedStaement.setLong

[ https://issues.apache.org/jira/browse/HIVE-24891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-24891: -- Summary: Tablestamp field returns a value different from what was inserted using

[jira] [Commented] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.

[ https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303158#comment-17303158 ] Anurag Shekhar commented on HIVE-24888: --- This issue could be a side effect of HIVE-24891 > JDBC

[jira] [Updated] (HIVE-24891) Tablestamp field returns a value different from what was inserted using PreparedStaement.setLog

[ https://issues.apache.org/jira/browse/HIVE-24891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-24891: -- Description: Setup Hive Cluster Timezone - UTC JDBC Client Timezone - IST Create timestamp

[jira] [Comment Edited] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.

[ https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17302333#comment-17302333 ] Anurag Shekhar edited comment on HIVE-24888 at 3/16/21, 8:48 AM: - There

[jira] [Commented] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.

[ https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17302333#comment-17302333 ] Anurag Shekhar commented on HIVE-24888: --- There is no exception thrown back to client application.

[jira] [Updated] (HIVE-24818) REPL LOAD of views with partitions fails

[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-24818: -- Summary: REPL LOAD of views with partitions fails (was: REPL LOAD (Bootstrap ) of views with

[jira] [Assigned] (HIVE-24842) SHOW CREATE TABLE on a VIEW with partition returns wrong sql.

[ https://issues.apache.org/jira/browse/HIVE-24842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-24842: - > SHOW CREATE TABLE on a VIEW with partition returns wrong sql. >

[jira] [Commented] (HIVE-24818) REPL LOAD (Bootstrap ) of views with partitions fails

[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17294505#comment-17294505 ] Anurag Shekhar commented on HIVE-24818: --- Steps to reproduce # Create an external table with one

[jira] [Assigned] (HIVE-24818) REPL LOAD (Bootstrap ) of views with partitions fails

[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-24818: - > REPL LOAD (Bootstrap ) of views with partitions fails >