Problems with FROM

[peterparkerspicklepatch]

Ran the following, FTUE.Complete <- breakingbad %>% tbl('sys_fte_flow') %>% select(fte_complete =_fte_complete_b, device_token =device_token_s) %>% group_by(device_token) %>% summarise(fte_complete) %>% collect()

Returned, Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for ", : Unable to retrieve JDBC result set for SELECTdevice_token,fte_complete FROM (SELECTdevice_token,fte_completeASfte_complete FROMsys_fte_flow GROUP BYdevice_token) ASzzz5([Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: couldn't resolve column reference: 'device_token' ), Query: SELECTdevice_token,fte_complete FROM (SELECTdevice_token,fte_completeASfte_complete FROMsys_fte_flow GROUP BYdevice_token) ASzzz5.)

[piersharding]

Hi -

Can you distil this into a simple example from the lahman dataset so I can recreate the problem?

Thanks, Piers.