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> ... > ... >
