[HIVE-13557] Make interval keyword optional while specifying DAY in interval arithmetic - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 2.1.0
Fix Version/s: 2.2.0
Component/s: Types
Labels:
None

Description

Currently we support expressions like:

WHERE SOLD_DATE BETWEEN ((DATE('2000-01-31'))  - INTERVAL '30' DAY) AND DATE('2000-01-31')

We should support:

WHERE SOLD_DATE BETWEEN ((DATE('2000-01-31')) + (-30) DAY) AND DATE('2000-01-31')

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

HIVE-13557.1.patch
17/Oct/16 16:43
23 kB
Zoltan Haindrich
HIVE-13557.1.patch
17/Oct/16 19:40
23 kB
Zoltan Haindrich
HIVE-13557.1.patch
18/Oct/16 05:58
23 kB
Zoltan Haindrich
HIVE-13557.2.patch
15/Nov/16 00:16
49 kB
Zoltan Haindrich
HIVE-13557.3.patch
15/Nov/16 23:35
50 kB
Zoltan Haindrich
HIVE-13557.3.patch
16/Nov/16 11:13
50 kB
Zoltan Haindrich

Issue Links

is related to

HIVE-15271 Interval support - full sql-2011 compliance

Open

relates to

HIVE-9792 Support interval type in expressions/predicates

Closed

HIVE-15388 HiveParser spends lots of time in parsing queries with lots of "("

Closed

links to

Activity

People

Assignee:: Zoltan Haindrich

Reporter:: Ashutosh Chauhan

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 20/Apr/16 06:36

Updated:: 26/Jul/17 03:30

Resolved:: 19/Nov/16 00:05