[jira] [Created] (HIVE-25303) CTAS hive.create.as.external.legacy tries to place data files in managed WH path
Sai Hemanth Gantasala created HIVE-25303: Summary: CTAS hive.create.as.external.legacy tries to place data files in managed WH path Key: HIVE-25303 URL: https://issues.apache.org/jira/browse/HIVE-25303 Project: Hive Issue Type: Bug Components: HiveServer2, Standalone Metastore Reporter: Sai Hemanth Gantasala Assignee: Sai Hemanth Gantasala Under legacy table creation mode (hive.create.as.external.legacy=true), when a database has been created in a specific LOCATION, in a session where that database is USEd, tables created using CREATE TABLE AS SELECT should inherit the HDFS path from the database's location. Instead, Hive is trying to write the table data into /warehouse/tablespace/managed/hive// -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25302) Add support for New MR API (org.apache.hadoop.mapreduce InputFormat and OutputFormat)
Naresh P R created HIVE-25302: - Summary: Add support for New MR API (org.apache.hadoop.mapreduce InputFormat and OutputFormat) Key: HIVE-25302 URL: https://issues.apache.org/jira/browse/HIVE-25302 Project: Hive Issue Type: New Feature Reporter: Naresh P R We have the mapred InputFormat and OutputFormat, but we need one for the newer API. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25301) Expose notification log table through sys db
Ayush Saxena created HIVE-25301: --- Summary: Expose notification log table through sys db Key: HIVE-25301 URL: https://issues.apache.org/jira/browse/HIVE-25301 Project: Hive Issue Type: Improvement Reporter: Ayush Saxena Assignee: Ayush Saxena Expose the notification_log table in RDBMS through Hive sys database -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25300) Fix hive conf items validator type
Jeff Min created HIVE-25300: --- Summary: Fix hive conf items validator type Key: HIVE-25300 URL: https://issues.apache.org/jira/browse/HIVE-25300 Project: Hive Issue Type: Improvement Reporter: Jeff Min Hive conf items should use RangeValidator # hive.mv.files.thread # hive.load.dynamic.partitions.thread # hive.exec.input.listing.max.threads -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-25299) Casting timestamp to numeric data types is incorrect
Adesh Kumar Rao created HIVE-25299:
--
Summary: Casting timestamp to numeric data types is incorrect
Key: HIVE-25299
URL: https://issues.apache.org/jira/browse/HIVE-25299
Project: Hive
Issue Type: Bug
Components: UDF
Affects Versions: 3.1.2, 4.0.0
Reporter: Adesh Kumar Rao
Assignee: Adesh Kumar Rao
Fix For: 4.0.0
*Hive 1.2.1*
{noformat}
Connected to: Apache Hive (version 1.2.1000.2.6.5.3033-1)
Driver: Hive JDBC (version 1.2.1000.2.6.5.3033-1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.6.5.3033-1 by Apache Hive
0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as int);
+-+--+
| _c0 |
+-+--+
| 1615658400 |
+-+--+
1 row selected (0.387 seconds)
0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as bigint);
+-+--+
| _c0 |
+-+--+
| 1615658400 |
+-+--+
1 row selected (0.369 seconds)
0: jdbc:hive2://zk0-nikhil.ae4yqb3genuuvaozdf> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as double);
+--+--+
| _c0 |
+--+--+
| 1.6156584E9 |
+--+--+
{noformat}
*Hive 3.1, 4.0*
{noformat}
Connected to: Apache Hive (version 3.1.0.3.1.6.1-6)
Driver: Hive JDBC (version 3.1.4.4.1.4.8)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.4.4.1.4.8 by Apache Hive
0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as int);
+-+
| _c0 |
+-+
| 1615683600 |
+-+
1 row selected (0.666 seconds)
0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as bigint);
+-+
| _c0 |
+-+
| 1615683600 |
+-+
1 row selected (0.536 seconds)
0: jdbc:hive2://zk0-nikhil.usmltwlt0ncuxmbost> select cast ( cast ("2021-03-14
01:00:00" as timestamp) as double);
+--+
| _c0 |
+--+
| 1.6156836E9 |
+--+
1 row selected (0.696 seconds)
{noformat}
The issue occurs for non-UTC timezone.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
