Issue with top_n

[earino]

I am now using Vertica and vRODBC, I attempt the following simple pipeline:

highlights_table %>% 
    group_by(isbn) %>% 
    summarise(count=n()) %>% 
    arrange(desc(count)) %>% 
    top_n(10) 

and I receive

1       42601 4856 ERROR 4856:  Syntax error at or near "DESC" at character 67\n

This generates the query:

> q$query
<Query> SELECT "isbn", "count"
FROM (SELECT "isbn", "count", rank("count" DESC) OVER () AS "zzz25"
FROM (SELECT "isbn", count(*) AS "count"
FROM vst_notes."highlights"
GROUP BY "isbn") AS "zzz24"
ORDER BY "count" DESC) AS "zzz26"
WHERE "zzz25" <= 10.0
ORDER BY "count" DESC
An object of class "VerticaConnection"
Slot "conn":
vRODBC Connection 6
Details:
  case=nochange
  DSN=devvertica

Slot "type":
[1] "ODBC"

Which is invalid SQL. Is top_n not implemented?

[earino]

FYI, I know I shouldn't name the variable "count", so here is an example where I call it: "mysuperspecialvariable":

> highlights_table %>% group_by(isbn) %>% summarise(mysuperspecialvariable=n()) %>% top_n(10) 
Selecting by mysuperspecialvariable
Source: Vertica ODBC Connection
-----+DSN: devvertica
-----+Host: LVICVERTICAT01
-----+DB Version: 07.01.0002
-----+ODBC Version: 03.80
From: <derived table> [?? x 2]
Filter: min_rank(desc(mysuperspecialvariable)) <= 10 

   X.42601.4856.ERROR.4856...Syntax.error.at.or.near...DESC...at.character.118.n.
                                                                           (fctr)
1       42601 4856 ERROR 4856:  Syntax error at or near "DESC" at character 118\n
..                                                                            ...
Variables not shown:
  X..vRODBC..ERROR..Could.not.SQLExecDirect..SELECT...isbn......mysuperspecialvariable...nFROM..SELECT...isbn......mysuperspecialvariable....rank...mysuperspecialvariable...DESC..OVER....AS...zzz63...nFROM..SELECT...isbn....count....AS...mysuperspecial
  ... (fctr)

[etduwx]

@earino ,

Thanks for reporting this; I'll take a look.

Best,
Ed