Aggregation function sum error

[chirdeeptomar]

Hello,

We are trying to sum up the volume and getting a 500 on the Web Admin UI without any notification.

WITH entries[THIS IS com.epam.deltix.qsrv.hf.tickdb.ui.tbshell.SimpleBarMessage] AS 'entries'
SELECT sum{}(sum(entries.volume)) AS 'volume'
FROM bars
WHERE timestamp BETWEEN '2005-03-01 14:00:00.000'd AND '2005-03-01 15:00:00.000'd and symbol=='AAPL'

Error in shell

==> WITH entries[THIS IS com.epam.deltix.qsrv.hf.tickdb.ui.tbshell.SimpleBarMessage] AS 'entries'
SELECT sum{}(sum(entries.volume)) AS 'volume'
FROM bars
WHERE timestamp BETWEEN '2005-03-01 14:00:00.000'd AND '2005-03-01 15:00:00.000'd and symbol=='AAPL'
>>> Error: WITH: unrecognized command. (Type ? for usage)
==> >>> Error: CompilationException: 1.18..25: UnknownIdentifierException: Unknown identifier: ENTRIES
==> >>> Error: FROM: unrecognized command. (Type ? for usage)
==> >>> Error: WHERE: unrecognized command. (Type ? for usage)

Can you please advise, what we might be doing wrong?

Thanks

[alex-karpovich]

Сould you please share stream schema? I think such types of queries applicable for our 'Universal' data format only:
For messages like this PackageHeader.java.txt

[chirdeeptomar]

Its the sample stream "bars" given by TimeBase.

set db dxtick://localhost:8011 
open
generate bars 
exit

[chirdeeptomar]

We were able to figure out the error. Admin UI is still broken as doesn't give out any errors and you have to look at the developer console in the browser.

[alex-karpovich]

Please try this project https://github.com/epam/TimebaseCryptoConnectors

to be able to receive data from crypto exchanges in L2 data format.

[alex-karpovich]

Its the sample stream "bars" given by TimeBase.

set db dxtick://localhost:8011 
open
generate bars 
exit

for the 'bars' stream you can do only simple selects like aggregation, count, etc.
bars contains only OHLC fields, without complex structures like arrays/objects compare to L2 data