You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
I am now using Vertica and vRODBC, I attempt the following simple pipeline:
and I receive
This generates the query:
Which is invalid SQL. Is top_n not implemented?
The text was updated successfully, but these errors were encountered: