TIMESTAMP is a reserved keyword in both Calcite and the SQL standard. If you insist on using it as a table or column name, you must enclose it in double-quotes when you use it in a query.
Julian > On Mar 22, 2019, at 5:22 AM, YuZhao Chen <[email protected]> wrote: > > timestamp is neither a keyword nor a builtin function in Calcite now, so > what is the stackTrace your query throw ? Can you show us more details ? > > Best, > Danny Chan > > Suhail Aliyar <[email protected]> 于2019年3月22日周五 上午2:26写道： > >> Hello, >> >> I am Suhail Aliyar, Backend developer at dexlock technologies, Kochi, >> India. >> >> I am using calcite server for validating SQL queries in my MSSQL server >> using java in my application. While using your latest version(1.18.0) from >> maven, The validator throws exceptions. The queries are given below. I have >> tried the same queries from DBeaver and I am able to fetch results. >> >> Sample Queries: >> 1. select timeStamp from <table name>; >> 2. SELECT *, FLOOR(timeStamp / (1000)) % 60 AS seconds FROM >> dbo.enriched_video >> 3. SELECT *, CONVERT(VARCHAR,DATEADD(ms,timestamp,0),108) AS time FROM >> dbo.enriched_video >> >> In my table I have a attribute names "timeStamp". >> >> Can anyone please provide me some quick help to make support to these >> keywords. Thanks for helping. >> >> *Thanks & Regards* >> *Suhail Aliyar* >> *Software Engineer* >> *Mob:+91 9846449816* >> *Website: www.dexlock.com <http://www.dexlock.com>* >>
