Where clause when querying a flex table

Hello All,
I am very new t Vertica so sorry if I am asking a basic question, bt I couldn't find the answer anywhere.
I was wondering how to run a simple: select * from table where column = "blabla"
with table being a flex table populated with some json.
That does not seem to work as I get an error from Vertica saying the column "blabla" does not exist.
Any help will be greatly appreciated!
Thanks.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.