Virtual SuperTable + ASOF JOIN WHERE TAGS are equal #30919
Unanswered
d4munche3z
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
The documentation doesn't seem to clearly describe how to create a Virtual Supertable, at least not that I can make sense of. I want to create a vtable that is an ASOF JON between two supertables where their tags are equal. The source stables are created through these statements. Any advice on how to accomplish this would be appreciated.
CREATE STABLE IF NOT EXISTS HISTORICAL.trades (
tsTIMESTAMP,dateVARCHAR(10),exchangeBINARY(16373),priceDOUBLE,sizeBIGINT,conditionsBINARY(16373),idBINARY(16373),tapeBINARY(8192) ) TAGS ( symbol BINARY(10) )CREATE STABLE IF NOT EXISTS HISTORICAL.quotes (
tsTIMESTAMP,dateVARCHAR(10),ask_exchangeBINARY(16373),ask_priceDOUBLE,ask_sizeBIGINT,bid_exchangeBINARY(16373),bid_priceDOUBLE,bid_sizeBIGINT,conditionsBINARY(8192),tapeBINARY(16373) ) TAGS ( symbol BINARY(10) )Beta Was this translation helpful? Give feedback.
All reactions