The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Table data is not displayed in Column Format.
Hi,
I have a Sample data which consist only 6 rows. Whenever i want to display it in columnar format, it display in text format. I already follow this steps.
1)CREATE FLEX TABLE Sample_Data_1 ();
2)COPY Sample_Data_1 FROM '/tmp/RF_Data_1.csv' PARSER fcsvparser();
3)SELECT maptostring(raw) FROM Sample_Data_1;
4)SELECT compute_flextable_keys_and_build_view('Sample_Data_1');
Both screenshot (Sample Data & Its Result) are attached below.
Bhargav,
Regards
0
Best Answer
-
emoreno Employee
Hi,
You need to
SELECT build_flextable_view('Sample_Data_1');
SELECT * from public. Sample_Data_1_view;
Columnar format is in the view.
Eugenia1
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Hi Emoreno,
It's working. Thanks for support.