[Explicitly adding jiri.troup in case sender is not on dev@ list] Actually, that docs error is in upstream documentation [0], and that's where this should be fixed. Cloudera should then incorporate the change from upstream.
https://issues.apache.org/jira/browse/IMPALA-5348 filed to address the problem. [0] http://impala.apache.org/docs/build/html/topics/impala_literals.html On Mon, May 22, 2017 at 8:36 AM, Vincent Tran <[email protected]> wrote: > Hi Jiri, > > > > Thanks for reporting. Can you please open a support case for this issue so > that we can track it more effectively? > > > > http://support.cloudera.com > > > > Cheers, > > > > Vincent > > > > > > From: "Troup, Jiri" <[email protected]> > Reply-To: <[email protected]> > Date: Monday, May 22, 2017 at 5:57 AM > To: "[email protected]" <[email protected]> > Subject: error in documentation - timestamp_literals > > > > I have found issue in your documentation > > > > I’m using > > > > impalad version 2.7.0-cdh5.9.0 RELEASE (build > 4b4cf1936bd6cdf34fda5e2f32827e7d60c07a9c) Built on Fri Oct 21 01:07:22 > PDT 2016 > > > > In documentation > > > > https://www.cloudera.com/documentation/enterprise/5-9- > x/topics/impala_literals.html#timestamp_literals > > > > you say : > > > > 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. > See TIMESTAMP Data Type for details. > > > > When I run query > > > > select '1966-07-30' + interval 1 year; --doesn’t work > !!! but according your doc. this should work. > > select cast('1966-07-30' as timestamp) + interval 1 year; --have to > manually cast to timestamp > > > > > > Jiří Troup > Consultant > > > > Adastra > Nile House > Karolinská 654/2 > 186 00 Praha 8 > Czech Republic > > > > [email protected] > www.adastra.cz > www.adastragrp.com > > Follow Adastra Czech Republic on LinkedIn, Facebook and YouTube. > > > > > >
