Michael Brown created IMPALA-5348:
-------------------------------------

             Summary: remove mention of stringized timestamp literals with 
interval expressions
                 Key: IMPALA-5348
                 URL: https://issues.apache.org/jira/browse/IMPALA-5348
             Project: IMPALA
          Issue Type: Bug
          Components: Docs
    Affects Versions: Impala 2.9.0
            Reporter: Michael Brown
            Assignee: John Russell


http://impala.apache.org/docs/build/html/topics/impala_literals.html mentions 
being able to apply {{INTERVAL}} expressions to strings that will be able to be 
coerced as timestamps, 

bq. You can also use INTERVAL expressions to add or subtract from timestamp 
literal values, such as '1966-07-30' + INTERVAL 5 YEARS + INTERVAL 3 DAYS.

but a user pointed out on dev@ that this is wrong:

{noformat}
[localhost:21000] > SELECT '1966-07-30' + INTERVAL 1 YEAR;
ERROR: AnalysisException: Operand ''1966-07-30'' of timestamp arithmetic 
expression ''1966-07-30' + INTERVAL 1 YEAR' returns type 'STRING'. Expected 
type 'TIMESTAMP'.

[localhost:21000] >
{noformat}

Documentation should be altered to fix this.

It looks like [~jrussell] pointed this out in IMPALA-2293, which was marked as 
a dupe of IMPALA-1503.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to