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)