The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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.
0
Comments
Hello: Did you see the Getting Started in the Flex Tables doc, posted here:
https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/FlexTables/GettingStarted.htm
Is this what you want to do, create a flex, load some json, and find the name of a virtual column?
Hello,
Yes I have been through this page but it didn't answer my question. Using the mountains example, what I'm trying to do is a query like the below:
select * from public.mountains_view where type="volcano";
But this gives me an error saying the column "volcano" does not exist.
Please use single quote instead of double quote for string constant.
select * from public.mountains_view where type='volcano';
Thank you, that did the trick!