Is there a complete list of reserved words documented? I am going to be giving a talk on Drill to a Users Group in a couple weeks and that would be a great bit of information to share.
On Wed, Jul 30, 2014 at 2:31 PM, Ramana Inukonda <[email protected]> wrote: > year is a reserved keyword. > > select columns[1] as `year` from > dfs.`/drill/testdata/text_storage/lineitem.tbl` limit 10; > > works. > > Regards > > Ramana > > > > > On Wed, Jul 30, 2014 at 12:23 PM, Bob Rumsby <[email protected]> wrote: > > > Should I file a bug for this? > > > > 0: jdbc:drill:zk=local> select columns[0] as year, columns[1] as play > from > > dfs.`/Users/brumsby/drill/plays.csv`; > > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure > while > > running query.[error_id: "4929bef3-1dde-4e51-a9f2-a3722687f139" > > endpoint { > > address: "10.250.0.28" > > user_port: 31010 > > control_port: 31011 > > data_port: 31012 > > } > > error_type: 0 > > message: "Failure while parsing sql. < SqlParseException:[ Encountered > "as > > year" at line 1, column 19. > > Was expecting one of: > > "FROM" ... > > "," ... > > "AS" <IDENTIFIER> ... > > "AS" <QUOTED_IDENTIFIER> ... > > "AS" <BACK_QUOTED_IDENTIFIER> ... > > ... > > > -- *Jim Scott* Director, Enterprise Strategy & Architecture +1 (347) 746-9281 <http://www.mapr.com/> [image: MapR Technologies] <http://www.mapr.com>
