load data from flex table into a normal table
Hi All,
I have an ecosystem where csv files are generated periodically by a server and have to store them in Vertica for archiving and analysis.
I created flex tables and copied the files into the flex tables and generated keys and views. I get that we can query the flex table views but is there any idea on how to fetch the data from the flex tables into a regular vertica table? i want to use the regular data table for my analytics.Is this data transfer even possible?
Thank you,
Anmol
I have an ecosystem where csv files are generated periodically by a server and have to store them in Vertica for archiving and analysis.
I created flex tables and copied the files into the flex tables and generated keys and views. I get that we can query the flex table views but is there any idea on how to fetch the data from the flex tables into a regular vertica table? i want to use the regular data table for my analytics.Is this data transfer even possible?
Thank you,
Anmol
0
Comments
create table <table-name> as select ... from <flex-table>
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/FlexTables/CreatingFlexTables.htm?Highlight=flex%20table