search

timestored / pulseui

Real-time interactive database applications
https://www.timestored.com/pulse/
Other
81 stars 10 forks source link

pivot not working on dolphindb #292

Open ryanhamilton opened 5 months ago

ryanhamilton commented 5 months ago

user-lin user-tt

Pulse version: 3.13
Server: linux ubuntu 20
Backend db: dolphindb v2.00.143
Raw SQL: select * from OrderReport 
Table schema: attachment
Pivot column: Account
Error:
SELECT "Account", count(*) as "c" FROM (select * from OrderReport ) GROUP BY "Account" ORDER BY "Account"

FIX:
Change bellow SQL FROM
SELECT "Account", count(*) as "c" FROM (select * from OrderReport ) GROUP BY "Account" ORDER BY "Account"
TO
SELECT Account, count(*) as "c" FROM (select * from OrderReport ) GROUP BY Account ORDER BY Account
OR
SELECT `Account`, count(*) as "c" FROM (select * from OrderReport ) GROUP BY `Account` ORDER BY `Account`