[jira] [Created] (HIVE-25908) Hive2.1.1 throws exception when use window function with complex type: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazybinary.LazyBinary*
wu siqiang created HIVE-25908: - Summary: Hive2.1.1 throws exception when use window function with complex type: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazybinary.LazyBinary* Key: HIVE-25908 URL: https://issues.apache.org/jira/browse/HIVE-25908 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 2.1.1 Environment: Hive 2.1.1-cdh6.3.2 Reporter: wu siqiang -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Created] (HIVE-25907) IOW Directory queries fails to write data to final path when query result cache is enabled
Syed Shameerur Rahman created HIVE-25907:
Summary: IOW Directory queries fails to write data to final path
when query result cache is enabled
Key: HIVE-25907
URL: https://issues.apache.org/jira/browse/HIVE-25907
Project: Hive
Issue Type: Bug
Components: Hive
Reporter: Syed Shameerur Rahman
Assignee: Syed Shameerur Rahman
Fix For: 4.0.0
INSERT OVERWRITE DIRECTORY queries fails to write the data to the specified
directory location when query result cache is enabled.
*Steps to reproduce*
{code:java}
1. create a data file with the following data
1 abc 10.5
2 def 11.5
2. create table pointing to that data
create external table iowd(strct struct)
row format delimited
fields terminated by '\t'
collection items terminated by ' '
location '';
3. run the following query
set hive.query.results.cache.enabled=true;
INSERT OVERWRITE DIRECTORY "" SELECT * FROM iowd;
{code}
After execution of the above query, It is expected that the destination
directory contains data from the table iowd, But due to HIVE-21386 it is not
happening anymore.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
[jira] [Created] (HIVE-25906) Clean MaterializedViewCache after q test run
Krisztian Kasa created HIVE-25906: - Summary: Clean MaterializedViewCache after q test run Key: HIVE-25906 URL: https://issues.apache.org/jira/browse/HIVE-25906 Project: Hive Issue Type: Improvement Reporter: Krisztian Kasa -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Created] (HIVE-25905) ORDER BY colName DESC does not honour 'hive.default.nulls.last' property
Alessandro Solimando created HIVE-25905:
---
Summary: ORDER BY colName DESC does not honour
'hive.default.nulls.last' property
Key: HIVE-25905
URL: https://issues.apache.org/jira/browse/HIVE-25905
Project: Hive
Issue Type: Bug
Components: Parser
Affects Versions: 4.0.0
Reporter: Alessandro Solimando
Assignee: Alessandro Solimando
Consider the following table and data:
{noformat}
create table test1
(
a string,
b timestamp,
c timestamp
);
INSERT INTO TABLE test1 VALUES
('John Doe', '1990-05-10 00:00:00.0', '2022-01-10 00:00:00.0'),
('John Doe', '1990-05-10 00:00:00.0', '2021-12-10 00:00:00.0'),
('John Doe', '1990-05-10 00:00:00.0', '2021-11-10 00:00:00.0'),
('John Doe', '1990-05-10 00:00:00.0', '2021-10-10 00:00:00.0'),
('John Doe', '1990-05-10 00:00:00.0', '2021-09-10 00:00:00.0'),
('John Doe', '1987-05-10 00:00:00.0', '2022-01-10 00:00:00.0'),
('John Doe', '1987-05-10 00:00:00.0', '2021-12-10 00:00:00.0'),
('John Doe', '1987-05-10 00:00:00.0', '2021-11-10 00:00:00.0'),
('John Doe', '1987-05-10 00:00:00.0', '2021-10-10 00:00:00.0'),
('John Doe', '1987-05-10 00:00:00.0', null);{noformat}
Consider also the following query:
{noformat}
SELECT a, b, c, row_number() OVER (PARTITION BY a, b ORDER BY b DESC, c DESC)
FROM test1;
{noformat}
The output is:
{noformat}
John Doe10/05/1990 00:0010/01/2022 00:001
John Doe10/05/1990 00:0010/12/2021 00:002
John Doe10/05/1990 00:0010/11/2021 00:003
John Doe10/05/1990 00:0010/10/2021 00:004
John Doe10/05/1990 00:0010/09/2021 00:005
John Doe10/05/1987 00:00NULL1
John Doe10/05/1987 00:0010/01/2022 00:002
John Doe10/05/1987 00:0010/12/2021 00:003
John Doe10/05/1987 00:0010/11/2021 00:004
John Doe10/05/1987 00:0010/10/2021 00:005{noformat}
While the expected output should be:
{noformat}
John Doe10/05/1990 00:0010/01/2022 00:001
John Doe10/05/1990 00:0010/12/2021 00:002
John Doe10/05/1990 00:0010/11/2021 00:003
John Doe10/05/1990 00:0010/10/2021 00:004
John Doe10/05/1990 00:0010/09/2021 00:005
John Doe10/05/1987 00:0010/01/2022 00:001
John Doe10/05/1987 00:0010/12/2021 00:002
John Doe10/05/1987 00:0010/11/2021 00:003
John Doe10/05/1987 00:0010/10/2021 00:004
John Doe10/05/1987 00:00NULL5{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
[jira] [Created] (HIVE-25904) ObjectStore's updateTableColumnStatistics is not ThreadSafe
Denys Kuzmenko created HIVE-25904: - Summary: ObjectStore's updateTableColumnStatistics is not ThreadSafe Key: HIVE-25904 URL: https://issues.apache.org/jira/browse/HIVE-25904 Project: Hive Issue Type: Bug Reporter: Denys Kuzmenko -- This message was sent by Atlassian Jira (v8.20.1#820001)
