Table data is not displayed in Column Format.
Bhargav
Vertica Customer
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
Answers
Hi Emoreno,
It's working. Thanks for support.